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
How the at-user command serves mainly in lists?
What is logical database? : abap hr
Explain different types of locks?
What is the Process to transfer IDOC from Outbound System to Inbound system.
What are client dependant objects in abap/sap?
how to see the tables of 200 in client 100?
What is the process to enhance the Infotype
How to Solve a Particular Ticket in Realtime ?
What is value table?
What are the objects of the abap dictionary or what types of objects can be created in the abap dictionary? : abap data dictionary
what is the transaction transaction for setting parameters rdisp/buffermode
I am uploading 100 records out of which say 59th record has error so what will happen if I am using synchronous or asynchronous method of bdc? Can we update the database using local update mode how? : abap bdc
What is use of transparent table in abap? How it is different from pool tables?
Can i Have Some Realtime Examples On Modulepool programming.
What are the difference between tables and structures? : abap data dictionary