How To Fix CNV_20100067 - Reconciliation acct &1 and non-reconc. acct &2 in CoCd &3 are merged

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 067

• Message text: Reconciliation acct &1 and non-reconc. acct &2 in CoCd &3 are merged

What causes this issue?

Either account &V1& or &V2& is a reconciliation account in company code
&V3&.
This is determined by the indicator <zk>Account is
reconciliation account</> (field SKB1-MITKZ).
These accounts are to be converted into account &V4&.

System Response

The conversion cannot take place.

How to fix this error?

Change the mapping table accordingly.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CNV_20100067 - Reconciliation acct &1 and non-reconc. acct &2 in CoCd &3 are merged ?

  The SAP error message CNV_20100067 indicates that there is a conflict in the reconciliation accounts during a data migration or conversion process. Specifically, it suggests that a reconciliation account (account type that is used to aggregate data from sub-ledgers) and a non-reconciliation account have been merged in the specified company code (CoCd). This can occur during the migration of financial data, especially when using tools like the SAP S/4HANA Migration Cockpit or other data conversion tools.
  Cause:
  
  Data Migration Issues: The error typically arises when the data being migrated contains inconsistencies, such as merging accounts that should remain distinct.
  Configuration Errors: Incorrect configuration of accounts in the SAP system can lead to this issue, particularly if reconciliation accounts are not properly defined.
  Duplicate Accounts: If there are duplicate accounts in the source system that are being merged into the target system, it can trigger this error.
  
  Solution:
  
  Review Account Configuration: Check the configuration of the reconciliation and non-reconciliation accounts in the SAP system. Ensure that they are correctly defined and that there are no overlaps.
  Data Cleansing: Before migration, perform data cleansing to ensure that there are no duplicate or conflicting accounts in the source data.
  Adjust Migration Settings: If using a migration tool, review the settings and mappings to ensure that reconciliation accounts are not being incorrectly merged with non-reconciliation accounts.
  Consult Documentation: Refer to SAP documentation or notes related to the specific migration tool you are using for any additional guidance on handling reconciliation accounts.
  Testing: Conduct thorough testing in a development or sandbox environment to identify and resolve any issues before performing the migration in the production environment.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions for this specific error message.
  Transaction Codes: Familiarize yourself with transaction codes related to account configuration, such as FS00 (G/L Account Master Record) and OBY6 (Define Company Code).
  Migration Cockpit: If using the SAP S/4HANA Migration Cockpit, review the migration object settings and mappings to ensure proper handling of accounts.
  Consult SAP Community: Engage with the SAP Community or forums for insights from other users who may have encountered and resolved similar issues.
  
  By addressing the underlying causes and following the suggested solutions, you should be able to resolve the CNV_20100067 error and successfully complete your data migration.