how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 30455 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / subhasis
using nested select statement we can fectch the data from 3
table.
like
select f1 f2 f3 from table1 into table wa_t1
slect l1 l2 l3 from table2 into table wa_t2
select e1 e2 e3 from table3 into table wa_t2
endselect.
endselect.
endselect.
If I was wrong pls let me inform
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
Where do you find info on new developments in SAP?
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
Write syntax for message error (report)?
Which FM do you use to find out who is reporting to whom
how to modify the standard method as per your requirement
What abap statement will trigger list generation?
What is a data element?
What is bdc programming? : abap bdc
Describe the difference between macro and subroutine?
What is the difference between sum and collect?
Which type of tables used this buffer?
1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?
2)In production what is the user exit?
Is main window mandatory in smartforms?
Can a domain, assigned to a data element be changed?
