Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jammy
No, It is not recommended to do that as it kills the
performance.
Is This Answer Correct ? | 4 Yes | 2 No |
How do you move on to the next screen in interactive reporting?
How to get the no of records using select statement?
What are the attributes of the data in data dictionary? : abap data dictionary
What is the difference between field-group header and other field groups? : abap modularization
Differentiate select and select single?
What are plan versions used for? : sap abap hr
to link the loop to a table control we use the addition WITH CONTROL else this works as as stand-alone________________?
what is a binary search ? and how it is useful in a sorted internal table?
When we are updating certain database table with 100 records and we found that only 60 records are updated, then how to find the errror records and how to correct and updated again? Explain step by step.
i have created a smartform containing table which start from middle of first page.when i run smartform then on next page same table appears which start from middle of page.so how to get table that start from top of next page??
what is the variable to be used in sap scripts to find the total number of pages of the print job?
How can I make a differentiation between dependent and independent data?