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.

tell me some of FI/CO tables

4 Answers   FutureSoft,

---

please any one can tell me modifytable keyword used in DDIC? what is a basic diffrence between modify table and update key word?

4 Answers   KPIT,

---

What is PNP-SW-FOUND

1 Answers  

---

What is the significance of main window in a page, what are the types of the window?

3 Answers   Accenture,

---

what is the difference between rfc and function module

2 Answers  

---

what precautions or prerequisites do you follow to update a record into database table and how

1 Answers   Genpact,

---

Where we use Chain and End chain?

2 Answers   Intellect Bizware, Sony,

---

how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

0 Answers   TCS,

---

What is the difference between skip and new-line?

0 Answers  

---

PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..

0 Answers  

---

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

2 Answers   NTT Data,

---

Explain what is runtime analysis?

0 Answers  

---