what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 27230 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 what are the different functions used in sap script?
What is the table buffer?
What will you code in start-of-selection & end-of-selection ?
How do I find the output type of a table or a program?
how to read the standard field value in your custom program.
What is filter dependent BADI?
When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization
How to know if the value entered contains records or not?
Explain what is the step-by-step process to create a table in data dictionary?
What does the insert statement in extract datasets do? : abap modularization
What are domains and data element? : abap hr
Can i Have Some Realtime Examples on Badi ?
How to handle error in session method? : abap bdc
How to create any functions?
What are the types of search helps? : sap abap data dictionary
