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
Difference between BDC vs Direct Loads?
How are the function code handles in flow logic?
What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc
Explain what is the difference between sy-tabix and sy-index? Where it is used?
What is lock mechanism? How do we create lock objects in abap?
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
What are the components of selection table?
when does a list get sent to the screen on the presentation layer?
What are roles and authorization objects?
What is the Process to transfer IDOC from Outbound System to Inbound system.
What is search help exit? : sap abap data dictionary
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
What is a database view? : abap data dictionary
Can you assign a matchcode object to a parameter? If so how?
What are number ranges?