how can i fetch the records of 3 tables with a single select
query,without using join.
Answer Posted / sukanta brahma
REPORT ZFFFFFFF.
TABLES: mara, makt, vbak.
TYPES: BEGIN OF xitab.
INCLUDE STRUCTURE vbak.
TYPES:END OF xitab.
TYPES: BEGIN OF yitab.
INCLUDE STRUCTURE mara.
TYPES:END OF yitab.
TYPES: BEGIN OF zitab.
INCLUDE STRUCTURE makt.
TYPES:END OF zitab.
data:i_abc1 type STANDARD TABLE OF xitab WITH HEADER
LINE,
i_abc2 TYPE STANDARD TABLE OF yitab WITH HEADER
LINE,
i_abc3 TYPE STANDARD TABLE OF zitab WITH HEADER
LINE.
select : vbeln from VBAK into CORRESPONDING FIELDS OF
TABLE i_abc1
where vbeln
= '0000004969',
matnr from mara into CORRESPONDING FIELDS OF TABLE
i_abc2
where matnr = '102-310',
maktx from makt into CORRESPONDING FIELDS OF TABLE
i_abc3
where maktx = 'Test
material'.
WRITE:/ 'Experiment successful'.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How to write a bdc – how do you go about it?
Difference between user exit and badis?
How can we use multiple transactions by using bdc_insert? : abap bdc
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 database utility?
Will 50,000 records be uploaded directly into APP's Server?
How do you Export a session ?
What is page window?
What is native sql?
MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?
What are two different ways to add fields to sap tables?
What are the different types of the variable in the sap abap?
How will you transfer data into a file in application server?
What is a table cluster? : abap data dictionary
What are Tickets in Realtime ?