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.

Explain the types of bdc's?

0 Answers  

---

what is the use of CTU_PARAMS when we working with BDC?

4 Answers   Cap Gemini, Yash Technologies,

---

Can we write inner join between transparent table and cluster table? If both having common fields?

8 Answers   Cap Gemini,

---

check sy-subrc = 0 and if sy-subrc =0 difference explian

1 Answers   IBM, VSoft,

---

Suppose I am working on userexit if someone wants to work on same is it possible to work?

2 Answers   NTT Data,

---

how to handle double click event in table contorl....

1 Answers  

---

Significance of Hide?

5 Answers  

---

give example of sap memory and abap memory

1 Answers   EDS, IBM,

---

What are some control break events in abap?

1 Answers  

---

Give me the Full flow of SD and MM

5 Answers   Wipro,

---

Explain Sales Flow?

2 Answers  

---

is there any tping conversions in abp.and list them

2 Answers   IBM,

---