SAP Note 28362 - KSPU: Reverse revaluation: Update termination

Symptom:

An update termination occurs when you reverse a plan revaluation. Termination: DUPLICATE RECORD in table COEJ

Cause and prerequisites

Preconditions:
- Activity-dependent planned cost elements exist
and
- there are activity-dependent planned cost elements that are not
contained in the revaluation definition.
- The plan integration (line item update) is active in the affected
version

Cause: The selection of the activity-dependent cost elements was made
without cost element restriction so that a rate with zero
values was written for all cost elements not specified in the
revaluation definition because the calculation was made with 0 %
here.
During the reversal, no new document numbers are assigned for
these rates and the update termination occurs.

Solution
Corrected in 3.0A.
You can implement the correction as described below in all releases < 3.0A.

Additional key words

KSPU, SAPMKPU2, SAPSQL_ARRAY_INSERT_DUPREC