Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 34209 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
What are the differences between a database index and a match code? : abap data dictionary
How does the system handle roll areas for external program components?
What are the buffering types?
Explain get pernr concept when we use logical data base? : abap hr
What are logical data bases used in hr module? : abap hr
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
What is step-loop?
What is the max no of match code id’s that can be defined for one match code object?
What kind of financial periods exist in sap? What is the relavent table for that?
What is Transactional based Application & Role based Application?
What is the difference between native sql & open sql? : abap data dictionary
What are datasets in abap?
What is the differences between structure and table in data dictionary in abap?
What is off cycle payroll run
