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
What are the types of windows in sap script?
Explain the difference between free and refresh?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?
Explain what is sap script? What is the purpose of sap script?
In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr
Which table stores the programs created?
How to combine multiple billing into one RV document ( Step by Step)?
What is the difference between dialog program and a report?
What are the difference between call screen and leave screen?
What is personnel sub are
How do you write manual bdc session method? : abap bdc
What is the significance of the screen number ‘0’?
What two statements are required in an abap program to output an icon using a write statement?
Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr
What data is contained in data dictionary? : abap data dictionary