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 are the main uses of the primary key?
difference between Valuation type and valuation category?
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
What is asynchronous update?
What is Group by in Select statement?
What are internal tables? How to use a specific number occurs statement?
Difference between sy-tabix and sy-index? Can you check sy-subrc after perform?
Explain the advantage of structures?
What are the functional areas, user groups? How does abap query work in relation to these?
How can the standard tables of sap be modified?
Can you assign a matchcode object to a parameter? If so how?
Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?
How will you link form with the event driven in sap scripts?
What is the disadvantage of a call by reference?
What is the difference between collect and append statements?