how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 30331 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
How do you send files to the legacy systems from SAP and vice versa? How does one know that the legacy files have come on to the SAP server you are working on?
What is the difference between rfc and bapi function modules? : abap bdc
Can we use flow logic control key words in abap/4 and vice-verse?
What are the field and chain statements?
What are the abap/4 commands that link to a layout set?
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
Double click function on the lists, identifying the line selected by the user on the list?
What is the function of a domain? : abap data dictionary
How many types of data classes are there in sap?
What are different types of parameters?
What is singleton pattern in OOPS?
How will you transfer data into a file in application server?
Explain what is the difference between sy-tabix and sy-index? Where it is used?
Which bdc you prefer? : abap bdc
Have you processed BDCs ?
