Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 8835 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
Is the basic list deleted when the new list is created?
What are the data types of the external layer? : abap data dictionary
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
How do you restrict the data to be entered in the payroll area? : sap abap hr
Explain what are the different functions used in sap script?
Why do we use FOR ALL ENTRIES and what is the pre-requisite
What are the types of parameters in the function modules?
What is size category?
What is alv programming in abap?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.
What is the function of the transport system and workbench organizer?
What are the functional areas? User groups? And how does abap/4 query work in relation to these?
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
how 2 create the normal form by using functional module
