Answer / shakthi

for retriving data from more than one internal table we go for joins.
there are two types of joins
inner join,left out joins.

Answer / 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 do you display initial values in a selection screen?

1 Answers  

---

1.In Change pointers , Using BD61 I activate globally and I enable the MATMAS message type When I Ran the "RBDMIDOC" SYSTEM GIVES information messagge 253 MASTER IDOCS CREATED. MY Question IS :1.what is 253 2.PlZ explain internal PROCESS ,HOW ITS GENERATE 253 MASTER IDOcs?

1 Answers   Accenture,

---

How to work on TCODE SE16?

3 Answers  

---

Can you call a bdc from a report program ?

2 Answers  

---

1.Which of the following is not an EXIT command? options: BACK, CANCEL, STOP, EXIT? 2.To write certain contents in sap script without skipping to the next page, which command is used? Options: ADDRESS...ENDADDRESS, PROTECT...ENDPROTECT, AT...ENDAT 3. When using a table control in module pool, which statement has to present in both PAI and PBO. options : FIELD, LOOP..ENDLOOP, CHAIN...ENDCHAIN 4. Lock objects are : options : FUNCTION MODULES, PROGRAMS, TABLES

4 Answers   Accenture,

---

What are the different database integrities?

0 Answers  

---

What is the exactly definition of Foreign key 2.what is the exactly definition of Value Table. 3)What is the exactly definition of Data element and Domain.Please give the exactly definitions of all above questions without fail....Thanku

2 Answers   Bosch,

---

How is conversion of data types done between abap/4 & db layer? : abap data dictionary

0 Answers  

---

Events in Interactive reporting?

3 Answers   TCS,

---

Application Category?

0 Answers   Infosys,

---

In SAP Query with out know user that query can we execute?

1 Answers   Patni,

---

what is 'F4' functionality?

6 Answers  

---