topic Aggregation functions in Application Development and Automation Discussions

Aggregation functions

Former Member — Fri, 01 Dec 2006 09:41:31 GMT

How to most efficient can I symulate Aggregation functions in ABAP?

I know that I can use max min, avg on single field in table, but I need to calculate in program, this values but not on a single field but on expression e.g:

max(kolumn1 - kolumn2 + kolumn3 / kolumn 4) and so one...

Or I miss something in documentation?

Re: Aggregation functions

Former Member — Fri, 01 Dec 2006 09:46:42 GMT

hi,

exceute the program RSHOWTIM to see more details.

regards

Sandeep.

Re: Aggregation functions

Former Member — Fri, 01 Dec 2006 09:53:05 GMT

chk these programs

DEMO_DATA_CALCULATE

and checkout for DEMO* programs in SE38

Re: Aggregation functions

Former Member — Fri, 01 Dec 2006 09:54:52 GMT

I forgot to add that I also need use functionality group by

Re: Aggregation functions

Former Member — Fri, 01 Dec 2006 11:55:00 GMT

max(kolumn1 - kolumn2 + kolumn3 / kolumn 4)

It is not possible to achieve the above result via just a SELECT statement you would need to capture the data into internal table and get the result.

SELECT key sum(kolumn1) sum(kolumn2) sum(kolumn3) sum(kolumn4)

into table itab

from ztable

where key in so_key

group by key.

Loop at itab.

lval = itab-kolumn3 / itab-kolumn 4.

lval = kolumn1 - kolumn2 + lval.

if lmax <= lval.

lkey = itab-key.

lmax = lval.

endif.

endloop.

Re: Aggregation functions

andreas_mann3 — Fri, 01 Dec 2006 12:05:57 GMT

Hi,

look here: