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
What are the 2 other types of views, which are not allowed in release 3.0?
What is the structure of the bdc table? : abap bdc
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
What functions does a data dictionary perform ?
What is occurs in internal table?
Difference between function group and function module?
How you attach search help to data element? : sap abap data dictionary
What abap statement will trigger list generation?
What are the advantages and disadvantages of different types of bdc's?
What are the differences between table controls and step loops?
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
what is mean be On Change of in Control Break statement
Can you define a field without a data element?
When will the current screen processing terminates?
Explain the use of table maintenance allowed?