topic FM performance tuning in Application Development and Automation Discussions

FM performance tuning

Former Member — Tue, 24 Mar 2015 02:48:07 GMT

Hi,

I am using FM BAPI_CUSTOMERCONTRACT_CHANGE and FM SD_SALES_BILLINGPLAN_CHANGE,but while executing its taking almost 20 minutes to execute each record,so i did sql trace and i found its taking more time to fetch records in coes table in include LKAOVF16 while executing sql stmt to fetch records ( almost 15 minutes ),but when i use se11 or just coding i can fetch in about 10 seconds.

Any idea to tune FM.( memory buffering anything is really appreciated ).

Cheers,

Re: FM performance tuning

Former Member — Tue, 24 Mar 2015 04:07:48 GMT

Hi Vijay

I'd recommend raising an Incident with SAP as it is a Standard Function.

They should provide a fix for this in the form of a Note.

Before logging the Incident make sure a Note is not already available

Regards

Arden

Re: FM performance tuning

Mohamed_Mukhtar — Tue, 24 Mar 2015 04:20:11 GMT

Hi Vijay,

Please find which index is being picked while fetching data from COES table.
Check the index quality and ask basis team to rebuild the index and update the statistics.

Thanks

Re: FM performance tuning

Mohamed_Mukhtar — Tue, 24 Mar 2015 04:33:42 GMT

Hi Vijay,

Please check the below SAP NOTES :-

1160226 - VA01: Long runtimes in table COES when creating order

2143818 - VA01: Long runtime because of select-statements on database table COES

Thanks

-Learner