what are the Joins used for internal Table?
Answers were Sorted based on User's Feedback
Answer / shakthi
for retriving data from more than one internal table we go for joins.
there are two types of joins
inner join,left out joins.
|Is This Answer Correct ?||4 Yes||0 No|
Answer / viswanath
If you want to retry the data from more then one table
connected with common key , we will go for joins (Inner
joines and outer joins).
1. First we will create an internal table wih fields.
data:s_matnr for mara-matnr.
data:Begin of itab occurs 0,
MATNR TYPE MATNR, "FROM MARA TABLE
ERSDA TYPE ERSDA, "FROM MARA TABLE
MAKTX TYPE MAKTX, "FROM MAKT TABLE
end of itab.
2. write select statment.
from makt inner join mara
on a~matnr = b~matnr
into table itab where a~matnr in s_matnr.
|Is This Answer Correct ?||1 Yes||6 No|
What are Major differences in Smart forms and Scripts
In a loop of an internal table, what is the use of at first & at last statements?
What are the different types of laws. What are they?
what is difference between parameter & select-option
What are the relational operations that can be performed on view in sap? : abap data dictionary
what is the event while entering data in screen to get next field.
What is COMMIT concept in BAPI?
wat is a field symbol?
In scripts, i have 10 address lines there were blanks in between rows how can i avoid those
Why long time required to copy the file than delete the same file.
what is eqult Hide?
what are the loop events and what is the difference between them