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.

stock transfer from one plant to another plant ? i want the total description.

0 Answers   IBM,

4. You are given functional specs for a BDC program and you need to decide whether to write a method call transaction or a session. How u will decide?

1 Answers  

what is Badi ?

1 Answers  

What is an implementation project?In any job openings they desire people with at least one project with an end to end implementation. Could u give me the details of project implementation and the role of an abapper in the implementation? And what type of questions do the recruiters normally ask for implementation projects? Plz reply me with a suitable answer. Regards, Rahul

2 Answers   TCS,

Explain what is the difference between primary key and unique key?

0 Answers  

can any body tell what is idoc archieving and how to do that

3 Answers   Accenture,

What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc

0 Answers  

Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr

0 Answers  

which of the command flushes the database buffer? a) $free b) $tab.

4 Answers   Reliance,

How can we add another field to display in standard SAPSCRIPT? Ex. we have customer address in layout, now we have to add customer Phone no in the same.

3 Answers   HCL,

Example of Pooled and Cluster tables ?

6 Answers   IBM,

what are selection screens which one triggers first?

3 Answers