How to use aggregate function using Group By from SAP IDA

[Partha]

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

[DoanManhQuynh]

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

SALV_IDA_INITIAL_AGGREGATION

[Partha]

Hi

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

[DoanManhQuynh]

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.