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
Does sap handle multiple languages?
can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.
What are your ways to performance optimization?
What is the difference between sy-tabix and sy-index? Where it is used?
What are the disadvantages of abap query tool?
What was the requirement of IDoc in your project? How it was working?
What is a data class? : abap data dictionary
How can we send data to external programs?
What is the difference between function group and function module?
What is the difference between open_form and close_form?
What are the components of sapscript?
Explain the difference between call screen and leave screen?
Explain what are standard layouts sets in the sap script?
Define infotype ? : abap hr
What is get cursor field?