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).
- 4 Answers
- 10979 Views
- I also Faced
- E-Mail Answers
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 is the maximum number of match code id's that can be defined for one match code object ?
Differentiate between abap memory and sap memory?
How to handle error in session method? : abap bdc
What is personnel sub are
Lock objects and what are parameters of ENQUEUE FM?
Explain the function module in bdc?
What are the Control levels in internal tables?
What are the abap/4 commands that link to a layout set?
What is abap work bench?
There is 1 person but it’s displaying that this person cannot be booked. He is not available for the business event. Can you tell me where is it going wrong? What can be the reasons? : sap abap hr
How many main windows will be there in a page window?
what is abstract classes
How to read 5th record from Hash Internal Table?
What are the control break events in abap? : abap data dictionary
How to find the return code of an stmt in abap programs?
