Skip to Content
0
Apr 23, 2014 at 07:43 AM

how to use aggregate function on internal table

2442 Views

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?