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
- 10209 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 are the different types of data dictionary objects? : abap data dictionary
How do you send files to the legacy systems from SAP and vice versa? How does one know that the legacy files have come on to the SAP server you are working on?
GUYS any one please can u post questions in sap a bap webdynpro questions.. please i need to know some technical questions regarding webdynpro and ADOBE forms ?
In delivery processing which step comes first picking, packing, posting goods issue ?
in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.
Can we create a gui status in a program from the object browser?
Concepts of OO ABAP and why we are using it?
Name some data dictionary objects?
What is the symbol to do “concatenation” operation in nw abap 7.4 ?
What is off cycle payroll run
How can we decide weather we can enhance the standard infotype or not ? : abap hr
What is step-loop?
Why are insert and append statement used in sap abap?
What are the prerequisites for creating foreign key relationship?
What is the difference between a structure and a table? : abap data dictionary
