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.

How we format the data before before write statement in report ?

737

---

What are the events driven batch jobs?

775

---

How do you write manual bdc session method? : abap bdc

786

---

What is table attribute? : abap data dictionary

773

---

How to pass data from list to report?

739

---

---

What is an update type with reference to a match code id?

743

---

Which one is better joins or views and why?

810

---

Select up to 1 row and select single difference ?

819

---

What are the steps to be followed to set lockobjects? : sap abap data dictionary

836

---

What is meant by hide area?

849

---

Explain how to Handle the internal tables in ABAP?

804

---

What are the different types of data dictionary objects? : abap data dictionary

866

---

How to creat transactions? : abap data dictionary

834

---

What is the difference between ABAP and HR ABAP

3248

---

What is the max no of match code id’s that can be defined for one match code object?

899

---