Answer Posted / 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 web dynpro for abap?

575

---

What are the differences between transparent tables, pooled tables & cluster tables? : abap data dictionary

719

---

How do you retrieve the data for repetitive structures ? : abap hr

653

---

When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization

613

---

What are the events in screen programming?

619

---

---

What is the company code? : sap abap hr

578

---

How do you set up background jobs in sap?

568

---

What is PS structure

1630

---

Did you use buffering?

599

---

Can we set page headers to details lists?

590

---

Explain about sap fico testing and the tools used? : abap bdc

612

---

What is a table cluster? : abap data dictionary

736

---

Define spool request?

666

---

How to select valid lines for secondary list?

605

---

Update types in Call transaction method. What is the difference?

607

---