How To Fix SZDM_CC_CHKS_TITLES131 - An XPRA report performed a non-declared read-access to a table

SAP Error Message - Details

• Message type: E = Error

• Message class: SZDM_CC_CHKS_TITLES - Title messages related to check classes

• Message number: 131

• Message text: An XPRA report performed a non-declared read-access to a table

What causes this issue?

A trace in one of the SAP internal test systems has found that your XPRA
reads from a database table that is not declared in the ZDO declarations
of the XPRA.
The name of the XPRA, the name of the table and the name of the system
where the trace was executed and where you can find the call stack
leading to the non-declared read access can be found in the detailed
messages.

System Response

If the XPRA runs as part of a zero-downtime-upgrade in a customer
system, then the upgrade procedure writes a warning message to the
upgrade logfiles. Non declared read accesses can lead to invalid results
of an XPRA.

How to fix this error?

If you have not yet declared the tables, then make the necessary
declarations in your development or maintenance system:
Call transaction SLAPI
Search for an entry with name
SAP_XPRA_<name of the XPRA-report> or
<namespace>SAP_XPRA_<name of the XPRA-report>.
If there is no such entry, then create a new one with this name.
For this SLAPI-entry, select "Used database tables" in the navigation
area.
Enter the names of the accessed tables with an appropriate value for
"Access type" and "Lock mode".
If the RFC-module calls an APIs that is listed in transaction SLAPI,
then enter the name of this APIs in "Ref to other API".
If the RFC-module calls an API that is not listed in transaction SLAPI
then ask the owner of the API to create an SLAPI entry for this API and
declare all accessed tables there.

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

<DS:TX.SZDM_CC_GENERAL_ZDO>Further information ...</>

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 SZDM_CC_CHKS_TITLES131 - An XPRA report performed a non-declared read-access to a table ?

  The SAP error message SZDM_CC_CHKS_TITLES131 indicates that an XPRA (a type of report used in SAP for data migration or system upgrades) has attempted to access a database table in a way that is not declared or permitted. This typically occurs during system upgrades or when applying support packages, where the XPRA is trying to read data from a table that it does not have explicit permission to access.
  Cause:
  
  Non-Declared Access: The XPRA report is trying to read from a table that is not declared in its access list. This can happen if the XPRA is outdated or if there have been changes in the database schema that the XPRA is not aware of.
  Authorization Issues: The user executing the XPRA may not have the necessary authorizations to access the table.
  Custom Modifications: If there are custom modifications or enhancements in the system that affect the standard behavior of the XPRA, it may lead to this error.
  
  Solution:
  
  Check XPRA Version: Ensure that you are using the latest version of the XPRA. If not, consider updating it or applying the latest support package.
  Review the XPRA Code: If you have access to the code of the XPRA, review it to identify any non-declared accesses. You may need to modify the XPRA to include the necessary table declarations.
  Authorization Check: Verify that the user executing the XPRA has the necessary authorizations to access the relevant tables. You may need to adjust the user roles or permissions.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that address this specific error. SAP may have provided patches or workarounds for this issue.
  Contact SAP Support: If the issue persists, consider reaching out to SAP Support for assistance. Provide them with the details of the error and the context in which it occurred.
  
  Related Information:
  
  XPRA Reports: These are typically executed during system upgrades or when applying support packages. They are designed to migrate data or adjust the database schema.
  Database Tables: Understanding the structure and access permissions of the database tables involved can help in troubleshooting the issue.
  SAP Community: Engaging with the SAP Community forums can provide insights from other users who may have encountered similar issues.
  
  By following these steps, you should be able to diagnose and resolve the error message SZDM_CC_CHKS_TITLES131 effectively.