Unnecessary update of period records
[ACTCLOSE] [ACTUPD] [CKMS]
Symptom
If the material ledger is active, there are unnecessary database accesses during different transactions with a material reference (for example, goods movements or period-end closing). This may cause the following problems:
The runtime and database load may be increased.There may be deadlocks.There also may be database inconsistencies when you execute different transactions at the same time.
Other terms
ACTUPD, ACTCLOSE, CKMS
Reason and Prerequisites
The unnecessary database accesses affect the material ledger period records (tables CKMLPP and CKMLCR). Records (for example, the records of the previous period in a goods posting to the current period) that have not been changed by the transaction are also sent to the database to be updated.
Solution
Implement the corrections.
Important: Before you can use transaction SNOTE to implement the corrections, you have to make the following manual changes depending on your release:
Add the following import parameter to the interface of the function module CKMS_POST_PERIOD_DELTA (to do this, call transaction SE37, enter the function module name, choose “Change” and choose the “Import” tab):
Parameter Name I_NEW_OBJECTS
Typing TYPE
Associated Type XFELD
Default value SPACE
Optional ‘X’
Pass Value ‘X’