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 is alv programming in abap? When is this grid used in abap? : abap hr
Can we use transfer dataset to transfer data in internal table ?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
Define external layer? : abap data dictionary
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
How to write a code for multiple transactions? : abap bdc
how can you display data say "your name"in sap script without print program or driver program??
when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.
What is a predefined type in abap?
What is the max no of match code id’s that can be defined for one match code object?
What are data classes? What are the various data classes available for selection? : abap data dictionary
HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
What is PS structure