Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
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 will happen when we use single buffered selected?
How to debug a sapscript?
What is the use of the raising exception? : abap modularization
What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary
What are the different types of internal table?
i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status
What are the drill-down features provided by abap/4 in interactive lists?
How will you read from internal table records in a given value range (without using loop)
How is collect statement different from append?
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What data is contained? : abap data dictionary
What is the difference between collect and sum?
What is the differences between abap and ooabap. In which situation we useooabap?
What are the control break events in abap? : abap data dictionary
What is view? Different types of view. Explain?