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


Please Help Members By Posting Answers For Below Questions

What is web dynpro for abap?

771


Does every abap/4 have a modular structure?

768


What are the two different ways of building a match code object? : abap data dictionary

813


What are the dynamic actions and how to configure it? : sap abap hr

817


How many types of buffering? : abap data dictionary

901






Double click function on the lists, identifying the line selected by the user on the list?

810


Does the call transaction method allow multiple transactions to be processed by sap?

740


what is difference between user exit, customer exit and badi?

4553


What is table attribute? : abap data dictionary

773


What are the parameters in bdc_insert? : abap bdc

1003


Define dispatcher?

997


Can you define a field without a data element? : abap data dictionary

827


How to debug a sapscript?

801


How does the system handle roll areas for external program components?

837


What are pooled tables? : abap data dictionary

869