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 database utility? : abap data dictionary
What kind of BDC programs are written ?
What is the differrences between structure and table in data dictionary in abap? : abap hr
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1
What is the syntax of packed number?
hi,how to diable the popup window which is displayed afetr executing the SAP script program?
how to capture the errors in bdc Call transaction method?
what is the process of creating quotation using BAPIs.
Program lines for the radio button selection and unabling some input variables in section screen
What is off cycle payroll run
What are the system table used in abap?
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
What is tcode se16? For what is it used.