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 an implementation project?In any job openings they desire people with at least one project with an end to end implementation. Could u give me the details of project implementation and the role of an abapper in the implementation? And what type of questions do the recruiters normally ask for implementation projects? Plz reply me with a suitable answer. Regards, Rahul

2 Answers   TCS,

---

what is badi?

12 Answers   TCS,

---

What is Transaction to view the Workflow status ? a) SWDD b) SWI2_FREQ c) SBWP d) SPRO

4 Answers   SAP Labs,

---

What is an User exit?

1 Answers   ABC,

---

What are user exits? What is involved in writing them? What precations are needed?

0 Answers  

---

y we need SSF_FUNCTION_MODULE IN SMARTFORMS?

2 Answers  

---

Explain different types of locks?

0 Answers  

---

During performance analysis you found one select statement taking long time. How to correct it?

3 Answers   IBM,

---

what are the types of session method in session method?

1 Answers  

---

we can write the select query or any code after the end of selection

2 Answers   TCS,

---

how do you transport FORM from one server to another server ?

2 Answers  

---

How we format the data before writing a statement in the report?

0 Answers  

---