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 the use of enqueue function module? : sap abap data dictionary

0 Answers  

---

how to design checkbox on the o/p of the list ,not on the selection screen.

2 Answers   TCS,

---

what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

0 Answers   TCS,

---

how do you transport a script and how do you transport a standard texts?

9 Answers   CTS,

---

What is a batch input session? : abap hr

0 Answers  

---

What is the difference between value table and check table?

2 Answers   EDS, IBM,

---

What is the significance of technical settings (specified while creating a table in the data dictionary) ?

0 Answers  

---

stock transfer from one plant to another plant ? i want the total description.

0 Answers   IBM,

---

I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it?

1 Answers  

---

How to call transaction in session method without recording?

0 Answers  

---

How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc

0 Answers  

---

how do you send the BDCDATA table in a Call Transaction statement

1 Answers  

---