Answer / pramod upadhyay

If the table on which the For All Entries IN clause is
based is empty, all rows are selected into the destination
table. Hence it is advisable to check before-hand that the
first table is not empty.

Answer / tharun

when you are using for all enteries always check whether
IF ITAB NOT INITIAL.THis internal table is the one
used 'for all enteries in itab'.this will prevent from the
query fetching all data.

IF ITAB NOT INITIAL.
select ... for all enteries in itab.
endif.

Answer / chvpavankumar

all data will upload to main internal table with out any
checking

Answer / phani

Hi All,
If we use FOR ALL ENTRIES, first internal table should
have at least one record ( ie, it should not initial ).The
data will fetch from database based on second select
statement,irrespective of first internal table records ,
because first internal table is empty.

It is best practice to use IF NOT I_TAB1[] IS INITIAL.
Because we use FOR ALL ENTRIES statement to avoid the
duplicates entries.

Answer / lokesh

Please Ignore my earlier Answer ....I regret for that
answer...Please check this one..

If no data is there in ITAB which you are applying for FOR
ALL ENTRIES then select query will fetch all the values
from the DB table which can be real performance issue.

so before making for allentires for a table make a check
that its not empty.

Answer / chowdary

it will retrive all entries of the table on which you are
performing the for all entries into internal table.

Answer / santhu23

when you are using for all enteries always check whether
IF ITAB NOT INITIAL.
Otherwise it will pick all the values form by second selected table based on "NULL VALUES".
So, We have to check ITAB Is Not Initial.

Answer / sivasankar

No data is displayed

Answer / karthikeyan

we have to check the particular internal table is not initial.

Answer / lokesh

If they is no data in itab , the for all entries itab1 will
not display any data..
because 1st itab should be not initial .
check for initial before going for for all entries.

Which method is faster among 4 methods used in LSMW.?

1 Answers   CTS,

Explain the session method? : abap bdc

0 Answers  

WHAT IS THE PURPOSE OF SPLIT COMMAND?

1 Answers  

What are the different control break statements available inside a loop?

0 Answers  

What is the Difference between Transparant Tables , Pooled & cluster Tables?

1 Answers   Patni, Satyam, Siemens,

How to transfer legacy data into base tables by scheduling a time frame using bdc?

2 Answers  

can any one tell me the following question's answer 1. How can we create PUSH Botton in presentation layer. 2.How can we print the record. 3.If database has nor records & if we write 'for all entries' in select statement then what will be happen.

1 Answers   Accenture,

where do we define LDB to a program ?

1 Answers  

what is data structure and data table

3 Answers   Cognizant, IBM,

what are customizing?have u created any customizing table? for what purpose?

2 Answers   Accenture,

How can we access the correction and transport system?

0 Answers  

Define database layer? : abap data dictionary

0 Answers