topic Re: using sum function in Application Development and Automation Discussions

using sum function

Former Member — Tue, 19 Jun 2007 05:03:21 GMT

hi experts,

i want to sum the total of opening stock for a particular raw material alone.but that raw material is used for manufaturing many finished goods.

what i ahev to do .

eg)

material1

mat1 100

mat2 200

material2

mat1 50

mat3 300

material3

mat1 100

mat2 400

so i want to get the total of each material.

what shall i do.

Re: using sum function

gopi_narendra — Tue, 19 Jun 2007 05:06:20 GMT

Use the collect statement for each Material...See F1 for help

Regards

Gopi

Re: using sum function

Former Member — Tue, 19 Jun 2007 05:08:18 GMT

hi,

Loop at itab.

at end of MATNR.

sum.

write:total.

endat.

endloop.

Reward points if helpful

Regards,

Imran

Re: using sum function

Former Member — Tue, 19 Jun 2007 05:12:38 GMT

here is the sample code ....

sort  itab by  material  mat  .
Loop at itab  .

at end of   material1.
sum .
write  :  itab-material , itab-mat , itab-amount.   " for sub-total .
endat .
endat.
atlast material .
sum.
write  :  itab-material , itab-mat , itab-amount.  "for total
endat .
endloop.

rewardpoints if it is usefull

Girish

Re: using sum function

Former Member — Tue, 19 Jun 2007 06:02:23 GMT

thanx for replies.

i am not getting the total for each material.it is displaying the total for all materials while using at last.

if i give

at last matnr.

it is throwing an error like this

. or with expected after last.

Re: using sum function

Former Member — Tue, 19 Jun 2007 06:15:21 GMT

DATA : WTAB LIKE ITAB.

SORT ITAB BY MATNR.

LOOP AT ITAB.

MOVE-CORRESPONDING ITAB TO WTAB.

AT LAST.

SUM.

WRITE : / WTAB-MATNR, ITAB-QUANTITY.

ENDAT.

REGARDS

SHIBA DUTTA