topic Re: Sum up the values in Application Development and Automation Discussions

Sum up the values

Former Member — Tue, 11 Dec 2007 16:25:35 GMT

data : begin of itab,

n(3) type c,

n1 type n,

n2 type n,

k(5) type c,

end of itab.

select n n1 n2 k from into itab from table /zteest.

*internal table has

n n1 k n2

gar 100 uji 2

hae 90 iou 3

gar 90 uji 3

hae 87 iou 4

I want

gar 190 uij 5

hae 177 iou 7

How to use collect statement as n1 is n ..?

I want to sum up n1 and n2 if value of k and n is same

Thanks

Re: Sum up the values

naimesh_patel — Tue, 11 Dec 2007 16:30:57 GMT

Make one more internal table and use the collect.

DATA: BEGIN OF IT_SUM,
N(3) TYPE C,
N1 TYPE I,  " << should be I, P or F to get sum for that field
K(5) TYPE C,
N2 TYPE I,
END OF IT_SUM.

LOOP AT ITAB.
 MOVE-CORESSPONDING ITAB TO IT_SUM.
 COLLECT IT_SUM.
 CLEAR   IT_SUM.
ENDLOOP.

Regards,

Naimesh Patel

Re: Sum up the values

Former Member — Tue, 11 Dec 2007 17:41:09 GMT

Hi,

Declare a work area and another internal table same as itab. And declare n1 and n2 as Integer type and if you have decimals declare it as type p decimals 2.

Use below code :

data : wa_like line of itab,

itab1 like itab occurs 0 with header line.

Here comes to your select table.

Once table is loaded into itab.

Use the below code to sum up.

Loop at itab into wa.
collect wa to newitab.
endloop.

Thanks,

Sriram Ponna.