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...

Give the syntax of Inner,outer Join?"

Answer Posted / ravi ranjan

*&-----------------------------------*
*& Report ZSELECT_STA *
*& *
*&-----------------------------------*
*& Author : Ravi Ranajn upadhyay *
*& *
*&-----------------------------------*

REPORT zselect_sta.
TABLES: mara.
TYPES:BEGIN OF it_mara,
ernam TYPE mara-ernam,
matnr TYPE mara-matnr,
meins TYPE mara-meins,
burks TYPE ekpo-bukrs,
werks TYPE ekpo-werks,
END OF it_mara.

DATA:its_mara TYPE TABLE OF it_mara,
wa_mara TYPE it_mara.

SELECT m~matnr m~ernam m~meins k~werks k~bukrs
INTO CORRESPONDING FIELDS OF TABLE its_mara
FROM mara AS m inner JOIN ekpo AS k
ON m~matnr = k~matnr.


LOOP AT its_mara INTO wa_mara.
WRITE: / wa_mara-ernam,
wa_mara-matnr,
wa_mara-meins,
wa_mara-burks,
wa_mara-werks.
ENDLOOP.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is img? : sap abap hr

1116


What are the difference between tables and structures?

1176


Does every abap/4 have a modular structure?

1013


What are Delivery classes? What data will you want to transport during client copy?

1394


How to call other programs?

1042


What is the use of table maintenance allowed?

1040


Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?

994


What is meant by a schema? : sap abap hr

1103


What is the different between abap and ooabap? Why do we use ooabap?

1152


Explain what are the events used in interactive reports?

944


How to display or know if the value entered contains records or not?

986


Explain the uses of the simple maintenance interface? : sap abap hr

1035


what is diff between idocs,bdc,rfc and bapi. give real time answer

19490


It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization

1306


What are the main uses of the primary key?

1209