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 layers of data description in r/3? : abap data dictionary

0 Answers  

---

What is its?

0 Answers  

---

what is result set of an inner join at database level ?

1 Answers  

---

what is actaul procedure of session method of bdc. pls me complete steps.

4 Answers   Accenture, IBM,

---

most commonly used command in Interactive Reporting?

4 Answers   TCS,

---

What is kernal badi? What is the difference between classic badi and kernal badi ? What is the advantages of kernal badi?

2 Answers   Accenture, HBL Power Systems, IBM, Yash Technologies,

---

what is call back in alv?

0 Answers  

---

what are nodes in smart forms?

2 Answers  

---

What is the difference between open_form and close_form?

0 Answers  

---

Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.

0 Answers   TCS,

---

DO SERVERS IN EVERY COMPANY HAVE A SPECIFIIC NAME CAN I KNOW THE SERVER NAME OF IGATE AND ITS GEOGRAPHICAL LOCATION AND HOW MANY SERVERS DO A COMPANY WILL HAVE FOR SAP

3 Answers   Verizon,

---

What is the difference between a structure and a table?

0 Answers  

---