what is the use of FOR ALL ENTRIES in an internal table?
Answers were Sorted based on User's Feedback
Answer / uday shankar
for all entries used for joining of tables.
it will join the tables at application server level.
it will improve performance.
here we dont have restriction to the no of tables joined.
Is This Answer Correct ? | 23 Yes | 1 No |
Answer / venkateswarlubandi
Conditions for FORALLENTRIES:
1. IF ITAB [] is not initial.
2. At least one primary key field in the where class.
3. It avoid the Nested Select Statement
4. Retrieve the data from more than one table.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / mnaikandan
To avoid nested select statements.
if there are more than 1000 records to retrieve.
Is This Answer Correct ? | 16 Yes | 4 No |
Answer / ahmad
ADVANTAGE.
IF THERE ARE MORE THAN ONE TABLE AND THERE EXIST A
RELATIONSHIP BETWEEN THEM BUT THE FIELD IN WHICH THE
RELATION IS MADE IS NOT A PRIMARY KEY IN ONE OF THE TABLE
THEN WE USED FOR ALL ENTRIES .
IT REDUCES REDUANCY OF DATA
RECORDS SHOWS CONSISTENCY .
IT BETTER TO USED FOR ALL ENTRIES INSTED OF NESTED SELECT.
DISADVATAGES.
IF ONE OF THE TABLE IS EMPTY AND WE ARE APPENDING ONE TABLE
WITH OTHER BY USING FOR ALL ENTRIES THEN THE RECORDS TO NOT
VERIFY ITSELF.
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / ravi
Answer 3 Disadvantage be more clear pls.
Anyhow, Answer 5 is excellent.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / manohar.b
FOR ALL ENTRIES is used to join the tables.
The Main Advantage is whenever we r using this FOR ALL
ENTRIES we r going to join the tables in the appliction
level.In all other joining conditions like INNER
JOINS,VIEWS,NESTED SELECTS we r going to join them in
database level itself.which may cause some bad performance
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / satish
dont tell join like that in a few words main thing is relationship based on key feelds
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Actually It is used instead of inner join because when we want to join morn than 3 tables using inner join it will put a heavy load on the database server. instead of taking heavy load on DB server we will use for all entries ...
USED to retrieve the matched Records from the Different DB Tables..
Syntax :
select * from DBTABLE1 into table ITAB1
if itab1 is not initial
select * from DBTABLE2 into table itab2
where condition.
Is This Answer Correct ? | 1 Yes | 5 No |
How to Delete an LSMW Projcet, Subproject and Object.
Tcode for enhancements?
I have two selection screens, i gave values in first selection screen but i din't give any values in second screen. will it display or not plz tell me?
Can a function group share its subroutine with all its function modules?
how to find Bapi? and Badi?
What are the 3 types of function modules in sap?
What is the diffrence between index and primary key?
what is the function module to read the standard text?
When was the sap abap being created?
what is the difference between transparent, pooled and cluster table
give examples of pool,cluster tables
Why u r looking for change from current compeny? which is the best answer?