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 an Open Item in SAP? How will you find an Open Item in SAP?

0 Answers  

---

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

0 Answers  

---

Explain Commit and Roll back?

1 Answers  

---

What is read line in abap?

0 Answers  

---

What is the different between template and a table?

0 Answers  

---

Have you used SAP supplied programs to load master data?

1 Answers  

---

where is security relevent information such as Password for ITS are stored?

1 Answers   Accenture,

---

Does the table can have multiple foreign keys?

0 Answers  

---

what are the events in ABAP?

18 Answers   Keane India Ltd, Microsoft,

---

WHAT IS THE DIFF B/W MACRO & SUBROUTINE?

3 Answers   Sony,

---

What are Pull and Push Methods?

0 Answers   Accenture,

---

What is the use of a pretty printer?

0 Answers  

---