How To Fix FINS_RECON343 - &1: Item in BSEG_ADD but missing in tables FAGLBSIS_BCK and FAGLBSAS_BCK

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 343

• Message text: &1: Item in BSEG_ADD but missing in tables FAGLBSIS_BCK and FAGLBSAS_BCK

What causes this issue?

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

System Response

How to fix this error?

Details about this issue (possible missing entries in both index tables)
can be found in the summary at the end of the application log (message
number 353).

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FINS_RECON343 - &1: Item in BSEG_ADD but missing in tables FAGLBSIS_BCK and FAGLBSAS_BCK ?

  The SAP error message FINS_RECON343 indicates that there is a discrepancy between the BSEG_ADD table and the balance sheet tables FAGLBSIS_BCK and FAGLBSAS_BCK. This typically occurs during the reconciliation process, where the system expects certain entries to be present in the balance sheet tables but finds them missing.
  Cause:
  
  
  Data Inconsistency: The most common cause of this error is data inconsistency between the BSEG_ADD table (which contains additional line item data) and the balance sheet tables (FAGLBSIS_BCK and FAGLBSAS_BCK). This can happen due to incomplete postings, failed updates, or issues during data migration.
  
  
  Missing Entries: If there are entries in BSEG_ADD that should have been posted to the balance sheet tables but were not, this error will occur.
  
  
  Custom Developments: If there are custom programs or enhancements that manipulate financial data, they might inadvertently lead to inconsistencies.
  
  
  System Upgrades or Migrations: Changes in the system, such as upgrades or migrations, can sometimes lead to inconsistencies if not all data is properly migrated.
  
  
  Solution:
  
  
  Check for Missing Entries: Investigate the entries in the BSEG_ADD table that are causing the error. You can do this by running a query to identify the specific entries that are missing in FAGLBSIS_BCK and FAGLBSAS_BCK.
  
  
  Reconcile Data: If you find discrepancies, you may need to reconcile the data manually. This could involve posting the missing entries or correcting any inconsistencies.
  
  
  Use Transaction Codes: Utilize transaction codes like FB03 (Display Document) to view the documents in question and understand why they are not reflected in the balance sheet tables.
  
  
  Run Reconciliation Programs: SAP provides standard reconciliation programs that can help identify and fix inconsistencies. You can run programs like F.5 (Reconcile General Ledger) to help identify issues.
  
  
  Check Custom Code: If there are custom developments, review the code to ensure it is not causing the issue. You may need to involve your ABAP team for this.
  
  
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that might address this specific error. There may be patches or updates that resolve known issues.
  
  
  Contact SAP Support: If the issue persists and you cannot find a resolution, consider reaching out to SAP Support for assistance.
  
  
  Related Information:
  
  BSEG_ADD: This table contains additional line item data for accounting documents.
  FAGLBSIS_BCK: This table is used for storing balance sheet line items in the new General Ledger.
  FAGLBSAS_BCK: This table is used for storing balance sheet account balances in the new General Ledger.
  Transaction Codes: Familiarize yourself with relevant transaction codes for financial reporting and reconciliation in SAP.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.