Interested to Buy Any Domain ? << Click Here >> for more details...
Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 9929 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 is filter dependent BADI?
What is the difference between a dialog program and a report?
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
What is a predefined type in abap?
What are extracts?
what are the two methods of modifying sap standard tables? : abap data dictionary
How do you restrict the data to be entered in the payroll area? : sap abap hr
What are lock objects?
Explain the Types of Select statements?
How to load data from ms excel sheet to sap by using bdc method ? : abap bdc
Explain the client concept of sap.
How can we decide weather we can enhance the standard infotype or not ? : abap hr
How to find the return code of a statement in abap programs?
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?
what precautions or prerequisites do you follow to update a record into database table and how
