what are the Joins used for internal Table?
Answer Posted / 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.
example.
tables: mara.
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.
select a~matnr
a~ersda
b~maktx
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 |
Post New Answer View All Answers
Explain what are the events in screen programming?
How will you define org structure in MM?
What are the two statements which are required in an abap program to output an icon using a write statement?
What is help view?
What are internal tables? : abap hr
How are the function code handles in flow logic?
What is a 'z' report?
Explain sap abap 3-tier architecture?
What is the different type of projects? : sap abap hr
How do you send files to the legacy systems from SAP and vice versa? How does one know that the legacy files have come on to the SAP server you are working on?
How is conversion of data types done between abap/4 & db layer? : abap data dictionary
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
How do you find the information on the current screen? : abap bdc
Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?
What are Pull and Push Methods?