topic Re: Sum up in Application Development and Automation Discussions

Sum up

Former Member — Mon, 08 Oct 2007 12:51:54 GMT

I have an internal table, which will store so no, material, quantity and the Debit/Credit Indicator, i would like to sum up the quantity which group by so no and material, how can i do that, because the Debit/Credit Indicator is H or S. Thanks!

Re: Sum up

Former Member — Mon, 08 Oct 2007 12:56:07 GMT

Hi try this.

loop at it_tab into st_tab.

st_tab1 = st_tab.

if st_tab-indicator = 'H'.

st_tab-qua = st_tab-qua * (-1)

endif .

w_qua = w_qua + st_tab-qua.

at end of material.

move all the fields into new structure with required fields

and move w_qua into quantity field .

append that into internal table.

endloop.

Thanks,

Sarala.

Re: Sum up

Former Member — Mon, 08 Oct 2007 12:56:42 GMT

Hi,

You can use the ON CHANGE OF for this one ..

LOOP AT ITAB.
ON CHANGE OF SO_NO  MATNR
 " Write the code here
ENDON

Regards

Sudheer

Re: Sum up

Former Member — Mon, 08 Oct 2007 12:58:02 GMT

hi,

data: sum_h type menge,

sum_s type menge.

loop at itab into wa.

if wa-shkzg = H.

sum_h = wa_menge + sum_h.

else.

sum_s = wa_menge + sum_s.

endif.

sum_h = sum_h - sum_s.

clear sum_s.

endloop.

try this or loop it two times so that you can minus the sum of credit from debit.

Re: Sum up

Former Member — Mon, 08 Oct 2007 12:58:07 GMT

see the rough logic.

sort itab by sno matnr.

loop at itab.

if itab-shkzg = 'H'.

itab-menge = itab-menge .

else.

itab-menge = itab-menge * -1.

endif.

at end of matnr.

read table itab index sy-tabix.

sum.

move the fields to other itab1.

append itab1.

endat.

clear itab1.

endloop.

Regards

anji

Re: Sum up

JozsefSzikszai — Mon, 08 Oct 2007 12:58:10 GMT

hi Portfolio,

I think the only thing you can do it that you LOOP AT the internal table and COLLECT each line to another internal table (in fact only so no, material and quantity) and multipliing the credit items with minus1 (before the COLLECT.

hope this helps