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.

What is the difference between Collect statement and Append Statement?

2 Answers   Accenture, Deloitte, Maventic, TCS,

What is narrow casting and wide casting?

0 Answers   Infosys,

Update types in Call transaction method. What is the difference?

0 Answers  

Hi i am surya, i have faced this questions plz give me the answer. I have requirement like this, i have two internal tbale like itab and itab1 in itab i have 50 records, in itab1 100 records are there. When execute this question what will be the output a]50 b]100 c]150? And how to join two internal tables what is the syntax for that?

12 Answers   Satyam, TCS, Wipro,

how to see the last updated record in a table?

4 Answers  

what is itcsy structure? what is the importance of it? give me the detailed information of it ?

2 Answers  

How do you number pages in Sapscript layout outputs?

1 Answers  

the sap standard SAPSCRIPT for picking a list ?

2 Answers  

what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

0 Answers  

How LSMW is advantageous than normal BDC?

4 Answers  

I have 2 fields like customer and name having 20 records on basic list. When I select 5 records randomly, I want to get the address of particular customer selected in secondary list?

2 Answers   Deloitte,

How to convert Normal function module to RFC enabled Function Module?

1 Answers   IBM,