How To Fix FINS_RECON345 - Open item in BSEG, missing in BSID_BCK: &1 message(s)

SAP Error Message - Details

• Message type: E = Error

• Message class: FINS_RECON - SAP S/4HANA Finance Migration: Reconciliation

• Message number: 345

• Message text: Open item in BSEG, missing in BSID_BCK: &1 message(s)

What causes this issue?

There are open line items in table BSEG which are <ZH>not</> available
in the index table BSID_BCK but these open line items are already
available in the index table BSAD_BCK.

System Response

The system informs about this inconsistency which has to be corrected in
your productive system before starting the data migration.

How to fix this error?

This inconsistency can be corrected by program 'FIN_CORR_MIG_ERROR_SFIN'
in the original source system (i. e. your productive system):
If you want to correct inconsistencies concerning clearing information
found in migration to S/4HANA Finance, then you have to start program
FIN_CORR_MIG_ERROR_SFIN in the original source system. The
inconsistencies which have to be corrected are determined by a RFC-call
from the original source system to this system. For more information,
read the program documentation of program FIN_CORR_MIG_ERROR_SFIN in the
original source system.
This procedure of correction in the original source system will ensure
that these inconsistencies will not occur in future test migrations any
more.

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 FINS_RECON345 - Open item in BSEG, missing in BSID_BCK: &1 message(s) ?

  The SAP error message FINS_RECON345 indicates that there is an inconsistency between the open items in the BSEG table (which contains line items for accounting documents) and the BSID_BCK table (which is a backup table for open items in accounts receivable). Specifically, the error suggests that there are open items in BSEG that are not found in the BSID_BCK table.
  Cause:
  
  
  Data Inconsistency: This error typically arises due to data inconsistencies between the BSEG and BSID_BCK tables. This can happen due to various reasons, such as:
  
  Incomplete or failed data migration processes.
  Manual changes or deletions in the database that bypassed standard SAP processes.
  Issues during the posting of accounting documents that did not properly update both tables.
  
  
  
  System Errors: Sometimes, system errors or bugs during updates or upgrades can lead to inconsistencies in the database.
  
  
  Custom Developments: If there are custom programs or enhancements that manipulate financial data, they might not be correctly handling the updates to both tables.
  
  
  Solution:
  
  
  Data Consistency Check: 
  
  Run a consistency check to identify the specific open items causing the issue. You can use transaction codes like FB03 to view the documents in BSEG and BSID to check the open items in accounts receivable.
  Use the SAP transaction SARA to archive and delete old data if necessary, ensuring that the archiving process is correctly configured.
  
  
  
  Reconciliation: 
  
  If you identify specific entries that are causing the issue, you may need to manually reconcile them. This could involve adjusting or posting correcting entries to ensure that both tables reflect the same open items.
  
  
  
  SAP Notes: 
  
  Check the SAP Support Portal for any relevant SAP Notes that address this specific error. There may be patches or updates that resolve known issues related to this error message.
  
  
  
  Consult SAP Support: 
  
  If the issue persists and you cannot resolve it through the above steps, consider reaching out to SAP Support for assistance. They can provide guidance based on the specific details of your system and the error.
  
  
  
  Related Information:
  
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as:
  
  FB03: Display Document
  BSID: Accounting: Secondary Index for Customers
  BSEG: Accounting Document Segment
  SARA: Archive Administration
  
  
  
  Database Tables: Understand the structure and purpose of the BSEG and BSID_BCK tables, as well as any other related tables that may be involved in the reconciliation process.
  
  
  Backup Procedures: Ensure that you have proper backup procedures in place before making any changes to the database to prevent data loss.
  
  
  By following these steps, you should be able to identify the cause of the FINS_RECON345 error and implement a solution to resolve the inconsistency between the BSEG and BSID_BCK tables.