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
How do you find the information on the current screen? : abap bdc
Difference between top-of-page and top-of-page during at line- selection?
Explain the systems fields used for interactive lists and lists?
How can we upload a text file having delimiters in to legacy system? : abap bdc
What are the advantages of abap query tool?
What does a lock object involve?
What is a badi?
What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary
Did you create any joins?
What are the 3 methods that we use in sequence in a batch input session method? : abap bdc
What does the insert statement in extract datasets do?
Sales Order Information Report that lists information like sales order no, Item no, material no, Quantity, Quantity unit, Net value, Currency,Sub Total, Grand Total. plz mention the detail coding Tahnks, Rahul
What is off cycle payroll run
Explain what are the events used for logical database?
What are the components in sap application server?