Skip to Content
0
Former Member
Dec 11, 2012 at 07:27 PM

Performance Tuning-Conversion Exits used in a loop

227 Views

Hi Experts,

I am doing some performance tuning on a report as it leads to time outs sometimes.

I have found a loop-endloop which takes long time it is as follows:

ITAB has 26400 records

Time for loop to finish around 1 min

loop at itab

1. CONVERSION_EXIT_KONPD_OUTPUT this converts itab-psphi to vbeln

2. CONVERSION_EXIT_ALPHA_INPUT add leading zeros to vbeln

3. CONVERSION_EXIT_ABPSP_INPUT convert itab-posid to WBS element

Append ITAB to ITAB_FINAL

endloop.

To improve this i am doing as follows

loop at itab

read buffer table if conversion exists use the internal table

1. CONVERSION_EXIT_KONPD_OUTPUT and storing it in a buffer table and using that instead for next records

2. Instead of CONVERSION_EXIT_ALPHA_INPUT movng the field to numeric 10 so no conversion exit required

3.CONVERSION_EXIT_ABPSP_INPUT as it is (WBS are unique)

Append ITAB to ITAB_FINAL

endloop.

Does help much and the process only improves by 10 seconds.

Can someone advice if something better can be done or remove conversion exits?