SAP Knowledge Base Article - Public

2736239 - Calculated field return "0" while previewing data in the Custom CDS View app

Symptom

  • Adding two fields and one of the field comes from the association, for example: C=DatasourceA.FieldA+DatasourceB.FieldB. DatasourceB is the associated data source.
  • If the value of the DatasourceB.FieldB is "0", no matter what DatasourceA.FieldA is, the calculated field value will be "0"

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Create an calculated field and one of the field comes from the association
  2. Preview the CDS view, if one of the field’s value is zero, then the result of calculated field is zero

Cause

The association could deliver an empty result set: e.g. if an object has an association to it's items, it could be that a specific object instance does not have any items and the association would return null. X + null is then null (0 is returned)

Resolution

Use coalesce (expression1, expression2) function, if expression1 is not null, expression1 is returned, otherwise expression2 is returned.

For example: coalesce(DatasourceA.FieldA, 0) + coalesce(DatasourceB.FieldB, 0)

Keywords

Custom CDS View, 0, calculated field , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud 1811