SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP S/4HANA Cloud 2302.3

Reproducing the Issue

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

Cause

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)

Resolution

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.

Update: the issue is planned to be fixed by the deployment of hotfix collection HFC10 of release 2302 (3rd June and 4th June).

See Also

Keywords

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

Product

SAP S/4HANA Cloud 2302