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 |
how to track records from data dictionary?
You have written a program for displaying a report on the screen. It is working fine and is displaying the report on the screen. now I change the resolution of my system and again I run the same program. what will be the output?
difference between report and module pool
what is the difference between hashed & sorted internal tables?
What are the different functions used in sap script?
A Program calls a Function module. what happens to the ABAP memory allocation used by the functional module when the functional module is completed?
what is a binary search ? and how it is useful in a sorted internal table ?
How does one know that the legacy files have come on to the SAP server you are working on?
what is the difference between bdc and lsmw ?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
what is a TEXT Table ?
1 Answers vCentric Technologies,
What is an User exit?