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

Difference between BDC vs Direct Loads?

1068


How are the function code handles in flow logic?

1026


What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc

1099


Explain what is the difference between sy-tabix and sy-index? Where it is used?

984


What is lock mechanism? How do we create lock objects in abap?

1102


Why do we declare a method of a class final? What can be the purpose? Give a scenario.

1348


What are the components of selection table?

992


when does a list get sent to the screen on the presentation layer?

1859


What are roles and authorization objects?

1625


What is the Process to transfer IDOC from Outbound System to Inbound system.

2102


What is search help exit? : sap abap data dictionary

1140


What is going life actually? What is the role of a functional consultant in it? : sap abap hr

977


What is a database view? : abap data dictionary

1026


Can you assign a matchcode object to a parameter? If so how?

978


What are number ranges?

1000