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
How collect statement is different from append?
While doing bdc exp va01 transaction sometime in the item level data shows only 4 items and other times it will show 6 line items, how will you maintain this kind of screen resolutions scenerio? : abap bdc
Does the table can have multiple foreign keys?
What are the system table used in abap?
What is the difference between Classic badi and Kernal badi ?
What are the various events associated with screen programming?
What are the different types of parameters?
Explain what are the problems in processing batch input sessions?
wat is the default file name of BAPI trace?
What are client dependant objects in abap/sap?
What is the structure of the bdc table? : abap bdc
Some Realtime Examples on Exits .
What are authorization objects and what statement is used to perform an authorization check in an abap program?
What are the field and chain statements?
What are extracts?