SAP Knowledge Base Article - Public

3581304 - "Null" value is excluded by the filter set in Custom CDS View - SAP S/4HANA Cloud Public Edition

Symptom

Filters are set in the Custom CDS view, but "Null" or empty values are excluded by the filters accidentally.

Environment

SAP S/4HANA Cloud Public Edition

Resolution

Condition can be explicitly used on the existence of null values in both, the form based as well as the expression based filter. 

In the Form-Based filter, operator "Is Null" and “Is Not Null" can be used.

In the Expression-Based filter, Expression like "I_BusinessUserBasic.BusinessPartner is null" can be used.

See Also

Filters | SAP Help Portal

Keywords

null, empty value, exclude, filter, Custom CDS view , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud Public Edition all versions