what is the use of FOR ALL ENTRIES in an internal table?
- 9 Answers
- 28385 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 do you backup Sapscript layout sets? Can you download and upload? How?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
What are Delivery classes? What data will you want to transport during client copy?
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
What are the personnel administration related Infotypes
What is partner selection?
What are the different types of sapscript symbols?
What are matchcodes?
What is modularization and its benefits? : abap modularization
How can I make a differentiation between dependent and independent data? : abap hr
How many default tab strips are there?
What is the difference between sum and collect?
What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary
