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).
Answer Posted / 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 |
Post New Answer View All Answers
What are the different database integrities?
What are the different attributes that can be assigned to a variant?
How to convert the Unit for 'Distance' (The value from one Unit to another).
could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance
Can you set up background processing using call transaction?
What is projection view?
Explain Catch Command in ABAP?
What is the abap program name to process the batch input session automatically? : abap bdc
How do you document ABAP programs? Do you use program documentation menu option?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
What is difference between float and packed data type?
What is web dynpro for abap?
What is table buffer?
What is match code? : sap abap hr
When the top-of-page event does get triggered?