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.

Work most on which module: name a few tables?

993

---

Explain what is a logical database?

1004

---

What is the difference between field-group header and other field groups? : abap modularization

941

---

What is sap abap data classes?

1012

---

Explain the components of selection table?

1052

---

What is the lock object?

1009

---

What are the two statements which are required in an abap program to output an icon using a write statement?

1240

---

What is a maintenance view? : abap data dictionary

917

---

What is pnp-sw-found ? : abap hr

1389

---

Abstract class and interface, multiple inheritance, live example

1285

---

What is the significance of the screen number ‘0’?

996

---

What are aggregated objects : abap data dictionary

1007

---

What are the domains and data elements?

1508

---

What is interactive reporting?

1017

---

What is the difference between sy-tabix and sy-index? Where it is used?

1251

---