Answer Posted / kotireddy5

1. This statement is used to replace select with joins.
2. Because JOINS statement cannot be used for more than three tables.
3. If we use more than three tables it puts heavy load on the Database, because the data has to be selected by comparing each table in the database server.
4. So it takes the long time for execution.
5. In such cases we go for SELECT FOR ALL ENTRIES.
6. This statement will never put load on the database. Because only two tables (Internal table and database tables) are compared
SYNTAX:
Select F1 F2 F3…..
From <DB. Table1>
Into table <ITAB1> Where <conditions>.
If ITAB1[] is not initial.
Select F1 F2 F3…..
From <DB.Table2>
Into table <ITAB2>
For all entries in <ITAB1>
Where F1 = <ITAB1-F1> AND F2 = <ITAB1-F2>.
Endif.

How do you do bdc for a table control? : abap bdc

644

---

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

1565

---

Explain Catch Command in ABAP?

821

---

A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary

666

---

What are the personnel administration related infotypes? : abap hr

602

---

---

Different types of locks?

621

---

Explain buffering

881

---

What are secondary indexes. How can we know which index is being used in a select query?

992

---

suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?

1852

---

What is function group?

604

---

What is a table pool? : abap data dictionary

594

---

What are the differences between se01, se09 and se10?

524

---

What are the two levels in defining a match code? : abap data dictionary

593

---

Polymorphism real time scenario

1029

---

Is main window mandatory in smartforms?

710

---