topic Re: How to use aggregate function using Group By from SAP IDA in Application Development and Automation Discussions

How to use aggregate function using Group By from SAP IDA

Partha — Thu, 07 Mar 2019 09:25:49 GMT

Hi Experts

I have a requirement to display the sum of the quantity group by few fields from a table using SAP IDA. Is it possible using SAP IDA classes. If possible, please let me know how that can be achieved as while creating we take the table entries(using few filter condition).

Thanks

Partha Saha

Re: How to use aggregate function using Group By from SAP IDA

DoanManhQuynh — Thu, 07 Mar 2019 11:41:41 GMT

What the matter did you get? there is a demo you can check too:

SALV_IDA_INITIAL_AGGREGATION

Re: How to use aggregate function using Group By from SAP IDA

Partha — Fri, 08 Mar 2019 11:45:18 GMT

I need to use aggregate function based on other fields present in the table. As per the template suggested by you, the agregations are done on a particular field(Like Sum,Average etc)

The requirement that I have is something like below

select vkorg vtweg spart kunnr matnr sum (menge) as menge into tale lt_tab group by vkorg vtweg spart kunnr matnr.

The result should be sent as ALV output.

Thanks

Partha

Re: How to use aggregate function using Group By from SAP IDA

DoanManhQuynh — Mon, 11 Mar 2019 00:30:25 GMT

I think you missunderstand about ALV IDA. what you want is select data that already summalized and display on ALV, which is not supported within IDA. you can find supported conditions in IF_SALV_IDA_CONDITION_FACTORY. There is option to use method CREATE_FOR_CDS_VIEW where you put the query in cds view, otherwise select data and using other ALV technical.