topic Re: Aggregate functions for internal table. in Application Development and Automation Discussions

Aggregate functions for internal table.

Former Member — Tue, 10 Aug 2010 19:14:24 GMT

Hi Gurus,

I'm just wondering whether we can use aggregate functions for internal table. I wanted to know the max value for a particular column in my internal table. How can I achieve this easily and quickly.

Thanks,

David.

Re: Aggregate functions for internal table.

kesavadas_thekkillath — Tue, 10 Aug 2010 19:49:40 GMT

if you need it from a itab then sort the itab descending based on the required field, then read the index 1 of itab.

Re: Aggregate functions for internal table.

Former Member — Wed, 11 Aug 2010 01:37:56 GMT

Hello,

Please explain more.

Re: Aggregate functions for internal table.

Former Member — Wed, 11 Aug 2010 05:07:59 GMT

sort the table on which you want the maximum value and read it. Please find below example code.

TYPES : BEGIN OF ty_mvke,

matnr TYPE mvke-matnr,

vkorg TYPE mvke-vkorg,

vtweg TYPE mvke-vtweg,

AUMNG type mvke-AUMNG,

END OF ty_mvke.

DATA : wa_mvke TYPE ty_mvke,

it_mvke TYPE STANDARD TABLE OF ty_mvke.

data : temp_AUMNG type AUMNG.

START-OF-SELECTION.

SELECT matnr vkorg vtweg AUMNG FROM mvke INTO

table it_mvke.

sort it_mvke by AUMNG.

read TABLE it_mvke into wa_mvke INDEX 1.

if sy-subrc = 0.

move wa_mvke-AUMNG to temp_AUMNG.

write : temp_AUMNG.

endif.

Thanks,

Sreekala.