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.
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 |
what are the types of lists in pf-status in mod pool?
What is evaluation path, where do we do it and why? : sap abap hr
how many indexes can be created for a table?
what is the table name of stock of material
how to validate either processing view is already exist or not?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What is pass by value and what is pass by reference? Which is better?
I need some information regarding Vcentric Test pattern ? with questions.
0 Answers vCentric Technologies,
can u create more than one selection screen?
8 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
Can a constructor be declared private? If yes then in which scenario?
What are the payroll related infotypes? : abap hr
how do you display initial values in a selection screen?
what r the services have to implemented in SAP R/3?