cancel
Showing results for 
Search instead for 
Did you mean: 

Fiori elements list report: Aggregate functions are not allowed in transactional views?

M-A-R-C
Explorer
0 Kudos
482

Hey fellow devs,

I am trying to show the total values in a grouped list in my fiori app. Basically something like this:

shokodingdong_0-1709675991639.png

I have created a CDS entity, a projection (provider contract transactional_query) and a behavior. However it seems to be impossible to add a total value for a column. As soon as I add the annotation  @DefaultAggregation: #SUM to my CDS projection my service definition (both OData v2 and v4) will break and raise the following error message: Error related to element '...' of entity '...(CDS)': Aggregate functions are not allowed in transactional views.

So I am a little lost on how to add a total value to my list report. Does anyone know if and how this is possible or if there is a simple workaround?

 

inesmartins
Participant
0 Kudos

Hello,

Did you find the solution?

Thanks,
Ines Martins

kyo_choi2
Participant
0 Kudos
Check Support.sap.com for relevant notes such as 2489473 - ABAP CDS: Aggregate functions in View Extends
M-A-R-C
Explorer
0 Kudos
@inesmartins What I ended up doing was creating two CDS views. One with the analytical features, one with the transactional features (and a RAP BO). Then I displayed them side by side using this Fiori Elements feature: https://sapui5.hana.ondemand.com/sdk/#/topic/b6b59e4a4c3548cf83ff9c3b955d3ba3
View Entire Topic
inesmartins
Participant
0 Kudos

Thanks!