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.

foreign key enforcement?

2081

---

What is a projection view? : abap data dictionary

1078

---

What is the use of lock objects?

1064

---

What is human resource information systems (chris)? : sap abap hr

1066

---

Can you show multiple alvs on a single screen?

1114

---

Select up to 1 row and select single difference ?

1132

---

What are plan versions used for? : sap abap hr

1059

---

How we format the data before writing a statement in the report?

915

---

What are ranges?

1052

---

what precautions or prerequisites do you follow to update a record into database table and how

6068

---

hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.

2161

---

Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3693

---

How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization

1095

---

Events that can be used in both the classical and interactive reports

1620

---

What are the prerequisites for creating foreign key relationship?

1162

---