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
- 34254 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
how can you display data say "your name"in sap script without print program or driver program??
What is img? : sap abap hr
What is ps structure? : abap hr
MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?
Why lsmw does not support call transaction method? : abap bdc
What are the basic components of dialog program?
What is the difference between a structure and an append structure?
What are the different types of abap/4 programs?
Name the abap/4 modularization techniques? : abap modularization
How to determine the attributes of an internal table?
How can we upload a text file having delimiters in to legacy system?
Can we access static attribute from instance method
How does the interection between the dynpro and the abap/4 modules takes place?
What are the disadvantages of logical databases?
Can a filed occur in several field groups? : abap modularization
