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

What is is a match code? : abap data dictionary

0 Answers  

---

There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.

4 Answers   Altimetrik,

---

What is the syntax of packed number?

0 Answers  

---

What are the differences between macro and subroutine?

0 Answers  

---

what is the sap standard script for picking list?

2 Answers   Intelligroup,

---

What is tcode se16? For what is it used.

0 Answers  

---

11. what is the difference between user-exit & customer-exit?

2 Answers  

---

Can i know some of the Realtime tickets that anyone has been faced ?

0 Answers   SAP Labs,

---

without using matchcode ,help view ,check table , domain how to create the search help anybody know this answar plz post imdtly

3 Answers   Wipro,

---

By which function module upload data from application Server to desk top and to code can u explain

4 Answers   Cisco, Satyam,

---

What is field catalog. Describe the purpose of it?

5 Answers  

---

what are different types of message types available for ale/idocs

1 Answers   IBM,

---