Question Re: Collect statement functionality using CDS or HANA AMDPs in Technology Q&A

Collect statement functionality using CDS or HANA AMDPs

ShivaKona — Tue, 16 Oct 2018 08:19:25 GMT

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

Re: Collect statement functionality using CDS or HANA AMDPs

pfefferf — Tue, 16 Oct 2018 09:21:20 GMT

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.

Re: Collect statement functionality using CDS or HANA AMDPs

matt — Tue, 16 Oct 2018 10:02:18 GMT

You can't use function modules in AMDPs.

Re: Collect statement functionality using CDS or HANA AMDPs

ShivaKona — Tue, 16 Oct 2018 11:31:30 GMT

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

Re: Collect statement functionality using CDS or HANA AMDPs

ShivaKona — Tue, 16 Oct 2018 11:38:18 GMT

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