SAP Knowledge Base Article - Public

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


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


 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


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


  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


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


SAP S/4HANA Cloud all versions