SAP Knowledge Base Article - Preview

3734373 - Error "Aggregate functions are not allowed in transactional views" when adding aggregation annotations to custom CDS View

Symptom

  • It is not possible to add aggregation annotations in a custom entity CDS (RAP) view to enable charts with visual filters in a Fiori app.
  • When an aggregation annotation (for example @Aggregation.default) is added to an element, the Service Binding activation fails with the error "Aggregate functions are not allowed in transactional views".


Read more...

Environment

SAP S/4HANA release independent

Product

SAP S/4HANA all versions

Keywords

rap, cds, custom entity, aggregation annotation, @aggregation.default, aggregate functions are not allowed in transactional views, transactional view, analytical view, charts, visual filters, service binding error, odata v2, sadl, i-layer, c-layer , KBA , BC-ESI-ESF-BSA , Business Service Adaptation , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.