Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 30439 Views
- Keane India Ltd, PCS, Wipro, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
On which even we can validate the input fields in module progams?
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
2)In production what is the user exit?
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
What are the screen painter and menu painter?
How to convert normal function module to bapi?
What are advantages and disadvantages of logical data base
Difference between open sql and native sql? : abap data dictionary
How do you process errors in session method ? : abap bdc
What is bdc programming? : abap bdc
How did you transfer legacy data in the mid of the financial year (us) to the sap system? : sap abap hr
Difference between /N and /BEND?
What is the use of a pretty printer?
What is an abap/4 query? : abap hr
What are the functional modules used in sequence in bdc? : abap hr
