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
Final class
What is processing class, where we do them and why? : sap abap hr
How to insert a line into abap internal tables?
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
What is a development class? : abap data dictionary
What are the prerequisites for creating foreign key relationship?
What is an interactive report?
Can there be more than 1 main window in sap script?
What is off cycle payroll run
What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?
What is the difference between commit-work and rollback-work tasks?
What are the differences between table and structure in data dictionary?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
What are the different function modules used in sapscript?
What are null values?