Moving average price in Material Master

[Former Member]

Hello,

I am trying to find how the moving average price of a material is calculated. I know with every GR and IR the price changes. However wanted to know how much in the past does the moving average price refer to. eg, does the moving average price consider all the transactions for the material from the date the material is created or is it refreshed every year?

Thanks for your answers

Keyur

[Former Member · Accepted solution]

moving average price is equal to total value divided by total quantity at a point of time. It takes IR price.

It will be recalculated for every goods movement. may increase of stock or decrease of stock.

[Former Member · Accepted solution]

Hello Chakrapani,

Thanks for your response. There are two questions :

1) If the price control indicator in the material master is maintained as "S", would the moving average price in the material master be updated in the same way (with every GR and IR)

2) I have got materials with zero units and zero value which still have a MAP. If MAP is total stock/total units, how can they still have MAP in the material master.

Thanks

Keyur

[JL23 · Accepted solution]

1) yes

2) the moving average price does not go to zero if the stock becomes zero.

it is like it was, just there for information. it does not impact the price calculation of next goods receipt as old price muliplied with old quantity of zero has zero as result. so the new MAP is only calculated from the new receipt in case he stock was zero.

.

[Former Member]

We are having issues with the MAP going to zero after GI and Inventory becomes zro or Decimal value. See the example data below from report S_P00_07000139:

SLoc Date Reference Doc. GR/GI Slip Mvt Receip Issue Amount Balance quantity Price/Unit (Bal.)

100 5/4/2010 81244409 4900239194 601 0 19,766.31 -4,380.22 126,472.68 0.22 28,026.35

100 5/4/2010 81244410 4900239195 601 0 14,653.88 -3,247.30 111,818.80 0.22 24,779.05

100 5/4/2010 81244411 4900239196 601 0 32,581.57 -7,220.08 79,237.23 0.22 17,558.97

100 5/4/2010 81244412 4900239197 601 0 23,926.37 -5,302.08 55,310.86 0.22 12,256.89

100 5/4/2010 81244413 4900239198 601 0 1,322.75 -293.12 53,988.11 0.22 11,963.77

100 5/4/2010 81244415 4900239199 601 0 9,252.65 -2,050.39 44,735.47 0.22 9,913.38

100 5/4/2010 81244416 4900239210 601 0 29,082.89 -6,444.77 15,652.58 0.22 3,468.61

100 5/4/2010 81244417 4900239211 601 0 15,652.56 -3,468.61 0.018 0 0

100 5/13/2010 4900263842 131 151,221.34 0 0 151,221.36 0 0

100 5/13/2010 4900263971 131 320,531.31 0 0 471,752.66 0 0

100 5/13/2010 4900263973 131 164,332.01 0 0 636,084.67 0 0

100 5/13/2010 4900263974 131 175,046.30 0 0 811,130.97 0 0

100 5/13/2010 4900263976 131 220,306.44 0 0 1,031,437.41 0 0

Any inputs on why the MAP is going to zero.

Thanks

VK

[former_member197616]

Hi,

please check the link for how the moving avaerage price of the material is calculated.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/47/60ff4849f011d1894c0000e829fbbd/content.htm

Regards,