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 |
Does sap handle multiple currencies?
List some of the many different ways that the sap standard functionality can be changed by a customer?
will join conditions in sql queries affect perfomance? how?
What are the aggregate objects in the dictionary? : abap data dictionary
hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?
How to put page-breaks in smartforms?
After transferring of data from flat file to application server i found that it is showing wrong data .Say i had currency in flat file as 1000.00 USD. After transferring i found it is showing as 100.000 in the application server. How will you handle this case?
What is the bapi?
Can we create Secondary Indexes for the Views
What is off cycle payroll run
What are conversion & interface programs in sap?
Name the abap/4 modularization techniques? : abap modularization