SAP Knowledge Base Article - Public

2544478 - Custom CDS View Fields Don't Appear in Custom Analytical Queries

Symptom

Not all fields from a custom CDS view will appear in the Custom Analytical Queries app

Environment

 SAP S/4HANA Cloud

Reproducing the Issue

  1. Create a custom CDS view in the Custom CDS Views app
  2. Now in the Custom Analytical Queries app create a new query based on the new CDS view that was just created
  3. In the Field Selection tab, all of the fields from the view may not be available

Cause

If a field in the custom CDS view was an aggregation field, an aggregation value must be supplied for it to be available in the query

Resolution

  1. Edit the CDS view to add an aggregation value (sum, max, min, etc.) for the field that was not appearing
  2. If you receive errors while editing the view, then creating a new view may be required 

See Also

SAP Note 2540696 - Custom CDS Views – Content Rules

SAP Note 2657021 - Creating Custom CDS Views for Analytical Scenarios

Keywords

Field, Association, missing, not available appearing Query Designer , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud all versions