topic Re: SUM ON FIELDS in Application Development and Automation Discussions

SUM ON FIELDS

Former Member — Wed, 20 Jun 2007 16:22:26 GMT

I have 4 charecter fields C1,C2,C3,C4 and 2 Numeric Fields N1 and N2. I need to sum N1 and N2 Numeric fields for unique C1 and C2 charecter fields. How can i do that? Kindly help me

Re: SUM ON FIELDS

Former Member — Wed, 20 Jun 2007 16:50:24 GMT

try this

sort itab by c1 c2.

loop at itab.
 at end of C2.
  SUM.
 endat.
endloop.

Re: SUM ON FIELDS

ferry_lianto — Wed, 20 Jun 2007 17:03:07 GMT

Hi,

Please try this something like this.


data: begin of itab2 occurs 0,
           c1c2(10),
           n1(10) type n,
           n2(10) type n.           
data: end of itab2.

sort itab by c1 c2 ascending.

loop at itab.
   itab2-c1c2(5) = itab-c1.
   itab2-c1c2+5(5) = itab-c2.
   itab2-n1 = itab-n1.
   itab2-n2 = itab-n2.
   collect itab2. 
endloop.

loop at itab2.
  write: / itab2-c1c2(5), itab2-c1c2+5(5), itab2-n1, itab2-n2. 
endloop.

Now your internal table ITAB2 has sum of field N1 and N2 of unique C1 and C2.

Regards,

Ferry Lianto

Re: SUM ON FIELDS

Former Member — Wed, 20 Jun 2007 17:03:48 GMT

it is not working....

Re: SUM ON FIELDS

Former Member — Wed, 20 Jun 2007 17:59:30 GMT

Sorry it works... I need to put the fields in sequnce C1, C2 in the structure. If i change the sequence like C1, C3, C2 in structure AT END OF C2 dosent works in the loop. Thanks for your help