How To Fix CNV_20200_CHECK090 - There are duplicate house bank account IDs in the participating CoCodes

CNV_20200_CHECK090 - Overview

• Message type: E = Error

• Message class: CNV_20200_CHECK - Messages for check functions (company code merge)

• Message number: 090

• Message text: There are duplicate house bank account IDs in the participating CoCodes

What causes this issue?

There are duplicate house bank account IDs in the participating company
codes.

System Response

Warning with Action required

How to fix this error?

The business processes in bank accounting must be analyzed for these
conflicts, and you must specify mapping values.
Check whether the duplicate house bank account ID in the participating
company codes refers to the same house bank and to the same accounts.
If this is not the case, that is, if the same house bank account ID
refers to different objects, the house bank account ID must be renamed
during the company code merge.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

CNV_20200_CHECK090 - Details

• The SAP error message CNV_20200_CHECK090 indicates that there are duplicate house bank account IDs in the participating company codes (CoCodes) during a data migration or conversion process. This error typically arises in the context of financial data migration, particularly when using SAP's Conversion Tools or during the implementation of SAP S/4HANA.
  
  Cause:
  The error is caused by the presence of multiple entries for the same house bank account ID across different company codes. In SAP, each house bank account should be unique within a company code, and having duplicates can lead to inconsistencies in financial reporting and transactions.
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Identify Duplicates:
  
  Use transaction codes like SE16 or SE11 to access the relevant database tables (e.g., BNK_ACCT or T012 for house bank accounts) and identify the duplicate house bank account IDs across the participating company codes.
  
  
  
  Review Data:
  
  Check the data entries for the house bank accounts to understand why