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.

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.

Answer / mnaikandan

To avoid nested select statements.
if there are more than 1000 records to retrieve.

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.

Answer / ravi

Answer 3 Disadvantage be more clear pls.

Anyhow, Answer 5 is excellent.

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

Answer / satish

dont tell join like that in a few words main thing is relationship based on key feelds

Answer / 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.

Answer / sriram

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.

Performance techniques?

2 Answers   Bristle Cone,

Plz can any one tell me about the detailed information of issues raised by the enduser, as an abap developer how we need to pick up that issues and what are the steps involved in the process(support project ), and tell me about the tickets. who is the person that is going to generate the tickets( send the detailed information regarding the support project and as a abap developer, what is its roles and responsibilites from beginning to the end of support project .

1 Answers  

what is the difference between at line selection and at line selection on field.

1 Answers  

Explain about workbench request and customization requests?

0 Answers  

What are the developments you have done with data dictionary?

3 Answers   IBM,

How do you validate the selection criteria of a report? And how do you display initial

0 Answers  

What is append structure?

0 Answers  

what is the event while entering data in screen to get next field.

2 Answers  

What are the basic components of dialog program?

0 Answers  

What are the control break events in abap? : abap data dictionary

0 Answers  

hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks

0 Answers   HP,

WHAT IS PEFORMANCE TUNING?

4 Answers   SAP Labs,