Symptom
Not all fields from a custom CDS view will appear in the Custom Analytical Queries app
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Create a custom CDS view in the Custom CDS Views app
- Now in the Custom Analytical Queries app create a new query based on the new CDS view that was just created
- 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
- Edit the CDS view to add an aggregation value (sum, max, min, etc.) for the field that was not appearing
- 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 Public Edition all versions ; SAP S/4HANA Cloud all versions