Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 30402 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
Which infotype records can not be deleted ? : abap hr
Explain the differences between interactive and drill down reports?
What is a projection view? : abap data dictionary
What are the data types of the abap/4 layer?
How will you read from internal table records in a given value range (without using loop)
What are the properties of selection screen?
How to find the return code of an stmt in abap programs?
What is the transaction code to display the payroll results ? : abap hr
What is view proxy in abap?
How does the system handle roll areas for external program components?
What are the advantages of different types of bdc's?
Name the function module used to convert logical file names to physical file names in abap/4 programs?
What are the sequences of event block?
Explain what is sap script? What is the purpose of sap script?
Explain about the tables exists in a data dictionary and what are they? : abap data dictionary
