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.

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.

What is the difference between select statement and provide statement

1 Answers  

---

what is current version of sap r/3 ?

5 Answers   HCL,

---

Recording -- Transaction code?

10 Answers   Cap Gemini, TCS,

---

What are the control break events in abap? : abap data dictionary

0 Answers  

---

what is cardinality.how it will work in abap

2 Answers   TCS,

---

---

What is a 'z' report?

0 Answers  

---

what is 'F4' functionality?

6 Answers  

---

Hat are the different types of mode (run code) in call transaction method?

0 Answers  

---

How to display or know if the value entered contains records or not?

0 Answers  

---

in which table idocs are stored?

8 Answers   IBM,

---

What is the relationship existing between the various data elements? : abap data dictionary

0 Answers  

---

I have 2 inputs in Module pool prgm, if i click on the input i need to get drop down list..How to get it..

2 Answers   IBM,

---