how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 32356 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
What are Tickets in Realtime ?
How are BAPI different from normal function modules?
How many types of views are there ?
What are the data types of the external layer? : abap data dictionary
how to capture the errors in bdc Call transaction method?
SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul
What are the basic objects of the data dictionary? : abap data dictionary
What is the difference between a structure and a table?
How will you define posting procedures?
Concepts of OO ABAP and why we are using it?
What is the use of the statement leave to list-processing?
How do you find if a logical database exists for your program requrements?
Table events aNd table maintains generation
What are the different types joins?
What is the table & field to identify the no of items (bottles) stored in one case?
