Symptom
When a custom CDS view is created consuming I_BillingDocumentItemCube and has fields exposed from "_WBSElement" or has the association "_WBSElement" directly, it is not possible to publish or preview the custom CDS view. Besides, the corresponding custom analytical query or report is not able to be used. For example, the below errors will occur:
• Error "Unable to load the data" occurs when previewing data for the custom CDS view.
• Error "The requested custom CDS view was not found" occurs when navigating to the custom CDS view.
Environment
SAP S/4HANA Cloud
Cause
The association "_WBSElement" has already been deprecated and should not be used. The successor is "_WBSElementBasicData".
Resolution
The below steps show how to replace the deprecated CDS view elements "_WBSElement" (fields or the association) by its successor "_WBSElementBasicData".
- Go to the "Custom CDS Views" app.
- Navigate to the custom CDS view and click the "Edit" button.
- Go to the "Element" tab and find all the elements using the CDS view element path from "_WBSElement". Backup all the configurations of the elements in the tab "Element Properties" and "Filters" if any.
- Select the element and click the "Delete" button in order to remove it.
- Click the "Add" button and add all the deleted elements from the successor "_WBSElementBasicData" (Make sure that the exposed element name is the same as before).
- Configure the previously used "Element Properties" and "Filters".
- Click the "Publish" button to publish the custom CDS view.
In case the element is not allowed to remove, it must be consumed by other CDS views or queries (Refer to "How to find all the consumers of the custom CDS view" at the end of this article). Remove the elements from the consumer firstly.
• If the element is consumed by other custom CDS views, follow the above steps 1~4 to remove the elements from the consumer firstly and then publish them.
• If the element is consumed by custom analytical queries, follow the below steps:
- Go to the "Custom Analytical Queries" app.
- Navigate to the query.
- Go to the "Field Selection" tab.
- Backup special configurations for the elements to be removed if any.
- Click the "Remove" button in the "Remove" column to remove the element.
- Save and publish the query.
After the custom CDS view is modified, re-add the fields to all the consumers. For any further concerns, raise a customer case to SAP.
How to find all the consumers of the custom CDS view?
- Go to the "Custom CDS Views" app.
- Navigate to the custom CDS view and click the "Inventory" button on the bottom.
- In the new page, go to the "Dependencies" section. All the consumers (Custom CDS view, Analytical Queries) can be found there.
Keywords
Custom CDS view, I_BillingDocumentItemCube, Field, Association, Deprecated, _WBSElement, _WBSElementBasicData, Delete, Element, Custom analytical queries , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem