Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 9368 Views
- I also Faced
- E-Mail Answers
Answer Posted / sukhbir
Best option will be to select the data before loop and
inside loop use read statement.
select f1 f2 f3(key fields) from db into
iNtertab
for all entries in itab
where condition.
sort intertab by f1.
loop at itab.
read intertab with key f1 = itab-f1
binary search.
Endloop.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What’s value table?
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?
What is the function of the transport system and workbench organiser?
Explain the call transaction method? : abap bdc
What is meant by stacked list?
Which transaction code can I use to analyze the performance of abap program?
Explain the Importance of pa20? : abap hr
What are the attributes of a field that can be activated or deactivated during runtime?
how do you transport lsmw data from one system to another?
When the get cursor command used in interactive lists?
hi to all abap interview guys please notify this .. first if u have any doubts please go through google search or else please do debugging with some sample programs . but don't post even silly questions too. thanking you.
A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary
What are the names of the function modules that will be generated upon activation of a lock object?
What is a size category? : abap data dictionary
What is the difference between sum and collect?
