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
- 9910 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 do you do when the system crashes in the middle of a BDC batch session?
What is an interactive report?
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why?
What are the domains and data element?
What do you mean by transparent tables in sap abap? : abap data dictionary
how can we enable hyperlink in screen painter?
What are internal tables? : abap hr
If yes then why do we require logical database
What is processing class, where we do them and why? : sap abap hr
how can you display data say "your name"in sap script without print program or driver program??
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?
What is generic buffering?
What is an evaluation path? : sap abap hr
What is buffering in abap?
What is an interface? In what scenario we use interface? What is the difference between abstract class and interface?
