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.

how to create interactive report from alv ?

1 Answers  

---

i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?

0 Answers   Siemens,

---

How to sort internal table?

7 Answers  

---

difference between user exit and customer exit dont tell both are same but there is another difference is there if anybody knows reply immediately

7 Answers   CSC, Wipro,

---

Hi All , Please mail me Interview Questions Related to SAP ABAP WITH CRM FUNCTIONAL EXPERIENCE please help me out ASAP as i m in Great need of Help.. my email Id is surendhar.palle@gmail.com Thanks and Regards surendhar

0 Answers  

---

Withou using SLIN transaction how would you check custom programs?

2 Answers   Bosch, IBM,

---

what is the difference between message type and basic type

3 Answers   Cap Gemini,

---

Why do we require Infotypes for HR module

1 Answers  

---

What is payroll driver ? : abap hr

0 Answers  

---

How do you send files to the legacy systems from SAP and vice versa? How does one know that the legacy files have come on to the SAP server you are working on?

0 Answers  

---

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

0 Answers  

---

How to combine multiple billing into one RV document ( Step by Step)?

0 Answers  

---