Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12018 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
Business scenarios related to your objects( In my case -Rulebook and Pricing work flow)
What is a help view? : abap data dictionary
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
How to transfer the objects? Have to transferred any objects?
What is ole?
Name some data dictionary objects?
How to debug a sapscript?
Performance tuning techniques
what is the difference between hashed & sorted internal tables?
What two statements are required in an abap program to output an icon using a write statement?
What is the sap abap?
Folder types in smatforms? 2)What is Command line?
What is the structure of bdcmsgcoll? : abap bdc
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
In delivery processing which step comes first picking, packing, posting goods issue ?
