when you are using 2 internal table in program, you have
decided to use for all entries statement to retrieve data
but unfortunately there are no records in the first internal
table. What will be the result? (2nd internal table contains
records).
Answers were Sorted based on User's Feedback
Answer / lokesh
The driver Internal table 0r First internal Table Must have
records in it , if u use For All Entries . If the First
Internal table is initial (means no records in it) then the
For All entries will fetch all the records from the DB
table , which can be real perfromance Issue.
so before making a 'For all entries" for a table make a
check that its not empty.
eg. code :
select matnr werks from marc
into table t_marc
where matnr = p_matnr.
if t_marc is not initial.
select matnr mbrsh meins matkl from mara
into table t_mara
for all entries in t_marc
where matnr = t_marc-matnr.
else.
write : / 'No data was fetch by t_marc'.
endif.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kumar
If you use for all entries statement and if the internal
table which u r using for all entries it will retrieve all
the records from the table which you are using in select
query
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / siddharth samal
IF THE 1ST TABLE IS INITIAL THEN THE PROGRAM WILL SHOW DUMP
ERROR COZ ITS MANDATORY THAT THE 1ST TABLE SHOULD HAVE
VALUE.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / babita
If we don't check for intial condition for table 1 and its
is blank, all the records of second table will be displayed.
Hence it is a good practice to always check for following
before using 'FOR ALL ENTRIES'
if not itab1[] is intial.
Is This Answer Correct ? | 0 Yes | 0 No |
What is static attribute
Normally how many and what files get created when a transaction program is written?
what is backend and frontend in case of sap abap? whom we are supposed to call as backenduser and frontend user.
What are the Control levels in internal tables?
Control Break statements- At new...endat.
How to convert the Unit for 'Distance' (The value from one Unit to another).
What is an Extended IDOC and It's purpose?
what is a field symbol?
Search help exit details.
What are ranges?
In the process of creating a delivery tere is a firld date which needs to be saved, there is an userexit available but that exit does not have that date field in it, how would you overcome this. You have the delivery no that got created instead
what is the z-transaction?? what's the use of it??