Suppose u r using FOR ALL ENTRIES. What happens when there
is no data in the itab which is using all the entries?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 18 Yes | 0 No |
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.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / chvpavankumar
all data will upload to main internal table with out any
checking
Is This Answer Correct ? | 10 Yes | 0 No |
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.
Is This Answer Correct ? | 10 Yes | 3 No |
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.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / chowdary
it will retrive all entries of the table on which you are
performing the for all entries into internal table.
Is This Answer Correct ? | 3 Yes | 3 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / karthikeyan
we have to check the particular internal table is not initial.
Is This Answer Correct ? | 2 Yes | 6 No |
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.
Is This Answer Correct ? | 2 Yes | 8 No |
by which function module we are going to put data into sapscript ?
In Realtime, how you get flat file for BDC session method.. through email or any other source? Who will send you flat file..your team lead or project lead or project manager etc?
On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
How to debug a smartform using SMARTFORM_TRACE....and how to see its results
Hi, Can any one help me. i have a dropdown list box with values like LG01 SAMPLEDRAW LG02 LASER......... Like this i have multiple values .and my table name is T496N. Whenever i select ex:lgo1 sampledraw the program title should be change with SAMPLEDRAW(With out execute f8 button). Thanks and Regards
what are the stpes in ALE?
why scripts are client dependent and smart forms are client independent.?
which Editor does ABAP provide?
What is append structure?
What is Basic IDOC type?
When, how and how would you control changes to standard SAP objects.
What is human resource information systems (chris)? : sap abap hr