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
What is img? : sap abap hr
What are the difference between tables and structures?
Does every abap/4 have a modular structure?
What are Delivery classes? What data will you want to transport during client copy?
How to call other programs?
What is the use of table maintenance allowed?
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?
What is meant by a schema? : sap abap hr
What is the different between abap and ooabap? Why do we use ooabap?
Explain what are the events used in interactive reports?
How to display or know if the value entered contains records or not?
Explain the uses of the simple maintenance interface? : sap abap hr
what is diff between idocs,bdc,rfc and bapi. give real time answer
It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization
What are the main uses of the primary key?