How To Fix FIBL696 - Inconsistency between house bank account table and house bank table

SAP Error Message - Details

• Message type: E = Error

• Message class: FIBL - Messages from Tax Routines / Prenumbered Checks

• Message number: 696

• Message text: Inconsistency between house bank account table and house bank table

What causes this issue?

The house bank account table T012K contains an entry with account
number &V2&. There is no entry in the house bank table T012 with bank
code &V1& for this entry.

How to fix this error?

Maintain the house bank tables.

<DS:TRAN.FI12>Proceed</>
ENDIF

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FIBL696 - Inconsistency between house bank account table and house bank table ?

  The SAP error message FIBL696 indicates an inconsistency between the house bank account table and the house bank table. This typically occurs when there are discrepancies in the data related to house banks and their associated accounts in the SAP system.
  Cause:
  
  
  Data Inconsistency: This error often arises when there are entries in the house bank account table (T012) that do not have corresponding entries in the house bank table (T012K). This can happen due to:
  
  Manual data entry errors.
  Deletion of house banks or accounts without proper updates to related tables.
  Data migration issues where not all related records were transferred correctly.
  
  
  
  Configuration Issues: Incorrect configuration settings in the house bank setup can also lead to inconsistencies.
  
  
  System Errors: Bugs or issues in the SAP system that affect the integrity of the data.
  
  
  Solution:
  To resolve the FIBL696 error, you can follow these steps:
  
  
  Check Data Consistency:
  
  Use transaction codes like SE16 or SE11 to check the contents of the T012 (House Bank) and T012K (House Bank Accounts) tables.
  Identify any entries in T012K that do not have corresponding entries in T012.
  
  
  
  Correct Inconsistencies:
  
  If you find orphaned entries in T012K, you may need to delete or correct them. This can be done using transaction code SE14 (Database Utility) to adjust the database entries.
  If there are missing entries in T012, you may need to create them or correct the existing entries.
  
  
  
  Use SAP Reports:
  
  SAP provides standard reports that can help identify inconsistencies. You can run the report RFIBL00 (House Bank Account Report) to check for discrepancies.
  
  
  
  Reconfigure House Banks:
  
  If the issue is due to configuration, review the house bank settings in transaction code FI12 (House Bank) and ensure that all necessary configurations are correctly set.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates that resolve known issues.
  
  
  
  Backup and Test:
  
  Before making any changes, ensure you have a backup of your data. Test any changes in a development or test environment before applying them to production.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  FI12: House Bank Configuration
  SE16/SE11: Table Display
  SE14: Database Utility
  RFIBL00: House Bank Account Report
  
  
  
  Tables:
  
  T012: House Bank Table
  T012K: House Bank Accounts Table
  
  
  
  SAP Support: If the issue persists after following the above steps, consider reaching out to SAP Support for further assistance.
  
  
  By following these steps, you should be able to identify and resolve the inconsistency causing the FIBL696 error in your SAP system.