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 are the basic functions of database utility? : abap data dictionary

0 Answers  

---

What are control tables?

0 Answers  

---

While doing bdc exp va01 transaction sometime in the item level data shows only 4 items and other times it will show 6 line items, how will you maintain this kind of screen resolutions scenerio? : abap bdc

0 Answers  

---

Difference between table control and step loop? Plz answer me its urgent!

4 Answers   WDC,

---

What are the different types of the sap abap data dictionary objects?

0 Answers  

---

What is BSP Application & Extension?

1 Answers  

---

what is the main main difference between data element and domain? (i know definitions,i don't want definations).

8 Answers   Intelligroup,

---

Explain sap abap 3-tier architecture?

0 Answers  

---

what is the Difference between Scripts and Smart Forms?

3 Answers  

---

What are lock objects?

0 Answers  

---

How many types of size categories and data classes are there?

0 Answers  

---

How do you validate the selection criteria of a report? And how do you display initial

0 Answers  

---