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 |
if i want to insert 10 laks MM records and for inserting one record it takes 1 min by using call transaction or session method . so here is there any alternative
What are the different types of parameters? How can you distinguish between different kinds of parameters?
how do you work with semi colon separated files in bdc ?
Specify the types of data dictionary objects.
How many types of buffering? : abap data dictionary
Among pooled and Cluster tables, in which table data used to store in Row Format?
What are the events used for page headers and footers?
i have 3 screens say S1,S2,S3 and i want to validate only S3.What code shud i write in the flowlogic of the screen??
2 Answers Siemens, Tech Mahindra,
How can you find the field/data underlying a transaction?
Where do you find info on new developments in SAP?
What is database utility? : abap data dictionary
what is the various print modes available with SAP scripts?