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

[M-A-R-C]

Hey fellow devs,

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

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]

Hello,

Did you find the solution?

Thanks,
Ines Martins

[kyo_choi73]

Check Support.sap.com for relevant notes such as 2489473 - ABAP CDS: Aggregate functions in View Extends

[M-A-R-C]

@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

[inesmartins]

Thanks!

[DimeS]

Hi @M-A-R-C ,

can you please share some screenshots of the solution that you have found ?

I have similar requirement, I need to group the table by three fields and the calculate the sum for each group.

The problem occurs when to add a custom button in order to post accounting documents then the service does not work.