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.

What is the MM Flow with Transaction Codes

2 Answers  

---

Explain how to write a bdc - how do you go about it?

0 Answers  

---

tell me about status codes?

2 Answers   Accenture, Satyam,

---

Why do we use CALL FUNCTION ..IN BACKGROUND TASK and CALL FUNCTION ...STARTING NEW TASK? What is the difference?

2 Answers   HCL,

---

Hi to all abap guru's my question is how to print the page numbers like 2 4 6 on all pagess in smart forms means 2 on first page 4 on second page thanks in advance

1 Answers   Enteg Technologies,

---

What Is Roll Area In ABAP?

3 Answers  

---

How to run a report in background??and if we try to run in foreground it says"this report sud be run in background".what can be done in this case?? 2-And how sud we stop a report running in background??

3 Answers   Cap Gemini,

---

How table control cn be generated using bdc? : abap bdc

0 Answers  

---

What are the Text – elements inscripts. Where you declare this. What is the use to this.

2 Answers   Deloitte,

---

can we create secondary index for views?

1 Answers  

---

What are the steps carried the ALE?

1 Answers   Keane India Ltd,

---

Have you printed any report?

0 Answers   TCS,

---