SAP Knowledge Base Article - Public

3658058 - Fields missing in Custom CDS view built on DatasourceI_WBSELEMENTDATA

Symptom

  • Some fields are blank in the custom CDS view which is built on the datasource I_WBSELEMENTDATA.
  • Fields such as "Last Changed On", "Basic Start", and "Basic Finish" are missing for certain WBS elements.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Create a custom CDS view using the datasource I_WBSELEMENTDATA.
  2. Query the CDS view for WBS elements.
  3. Observe that fields such as "Last Changed On", "Basic Start", and "Basic Finish" are blank for certain WBS elements.

Cause

  • I_WBSELEMENTDATA is only released for use in certain analytical apps. It does not contain complete data for all WBS elements.

Resolution

  1. Replace the usage of I_WBSELEMENTDATA with I_EnterpriseProjectElement as the datasource for the CDS view.
  2. Only use I_WBSElementBasicData for WBS elements in cases where foreign key associations are needed on old internal IDs such as WBSElementInternalID.
  3. Verify the data in the new CDS view to ensure all required fields are populated correctly.

Keywords

cds view, i_wbselementdata, missing fields, last changed on, basic start, basic finish, wbs elements, i_enterpriseprojectelement, i_projectbasicdata, i_wbselementbasicdata, datasource, analytical apps, sap s/4hana cloud. , KBA , PPM-SCL-STR , Project Structure (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions