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 database utility? : abap data dictionary

1024


What kind of BDC programs are written ?

1009


What is the differrences between structure and table in data dictionary in abap? : abap hr

1154


What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?

2662


Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc

1126


What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1

3716


What is the syntax of packed number?

1142


hi,how to diable the popup window which is displayed afetr executing the SAP script program?

2035


how to capture the errors in bdc Call transaction method?

1021


what is the process of creating quotation using BAPIs.

2007


Program lines for the radio button selection and unabling some input variables in section screen

1369


What is off cycle payroll run

2399


What are the system table used in abap?

1079


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

2012


What is tcode se16? For what is it used.

1047