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 is hotspot?
What does hide statement do?
What are the system fields you have worked with? Explain?
Explain sap abap 3-tier architecture?
How to get that a secondary index is attached to a select query?
Can you print decimals in type n?
How can we decide weather we can enhance the standard infotype or not ? : abap hr
How can we handle table control in bdc? : abap bdc
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
What is the meaning of table buffer? This buffer is used by which type oftable?
how can we enable hyperlink in screen painter?
Does the external program run in the same sap luw as the caller, or in a separate one?
Explain some essential objects in abap dictionary?
How do you execute the payroll
What is an abap/4 query? : abap hr