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 are authorization objects and what statement is used to perform an authorization check in an abap program?
What is roll area?
What is netweaver???what is the relationship with ABAP?
What is the company code? : sap abap hr
Explain what is the difference between sy-tabix and sy-index? Where it is used?
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
Control Break statements- At new...endat.
What is img? : sap abap hr
can anybody give me functional specification (or table name & field names) of stock analysis report, work in progress report,generating vendor detailed list
what is defference between repository and non repository Object?
Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
What are the different types of luws. What are they?
What is sap script? Describe its components.
Where do you create indexes in abap?
When to use logical database?