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

SAP Error Message - Details

• 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.