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

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message CNV_20200_CHECK090 - There are duplicate house bank account IDs in the participating CoCodes ?

  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 duplicates exist. This may involve reviewing the source data from which you are migrating.
  
  
  
  Consolidate or Rename:
  
  Depending on your business requirements, you may need to either consolidate the duplicate entries into a single house bank account or rename them to ensure uniqueness. This may involve:
  
  Merging transactions or balances associated with the duplicate accounts.
  Updating the relevant configurations in the SAP system.
  
  
  
  
  
  Update Configuration:
  
  After resolving the duplicates, ensure that the configuration in the SAP system reflects the changes made. This may involve updating the house bank settings in the Financial Accounting (FI) module.
  
  
  
  Re-run Migration:
  
  Once the duplicates are resolved, re-run the migration or conversion process to check if the error persists.
  
  
  
  Related Information:
  
  House Bank Configuration: Familiarize yourself with the configuration of house banks in SAP, which can be found under the Financial Accounting (FI) module. This includes understanding how house banks are set up and maintained.
  Data Migration Tools: If you are using SAP S/4HANA Migration Cockpit or other data migration tools, refer to the documentation for specific guidelines on handling house bank accounts.
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions related to this error message. You can search for notes in the SAP Support Portal.
  
  By following these steps, you should be able to resolve the CNV_20200_CHECK090 error and ensure that your house bank account IDs are unique across the participating company codes.