Answer / nitin gautam

If the first itab[] is initial, then it will select all the rows of the table because we are comparing two tables with where condition.

There are two important tips:
1. Declare all primary keys of your database table in your select statement. It ensures that you have no duplicates in you hit list
2. Check that the table used in the "For all entries" statement is not empty. This avoids executing the select statement if no result is expected.


Please refer the following example code:

IF LT_OBJNR[] IS NOT INITIAL.

SELECT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
KSTAR
HRKFT
VRGNG
VBUND
PARGB
BEKNZ
TWAER
into table LT_WKG
FROM COSP
FOR ALL ENTRIES IN LT_OBJNR
WHERE OBJNR = LT_OBJNR-OBJNR.

ENDIF.

Answer / sreenivasa rao yarru

If there is no records in secondtable then it will give all
recods in first dable

select from firsttable ....
for all entries in secondtable

So we need to check this condition first
For all entries wont give duplicate entries

Step by step process of BAPI implementation

1 Answers  

---

in a loop of an internal table, what is the use of at first & at last statements?

2 Answers  

---

How to insert a line into abap internal tables?

0 Answers  

---

What is a report?

0 Answers  

---

what is RFC?types of RFCs?please any one can give me the interfaces in sap abap with example?

2 Answers   Cap Gemini,

---

what happend if a select statement inside aloop....

3 Answers   Accenture,

---

How will you do in session method?

3 Answers   FutureSoft, Unilogic Software,

---

What are the function modules used to create batch input session? : abap bdc

0 Answers  

---

WHAT IS MEAN BY XK01, VA01 AND VD01 IN BDC PROGRAMES

3 Answers   IBM,

---

Differentiate between the uline and write: sy-uline statements if any?

0 Answers  

---

what does it mean occurs 0 while creating an internal table?

2 Answers  

---

What are the different types of parameters?

0 Answers  

---