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 web dynpro for abap?
Does every abap/4 have a modular structure?
What are the two different ways of building a match code object? : abap data dictionary
What are the dynamic actions and how to configure it? : sap abap hr
How many types of buffering? : abap data dictionary
Double click function on the lists, identifying the line selected by the user on the list?
Does the call transaction method allow multiple transactions to be processed by sap?
what is difference between user exit, customer exit and badi?
What is table attribute? : abap data dictionary
What are the parameters in bdc_insert? : abap bdc
Define dispatcher?
Can you define a field without a data element? : abap data dictionary
How to debug a sapscript?
How does the system handle roll areas for external program components?
What are pooled tables? : abap data dictionary