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 |
What is logical data base
what is the difference between se16 and se17 ??? need urgent ans plz..
What is the role of an abapper in support project?What is the ticket concept in support project?Who raise the ticket and who resolve it?Let me know the complete procedure?
HOW TO TRANSFER MATERIAL MASTER DATA FROM LEGACY SYSTEM (ORACLE) TO SAP USING A FUNCTION MODULE BAPI_MATERIAL_SAVE_DATA. IF ANYBODY KNOW THE ANSWER PLZ MAIL TO MY ID SHAIKZIA@GMAIL.COM
What is features and transaction code
Is multiple implementation possible for one BADI definition? If possible the how can you know that which BADI is active.
in mm and sd,in which table plant and storage location are there?
Explain the disadvantages of different types of bdc's?
What is the difference between a structure and a table?
Dear Experts pls answer the folowing qs that i have faced in the recent intvws: a) Can we execute the script individually? If yes How? Else what we need to do so? b) Are Layout sets Client independent? c) How do you assign a print program to a script? d) Can we call a subroutine in a script? If so, how? e) What are the steps to print SAP script form?
What is the difference between report and script?
Can ‘where’ clause be used when updating database entries?