Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 30053 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
What are client dependent objects in abap/sap?
How to debug a script in abap?
What do you do when the system crashes in the middle of a BDC batch session?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc
What was the requirement of IDoc in your project? How it was working?
Explain the differences between se01, se09 and se10?
How would you set the formatting options statically and dynamically within a report?
What is table buffer?
Specify the types of data dictionary objects.
What are the list of screen elements?
Describe data classes? : abap hr
What is the step-by-step process to create a table in data dictionary? : abap data dictionary
How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.
What is protect & endprotect?
