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 |
6. what are the differences between scripts & smart forms?
What are the different types of work process?
what are the tools you are using for performance tuning in a object?
What is the exact difference between pooled table and cluster table and explain with examples?
why we use pick statement in abap?
which Editor does ABAP provide?
Do you know how to manage the sequence of passes in a Form?
can we create views in bdc
why are we using events in reports than control break statements?
Hi Friends, I want to learn sap sd module as it has to be learn to get job in sap platform. I have seen many institution not imparting training as it has to be impart. I want to learn SD Module with running Business Scenario CIN (Country Version India) Realtime Projects (implementation & Support) I want sap realtime data for reference, practice Please help me out
In SE11 we created two database tables say some 1000 fields each.Now f we want both the tables combined into one table, how do we do that?
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?