How to calculate MAP

[Former Member]

Hi all,

Please let me know How to calculate MAP ( moving average price ) on daily basis - Please explain what formula we should use and from which table, which field values we should take?

Also let me know how to calculate MAP at the time of vendor invoicing.

Regards.

Ronnie

[Former Member]

Calculation of MAP

IN MMR (Stock)

price - 50

qty - 2

in PO

Price - 51

qty - 4

After GR for 4 qty price updation in MMR will happen

(MMR (priceqty) value + MIGO (priceqty) total value)/total qty

in our example

(502+514)/6 = 50.65

price will be updated to 50.65.

MMR price - 50.65 qty - 6

MIRO price - 52 qty - 4

do the same calcualtion to get updated MAP.

rgds

srini

[Former Member]

Hi,

MAP is automatically calculated based on the Total Stock and Total value of the material at a particular point of time,

The MAP details are available in MBEW table

MAP keeps changing based on either Goods Receipt or Invoice Verification, when there is a change in the price

Regards

Merwyn

[former_member581212]

hi,

The formula is :

Difference/Current stock holding + current moving average...

Difference is between MMR and IR...

i'll provide you one of the link...you can find every thing in it:

http://help.sap.com/erp2005_ehp_03/helpdata/EN/47/60ff4849f011d1894c0000e829fbbd/frameset.htm

Regards

Priyanka.P

AWARD IF HELPFULL

Edited by: Priyanka Paltanwale on Sep 16, 2008 11:31 AM