Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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 is hotspot?

1385


What does hide statement do?

966


What are the system fields you have worked with? Explain?

1062


Explain sap abap 3-tier architecture?

1202


How to get that a secondary index is attached to a select query?

1323


Can you print decimals in type n?

932


How can we decide weather we can enhance the standard infotype or not ? : abap hr

1049


How can we handle table control in bdc? : abap bdc

1074


If I want to execute a program only in background not in foreground is there any option for this? : abap bdc

970


What is the meaning of table buffer? This buffer is used by which type oftable?

1176


how can we enable hyperlink in screen painter?

3878


Does the external program run in the same sap luw as the caller, or in a separate one?

1072


Explain some essential objects in abap dictionary?

1133


How do you execute the payroll

2531


What is an abap/4 query? : abap hr

1043