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
hi.. sap sd is installed in my PC .i m unable to start becoz ,i have given wrong password many times and it's locked.please tell me how can i open SAP logon. tell the process at my id dst.noida@rediffmail.com please advance thanx
How to upload more than 2GB file from External Source to SAP?
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary
What is difference between dialog program and a report?
Explain what is the difference between sy-tabix and sy-index? Where it is used?
Why do we use types statement in abap programming?
What is static attribute
What are the advantages and disadvantages of different types of bdc's?
What is the significance of hide?
How to call transaction in session method without recording?
What is the difference between Classic badi and Kernal badi ?
Print options in smartforms?
What is a database view? : abap data dictionary
What is the master data necessary before you can start posting in MM?
What are the organizational related infotypes? : abap hr