SAP Knowledge Base Article - Public

2711320 - Custom CDS View Fails to Publish

Symptom

  • Publishing a CDS view in the Custom CDS Views app fails
  • SQL view YY1_<ID of View> cannot be renamed as Y<Unique ID>; DDL source YY1_<ID of CDS View> is already shipped.
    Example: SQL view YY1_CustomView cannot be renamed as Y123456789; DDL source YY1_CustomCDS is already shipped.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Create and publish a custom analytical query
  2. Export the query to production
  3. Now delete the query in the test system
  4. Finally, create a new custom CDS view with the same ID that the query had
  5. Attempt to publish the new CDS view and you will see the error

Cause

The CDS view cannot have the same name as the query, since the deletion of the query has not been transported to production yet

Resolution

Transport the deletion of the query to production, and you will now be able to publish the new CDS view without an error

Keywords

Custom Analytical Queries Export Software Collection Delete Production Test , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud 1808