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 is step-loop? Explain all the steps?
Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr
If u r working with call transaction method .any problem occurs error records r stored in BDCMSGCOLL structure.How do u find that an error has occured at a particular point,how can u handle to rectify and process it successfully? If a file has 10000 records where 3 records doent having right format,how do u tackle with this issue either by using call transaction or session method to transfer data perfectly into database table?tell me the steps how to procede?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?
how does SAP organise its exits?
what is the difference between with initialization and with out initialization?
What are the time related infotypes? : abap hr
How to create the ur own barcodes?
how to fetch data form without header line internal table ?
Badi concepts
What is the significance of technical settings (specified while creating a table in the data dictionary) ?
Explain client-dependent and client-independent tables.