Symptom

• Low performance in transaction CKMLCP or significant runtime decrease.
• Material Ledger Active.
• Controlling (CO).

Environment

• Financial Accounting (FI).
• SAP R/3.
• SAP R/3 Enterprise 4.7.
• SAP ERP Central Component.
• SAP ERP.
• SAP enhancement package for SAP ERP.
• SAP enhancement package fo SAP ERP, version for SAP HANA.

Reproducing the Issue

1. You run the steps in transaction CKMLCP and the performance is too low or it has significantly decreased.
2. You experience the performance problems in one or several steps: ◦ Data Selection ◦ Cost Sequence Determination ◦ Single-Level Price Determination ◦ Multi-Level Price Determination ◦ Post Closing

Resolution

Check the SAP Note 2066349 which includes several useful improvements for the optimization of the Material Ledger period-end closing. Also, SAP Note 1617375improves efficiency of parallel processing, in particular for runs with many plants.

1. Step "Data Selection":

• The runtime increases with the total numbers of materials in the system. The "Data Selection" step has to read ALL materials to evaluate their period status and filter our the relevant one.
• The SAP note 1088317 optimizes the logic to check the period status, the database access to table CKMLPP is reduced and the runtime is lowered significantly.
• Implement the SAP Note 1609473 if it's not included in your system.