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 BDCRECXX contains?

3 Answers  

---

In select-options, how to get the default values as current month first date and last date by default?

0 Answers  

---

how can you make select options as a parameter?

5 Answers   De Novo, IBM,

---

What are the types of search helps? : sap abap data dictionary

0 Answers  

---

why u can call(r using) ssf_function_module_name in smartforms?

7 Answers   IBM, Satyam,

---

---

What is the length of function code at user-command?

0 Answers  

---

where can u use secondary index in program please tell me? is there any tool to test in development client?is there any performance tool is thre pleaseeee tell me?

3 Answers   Cap Gemini,

---

Can you create a Lock Object? What are Lock Objects?

2 Answers   Deloitte,

---

What is the difference between Overloading and Overriding ? Which of them is possible in ABAP ?

5 Answers   HCL, ITC Infotech, TCS,

---

how can you call a function module in smart form..??

1 Answers   IBM, Kekran Mekran,

---

what is the difference between DATA ELEMENT and DOMAIN? please give the fully detailed

4 Answers   Bosch,

---

How do you control printer functions from sapscript?

0 Answers  

---