Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 34177 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 are the two ways of producing a list within a transaction?
Why cant we use Normal function module for data transfer?
How can we access the correction and transport system? : abap data dictionary
Explain the difference between get and get late?
What are the dynapro keywords?
What are local objects? : abap data dictionary
Did you create secondary index?
What is a development class? : abap data dictionary
What is meant by performance analysis? Have done anything to improve the performance?
How the transaction that are programmed by the user can be protected?
What is generic area buffering in abap?
What are th control break events in abap?
What are the differences between domain and data element?
Abstract class and interface, multiple inheritance, live example
Give an example of interface from your project explaining why you used it?
