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 are BAPI different from Normal function modules ?
How to find Kernal badi ?
Explain what is an rdbms?
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
What is meant by hide area?
Name the special commands of list?
What is the table & field to identify the no of items (bottles) stored in one case?
What are base tables of an aggregate object? : abap data dictionary
Difference between sy-tabix and sy-index? Where it is used?
Explain what is the step-by-step process to create a table in data dictionary?
What is the difference between dialog program and a report?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
Explain the difference between domain and data element?
How many structures can be created in a Ztable ?
Explain the Inportance of pa40? : abap hr