How To Fix AUT120 - Inconsistency between filter table and AUT04

SAP Error Message - Details

• Message type: E = Error

• Message class: AUT - Messages for Enhancement for Audit Trails

• Message number: 120

• Message text: Inconsistency between filter table and AUT04

What causes this issue?

You have made changes to the long text deletion configuration, and you
want to save these without comparing the filter table (<AB>
STXXFILTER</>).
There are inconsistencies between the settings in these transactions and
the filter table that could lead to loss of data.

System Response

The data cannot be saved without filter table comparison.

How to fix this error?

Either match the filter tables or delete the contents of the filter
table completely (menu: Goto -> Delete Filter Table).
Note that if you delete the filter table, all long text changes are
logged. This leads to increased data load on the database, and decreased
performance.

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 AUT120 - Inconsistency between filter table and AUT04 ?

  The SAP error message AUT120 indicates an inconsistency between the filter table and the AUT04 table, which is related to the authorization management in SAP systems. This error typically arises in the context of authorization checks, particularly when there are discrepancies in the data that governs user access rights.
  Cause:
  
  Data Inconsistency: The primary cause of this error is a mismatch between the entries in the filter table (which defines the authorization objects and their values) and the entries in the AUT04 table (which contains the actual authorization data).
  Changes in Authorization Objects: If there have been recent changes to authorization objects or roles, and the filter table has not been updated accordingly, this can lead to inconsistencies.
  Transport Issues: If authorization objects or roles were transported from one system to another (e.g., from development to production) without proper synchronization, inconsistencies may arise.
  Manual Changes: Manual changes to authorization settings or roles that do not reflect in the filter table can also lead to this error.
  
  Solution:
  
  Check Filter Table Entries: Review the entries in the filter table to ensure they match the expected values in the AUT04 table. You can use transaction codes like SUIM or SU01 to check user authorizations and roles.
  Consistency Check: Use transaction code SU25 to perform a consistency check between the authorization objects and the filter table. This transaction can help identify discrepancies and suggest corrections.
  Recreate Filter Entries: If necessary, you may need to recreate the filter entries to ensure they align with the current authorization settings.
  Transport Requests: If the issue arose after a transport, check the transport logs and ensure that all relevant objects were transported correctly. You may need to re-transport or adjust the settings.
  Authorization Trace: Use transaction code ST01 to perform an authorization trace to identify which specific authorizations are causing the issue.
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error or provide additional guidance.
  
  Related Information:
  
  Authorization Management: Understanding how SAP handles authorizations is crucial. Familiarize yourself with the concepts of roles, profiles, and authorization objects.
  SAP Documentation: Refer to the official SAP documentation for detailed information on authorization management and troubleshooting authorization issues.
  User Roles and Profiles: Ensure that user roles and profiles are correctly assigned and that there are no conflicts between them.
  
  If the problem persists after following these steps, it may be beneficial to consult with your SAP Basis or Security team for further investigation and resolution.