Collect statement functionality using CDS or HANA AMDPs

[ShivaKona]

Hi Experts,

Can anyone suggest on how to achieve functionality of collect statement using ABAP CDS views or CDS Table functions or HANA AMDPs, or any relevent standard functions available for the same

Regards,

Shiva

[matt]

You can't use function modules in AMDPs.

[ShivaKona]

Sorry...I mean Aggregate functions(Native HANA functions or CDS functions) not function modules

[pfefferf · Accepted solution]

What do you mean with "COLLECT" statement, the ABAP COLLECT statement?

If yes, why not just using a "group by" and the required aggregate function.

[ShivaKona]

Hi Pfeffer,

Yes i mean ABAP Collect statement,and i want it as aggregation on all numeric columns by considering character fields as key

Regards,

Shiva