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.

What is the table buffer? Which type of tables used this buffer?

555

---

What is the sap abap?

625

---

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

650

---

What are the types of subroutines? : abap modularization

589

---

Table events aNd table maintains generation

982

---

---

What is synchronous update?

564

---

What is view? Explain the different types of view?

782

---

what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2054

---

What is the table & field to identify the no of items (bottles) stored in one case?

1975

---

Does the call transaction method allow multiple transactions to be processed by sap?

557

---

Difference between user exit and badis?

607

---

What is web dynpro for abap?

565

---

What happens if a function module runs in an update task?

552

---

What are internal tables? : abap hr

561

---

Mention the various databases integrities?

612

---