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 are the types of windows in sap script?

609


Explain the difference between free and refresh?

588


Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?

611


Explain what is sap script? What is the purpose of sap script?

630


In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr

569






Which table stores the programs created?

619


How to combine multiple billing into one RV document ( Step by Step)?

1543


What is the difference between dialog program and a report?

620


What are the difference between call screen and leave screen?

605


What is personnel sub are

1578


How do you write manual bdc session method? : abap bdc

600


What is the significance of the screen number ‘0’?

566


What two statements are required in an abap program to output an icon using a write statement?

543


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

642


What data is contained in data dictionary? : abap data dictionary

644