Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 30745 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
Explain about Recording Function?
How can we use / display table in a screen?
What are the advantages of abap query tool?
What is the significance of delivery class?
What is the difference between call transaction method and the session method? : abap bdc
How to insert a line into abap internal tables?
How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?
What are the organizational related infotypes? : abap hr
how to see the tables of 200 in client 100?
What is an update task?
What is the structure of bdcmsgcoll? : abap bdc
What are the steps to be followed to set lockobjects? : sap abap data dictionary
Explain how is batch input process different from processing on line?
What are field symbols?
Where do you code the hide statement?
