topic Re: SUM in internal table in Application Development and Automation Discussions

SUM in internal table

Former Member — Thu, 25 Oct 2007 13:23:03 GMT

How to get sum for a particular field in internal table?

I hv used sorted table.

I want group the field for which I want to take sum <b>depending</b> on currency field.

I am not able to use AT- NEW - END - END AT

Re: SUM in internal table

naimesh_patel — Thu, 25 Oct 2007 13:34:58 GMT

Hello,

Take one more internal table with your required field as a group criteria and amount.

Like:


data: begin of itab occurs 0,
fld1 type fld1,
wears type waers,
amount type dmbtr,
end of itab.

loop at <sorted_tab>.
move-corresponding <sorted_Tab> to itab.
collect itab.
clear  itab.
endloop.

After this ITAB will have the data with SUM on the amount field.

Regards,

Naimesh Patel

Re: SUM in internal table

former_member187255 — Thu, 25 Oct 2007 13:38:56 GMT

Suhas,

If you want to use AT- NEW - END - END AT based on Currency Field then the Currency Field should be the <b>First</b> field in the Internal table.....

Chandra.

Re: SUM in internal table

Former Member — Thu, 25 Oct 2007 13:48:43 GMT

hi,

do the following:

declare one more itab to collect the sum, say itab2 and one temporary variable v1 type waers to store currency key.

loop at itab1 into wa1.

if sy-tabix = 1.

v1 = wa1-waers.

move wa1 to wa2.

endif.

else.

if v1 = wa1-waers.

wa2-amount = wa2-amount + wa1-amount.

else.

append wa2 to itab2.

v1 = wa1-waers.

clear wa2.

endif.

endloop.

Re: SUM in internal table

Former Member — Wed, 07 Nov 2007 14:59:18 GMT