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
- 33754 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
Explain some essential objects in abap dictionary?
Why do we use abstract class
What are the function modules used in f4 help?
What is a subscreen? How can we use a subscreen?
What is new enhancement framework?
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
What are the tcodes for performance tuning?
What are the update types possible? : abap data dictionary
Can we access static attribute from instance method
What is view? Different types of view. Explain?
What are the dynapro keywords?
hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.
Define external layer? : abap data dictionary
Is the basic list deleted when the new list is created?
What are conversion routines? : abap data dictionary
