How To Fix S_AUT120 - Inconsistency between filter table and transaction S_AUT04

SAP Error Message - Details

• Message type: E = Error

• Message class: S_AUT - Audit Trail (ILM): Messages

• Message number: 120

• Message text: Inconsistency between filter table and transaction S_AUT04

What causes this issue?

You have made changes to the configuration for long text deletion and
wish to save these without synchronization of the filter table
(STXXFILTER).
There are inconsistencies between the settings for this transaction and
the filter table which may lead to data loss.

System Response

The data cannot be saved without synchronization of the filter table.

How to fix this error?

Either align the filter table or delete the content of the filter table
completely (menu: Goto -> Delete Filter Table).
Note that if the filter table is completely deleted, all long text
changes are logged. This puts an increased load on the database and
leads to a deterioration in 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 S_AUT120 - Inconsistency between filter table and transaction S_AUT04 ?

  The SAP error message S_AUT120 indicates an inconsistency between the filter table and the transaction S_AUT04, which is related to authorization checks in the SAP system. This error typically arises when there is a mismatch between the authorization objects defined in the filter table and those that are being used in the transaction.
  Cause:
  
  Inconsistent Authorization Objects: The filter table may contain authorization objects that are not present in the transaction S_AUT04, or vice versa.
  Changes in Authorization Roles: If roles or authorizations have been modified, it can lead to inconsistencies if the changes are not reflected in the filter table.
  Transport Issues: If changes were transported from one system to another (e.g., from development to production), inconsistencies may arise if the filter table was not updated accordingly.
  Manual Changes: Manual changes to the filter table or the transaction can lead to discrepancies.
  
  Solution:
  
  Check Filter Table Entries: Review the entries in the filter table to ensure that they match the authorization objects used in transaction S_AUT04.
  Update Filter Table: If there are missing or incorrect entries, update the filter table to reflect the correct authorization objects.
  Consistency Check: Use transaction SU25 to perform a consistency check between the authorization objects and the filter table. This can help identify discrepancies.
  Role Maintenance: If roles have been changed, ensure that the changes are properly reflected in the filter table. You may need to regenerate roles or reassign authorizations.
  Transport Management: If the issue arose after a transport, ensure that all relevant objects were transported correctly and that the filter table is consistent across systems.
  Consult Documentation: Refer to SAP documentation or notes related to authorization management for further guidance.
  
  Related Information:
  
  Transaction Codes: 
  
  S_AUT04: Used for authorization checks.
  SU25: Used for maintaining and checking authorizations.
  
  
  Authorization Objects: Understand the specific authorization objects involved in the transaction and how they relate to the filter table.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  Support: If the issue persists, consider reaching out to SAP support for assistance, especially if it involves complex authorization scenarios.
  
  By following these steps, you should be able to resolve the S_AUT120 error and ensure consistency between the filter table and the transaction.