How To Fix SZDM_CC_CHKS_TITLES126 - An XPRA report accessed a table with Native-SQL

SZDM_CC_CHKS_TITLES126 - Overview

• Message type: E = Error

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

• Message number: 126

• Message text: An XPRA report accessed a table with Native-SQL

What causes this issue?

A trace in one of the SAP internal test systems has found that your XPRA
accessed a database table by native SQL (either EXEC-SQL or ADBC).
The name of the XPRA and the name of the system where the trace was
executed and where you can find the call stack leading to the native SQL
command can be found in the detailed messages. Inspect the call stack in
order to find out the name of the accessed database table.

System Response

If the XPRA runs as part of a zero-downtime-upgrade in a customer
system, then the upgrade procedure aborts with an error message. Solving
this kind of errors requires help from the SAP development support.

How to fix this error?

If you have already declared the table that your XPRA accesses via
native SQL, then apply for an exemption for this ATC-message.
If you have not yet declared the table, then make the necessary
declaration in your development or maintenance system:

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

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.
<DS:TX.SZDM_CC_GENERAL_ZDO>Further information ...</>

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

SZDM_CC_CHKS_TITLES126 - Details

• The SAP error message SZDM_CC_CHKS_TITLES126 indicates that an XPRA (a type of report used in SAP for data migration or adjustments during upgrades) has accessed a table using Native SQL, which is not allowed in certain contexts. This error typically arises during system upgrades or when executing specific reports that are not compliant with the current system's data access rules.
  
  Cause:
  
  Native SQL Usage: The XPRA report is trying to access database tables directly using Native SQL, which can lead to inconsistencies and is generally discouraged in favor of Open SQL.
  Upgrade Issues: This error often occurs during system upgrades when certain reports or programs are not updated to comply with the new standards or restrictions.
  Custom Code: If there are custom developments or modifications that utilize Native SQL inappropriately, this can trigger the error.
  
  
  Solution:
  
  Review the XPRA Report: Check the specific XPRA report that is causing the error. If it is a standard SAP