Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 30474 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
How memory management happens for internal tables and work areas in abap?
What do you mean by batch data communications programming?
What are the user groups?
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
Difference between user exit and badis?
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
What is cts and what do you know about it? : abap hr
Define batch input session?
Can we define our own match code id's for sap matchcodes ?
Write special commands of list?
What is the significance of delivery class? : abap data dictionary
What are the difference between tables and structures?
What are the aggregate objects in the dictionary? : abap data dictionary
Explain the components of selection table?
how do you transport lsmw data from one system to another?
