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
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
SAP Knowledge Base Article - Public