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


Please Help Members By Posting Answers For Below Questions

Explain what are the events in screen programming?

576


How will you define org structure in MM?

842


What are the two statements which are required in an abap program to output an icon using a write statement?

771


What is help view?

562


What are internal tables? : abap hr

569






How are the function code handles in flow logic?

612


What is a 'z' report?

649


Explain sap abap 3-tier architecture?

737


What is the different type of projects? : sap abap hr

532


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?

729


How is conversion of data types done between abap/4 & db layer? : abap data dictionary

652


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.

1899


How do you find the information on the current screen? : abap bdc

611


Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?

1672


What are Pull and Push Methods?

1778