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.

When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization

0 Answers  

When you prefer lsmw?

0 Answers  

What are the relational operations that can be performed on view in sap? : abap data dictionary

0 Answers  

What specific statements do you using when writing a drill down report?

1 Answers  

what is index? I need exact defination? how will create a secondary index?

5 Answers   Caritor,

What is a type group?

0 Answers  

what is the standard program used to upload/download layout sets in scripts.

4 Answers  

How do you retrieve the data for repetitive structures ? : abap hr

0 Answers  

What is at exit-command:?

0 Answers  

Explain the concept of clusters in payroll

1 Answers  

Is it possible to run host command from SAP environment? How do you run?

0 Answers  

how to transfer smartforms?

1 Answers   Satyam,