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.

Explain what is the step-by-step process to create a table in data dictionary?

0 Answers  

Can we create a Table Without a Primary key?

12 Answers   Satyam,

Can i have some Realtime Scenarios on Reports.

0 Answers  

can u add a new view to the existing view?

2 Answers   Bristle Cone, Cap Gemini, HP, Satyam, Wipro,

What is the function module for IDOC generation ?

2 Answers  

Explain the advantages/disadvantages of logical databases?

0 Answers  

what is difference between method and function module?

2 Answers  

why SAP script is clint dependent and smartform is clint indepedent ?

3 Answers  

what is the functionality of data class?

4 Answers   Accenture,

what is use of sap script text file header?

1 Answers  

what is DATA ,TYPES,PaRAMETERS called in ABAP terms?

3 Answers  

Waht is "READ TABLE" command?? Whats the use of it?? Whats the syntax of the same?

4 Answers   TCS,