topic how to use aggregate function on internal table in Application Development and Automation Discussions

how to use aggregate function on internal table

former_member795937 — Wed, 23 Apr 2014 07:43:52 GMT

hi experts,

I am beginner in abap.I want to use sum function on internal table.

I have structure as follow:

types: begin of ty_ftab,

       docno TYPE bkpf-belnr,

       comcode TYPE bkpf-bukrs,

       year TYPE bkpf-gjahr,

       line_itm type bsad-buzei,

       cust type bsad-kunnr,

       amt type bsad-dmbtr,

end of ty_ftab.

data: it_ftab type table of ty_ftab,

wa_ftab type ty_ftab.

i fetched data successfully into it_ftab from bkpf and bsad table and displyed into alv.

now i want sum of amt using group by cust and want to display like

cust total_amt

in next screen...

displying part is not important but how can i do sum of amt according to cust value? Is there in way to query on internal table?

Re: how to use aggregate function on internal table

Former Member — Wed, 23 Apr 2014 07:48:42 GMT

Hi Tushar,

Defind one more internal table and work area of two fields customer and amount.

loop on your existing table assign to final tables work area and use COLLECT statment.

Loop at X[Existing] into wa.

wa_final-kunnr = wa-KUNNR.

wa_final-amount = wa-amt.

collect wa_final to it_final.

Endloop.

Display this it_final into next screen.

Thanks,

Dharmishta

Re: how to use aggregate function on internal table

Former Member — Wed, 23 Apr 2014 08:01:09 GMT

Hi,

try this code,

data : i_sort TYPE TABLE OF slis_sortinfo_alv

w_sort like LINE OF i_sort.

sort it_ftab by cust.

w_sort-subtot = 'X'.

w_sort-fieldname = 'AMT'.

w_sort-tabname = 'it_ftab'.

APPEND w_sort to i_sort.

In fieldcatalog :

w_fcat-fieldname = 'AMT'.

w_fcat-tabname = 'it_ftab'.

w_fcat-do_sum = 'X'.

In REUSE_ALV_GRID_DISPLAY FUNCTION MODULE provide the it_sort.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

* EXPORTING

* I_INTERFACE_CHECK = ' '

* I_BYPASSING_BUFFER = ' '

* I_BUFFER_ACTIVE = ' '

* I_CALLBACK_PROGRAM = ' '

* I_CALLBACK_PF_STATUS_SET = ' '

* I_CALLBACK_USER_COMMAND = ' '

* I_CALLBACK_TOP_OF_PAGE = ' '

* I_CALLBACK_HTML_TOP_OF_PAGE = ' '

* I_CALLBACK_HTML_END_OF_LIST = ' '

* I_STRUCTURE_NAME =

* I_BACKGROUND_ID = ' '

* I_GRID_TITLE =

* I_GRID_SETTINGS =

* IS_LAYOUT =

* IT_FIELDCAT =

* IT_EXCLUDING =

* IT_SPECIAL_GROUPS =

IT_SORT = i_sort

* IT_FILTER =

* IS_SEL_HIDE =

* I_DEFAULT = 'X'

* I_SAVE = ' '

* IS_VARIANT =

* IT_EVENTS =

* IT_EVENT_EXIT =

* IS_PRINT =

* IS_REPREP_ID =

* I_SCREEN_START_COLUMN = 0

* I_SCREEN_START_LINE = 0

* I_SCREEN_END_COLUMN = 0

* I_SCREEN_END_LINE = 0

* I_HTML_HEIGHT_TOP = 0

* I_HTML_HEIGHT_END = 0

* IT_ALV_GRAPHICS =

* IT_HYPERLINK =

* IT_ADD_FIELDCAT =

* IT_EXCEPT_QINFO =

* IR_SALV_FULLSCREEN_ADAPTER =

* IMPORTING

* E_EXIT_CAUSED_BY_CALLER =

* ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab =

* EXCEPTIONS

* PROGRAM_ERROR = 1

* OTHERS = 2

IF sy-subrc <> 0.

* Implement suitable error handling here

ENDIF.

Re: how to use aggregate function on internal table

narendar_naidu — Wed, 23 Apr 2014 08:02:29 GMT

Either use Control break statements and use SUM or collect statement , depending on your requirement.

control break statemnts.

AT-NEW.AT-END,AT-LAST,AT-FIRST,ONCHANGE etc.

regards,

Re: how to use aggregate function on internal table

Former Member — Wed, 23 Apr 2014 08:05:03 GMT

Hi Tushar,

Do you want to display the sum in the ALV ? if so then follow the below steps:-

wa_sort-spos = '01' .
wa_sort-fieldname = 'CUST' "sort based on the customer as you want sum based on cust.
wa_sort-tabname = 'IT_FTAB'.
wa_sort-up = 'X'.
wa_sort-subtot = 'X'.
APPEND wa_sort TO i_sort .

Then pass the i_sort to the importing parameter of the alv.

Alternatively you can use control level processing and can use the event AT END. In this you need to do the manual sum inside that event.

Let me know if you need some more inputs.

Re: how to use aggregate function on internal table

former_member795937 — Thu, 24 Apr 2014 08:08:55 GMT

hi Dharmishta,

Thanx for the valuable reply.

Your idea is working fine.

Thanks,

Tushar