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 open sql vs native sql ?

1 Answers  

---

Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?

0 Answers  

---

How will you define org structure in MM?

0 Answers   Infosys,

---

How to add segments to IDOC?

3 Answers  

---

why abap/4 is 4th generation language ?

4 Answers   Kansai Nerolac Paints Limited,

---

How many ways you can create table? : abap data dictionary

0 Answers  

---

What is RFC function module?

2 Answers   CSC,

---

How to search a Internal Table Fields?

2 Answers   HCL,

---

i want to block some spaces after end of page in classical report?how to do that?

1 Answers  

---

who is vendor?

2 Answers   Keane India Ltd,

---

How do u write a program in session method so that it creates the session and run the session itself without going to sm35

3 Answers   Accenture, HCL,

---

Example of Pooled and Cluster tables ?

6 Answers   IBM,

---