how can i fetch the records of 3 tables with a single select
query,without using join.
Answer Posted / anurag joshi
records can be fetched from 3 tables using a single select
statement using the CHAIN OPERATOR in select statement....
select : vbeln posnr matnr from VBAK into table i_abc1
where vbeln = s_vbeln,
vbeln1 posnr1 matnr1 from VBAk1 into table i_abc2
where posnr2 = s_posnr,
vbeln2 posnr2 matnr2 from VBAK2 into table i_abc3
where matnr2 = s_matnr2.
..the only difference which makes is the chain operator.
Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is tcode se16? For what is it used.
How to specify a client for database table processing?
What is use of transparent table in abap? How it is different from pool tables?
What is the difference between open_form and close_form?
How to select valid lines for secondary list?
Why do we use dynamic where conditions?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
What is view proxy in abap?
Have you processed BDCs ?
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization
What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary
Difference between Field groups and internal tables?
What is macro? : abap hr
What is the different between abap and ooabap? Why do we use ooabap?
How can you distinguish between different kinds of parameters?