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 meant by search help? : sap abap data dictionary

1192

---

Do you know any other patterns if yes.. explain

1302

---

What is the table buffer? Which type of tables used this buffer?

1032

---

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

1224

---

What are the control break events in abap? : abap data dictionary

1115

---

What are the events driven batch jobs?

1069

---

What is time constraint ? : abap hr

1289

---

How to debug a script in abap?

1134

---

Did you create help views?

990

---

What are the advantages of logical databases : abap hr

1059

---

What are pooled tables?

1055

---

What is off cycle payroll run

2469

---

What are the system table used in abap?

1134

---

How many primary keys can be created for a table?

1064

---

How many tables are there in sap?

1110

---