FM performance tuning

[Former Member]

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,

Vj

[Former Member]

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

[Mohamed_Mukhtar]

Hi Vijay,

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

Thanks

[Mohamed_Mukhtar]

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