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 are the types of table fields in the sap abap?

1206

---

What is an evaluation path? : sap abap hr

1135

---

What is protect & endprotect?

1074

---

What is meant by hide area?

1191

---

What is the difference between pnp and pnpce? : abap hr

1706

---

Explain the difference between a pool table and a transparent table?

1061

---

How can we handle table control in bdc? : abap bdc

1170

---

In SAP Script,How to display a single field(like matnr)at the right end of the form.

2493

---

Which function module would you use to check the user’s authorization to access files before opening a file?

1105

---

What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc

1253

---

What are Pull and Push Methods?

2304

---

What is modularization and its benefits? : abap modularization

1235

---

SAP query how to use end users?

2252

---

When is the top-of-page event triggered? : abap data dictionary

1296

---

Explain the systems fields used for interactive lists and lists?

1057

---