How To Fix CNV_20100641 - Duplicate COES table key: &1 &2 &3 &4

CNV_20100641 - Overview

• Message type: E = Error

• Message class: CNV_20100 - Messageclass for chart of account conversion

• Message number: 641

• Message text: Duplicate COES table key: &1 &2 &3 &4

What causes this issue?

Converting table COES would lead to following duplicate table keys:
OBJNR, AWTYP = &V1&
AWKEY, AWSYS, AWPOS = &V2&
WRTTP, VRGNG, GJAHR = &V3&
PERIO, KSTAR, POSIT, TWAER = &V4&

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Error message extract from SAP system. Copyright SAP SE.

CNV_20100641 - Details

• The SAP error message CNV_20100641, which indicates a "Duplicate COES table key," typically arises during data migration or conversion processes, particularly when using the SAP S/4HANA Migration Cockpit or similar tools. This error suggests that there are duplicate entries in the COES (Cost Object Assignment) table, which is used to manage cost object assignments in SAP.
  
  Cause:
  The error occurs when the system encounters multiple records in the COES table that share the same key values. The key values are usually a combination of fields that uniquely identify a record in the table. The specific fields involved in the key are represented by the placeholders &1, &2, &3, and &4 in the error message. 
  Common causes for this error include:
  
  Data inconsistencies in the source system.
  Incorrect data mapping during the migration process.
  Duplicate records in the source data that were not identified or cleaned up prior to migration.
  
  
  Solution:
  To resolve this error, you can follow