3338020 - [S/4HANA Cloud 2302.3] Error when calling API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPrcgCndnRecdValidity

When the API /sap/opu/odata/sap/API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPrcgCndnRecdValidity is called, one of below errors is returned.

• 500 Internal Server Error: In the context of Data Services an unknown internal server error occurred
• CX_SY_OPEN_SQL_DB : Database returned the SQLcode 391. Error text: invalidated view:ASLSPRCGCNDNVA: line 1 col 3967 (at pos 3966).

SAP S/4HANA Cloud 2302.3

1. Call the API, for example the URL is https://domain.s4hana.ondemand.com/sap/opu/odata/sap/API_SLSPRICINGCONDITIONRECORD_SRV/A_SlsPrcgCndnRecdValidity
2. One of below errors is returned.
   • 500 Internal Server Error: In the context of Data Services an unknown internal server error occurred
   • CX_SY_OPEN_SQL_DB : Database returned the SQLcode 391. Error text: invalidated view:ASLSPRCGCNDNVA: line 1 col 3967 (at pos 3966).

This is a known Regression issue caused by inconsistent state of some CDS Views. For example, the CDS views are:

• A_SLSPRCGCNDNRECDVALIDITY (Data Definition)
• C_SLSPRICINGCONDITIONRECORDTP (Data Definition)
• I_SLSPRCGCNDNRECDTEMPLATE (Data Definition)
• I_SLSPRICINGCONDITIONRECORDTP (Data Definition)

Please create a SAP Case describing the symptom under component BC-DWB-DIC and attach this KBA. SAP Development Team will fix the issue for you. SAP Product Support will keep this KBA up-to-date and let you know when the permanent fix is available.

Condition Record for Pricing in Sales, In the context of Data Services an unknown internal server error occurred, 500 internal error, A_SlsPrcgCndnRecdValidity, API_SLSPRICINGCONDITIONRECORD_SRV , KBA , BC-DWB-DIC , ABAP Dictionary and ABAP CDS , SD-MD-CM-2CL , Conditions and Condition Maintainance (Public Cloud) , Problem