material based total in month

Former Member — Mon, 30 Aug 2010 09:52:21 GMT

For Particular Material , need sum of sale order qty under month january , feb , march etc

How can i do that ?

Please ask a more specific question, after you have put some effort of your own. Thread locked

Edited by: kishan P on Aug 30, 2010 3:36 PM

Re: material based total in month

Former Member — Mon, 30 Aug 2010 10:04:26 GMT

Hi ,

I dont know how you are seggregating material from sales orders to month grouping . . your question is very vague ..

but on a lighter note you internal table with all the data in it should be sorted based on a date field and preferably a field called month to distinct the data on monthly basis.

ex - 30/08/2010 -> Aug-> 08 which should be the key field .

Use control break statements to achieve the sum on monthly basis.

sort itab by . . month


loop at itab. 
......
.......
gv_qty = itab- qty + gv_qty.
......
at end of month .
itab_montot = gv_qty. 
clear  gv_qty.
...
endloop.

BR,

Vijay.

topic material based total in month in Application Development and Automation Discussions

material based total in month

Re: material based total in month