MAP Change

[former_member680448]

Hello,

Can any one please let me know, in how many ways the Moving average price of the material can be changed.

thanks & regards

Chaitanya Rayaprolu

[Former Member · Accepted solution]

HELLO,

MOVING AVARAGE IS NOTHING BUT VALUE/QTY

SO WHENEVER THERE IS CHANGE IN VALUE AND QUANTITY THERE WILL BE CHANGE IN MOVING AVARAGE PRICE.

For example business senarios

1) If PO of 10 Nos with 10 rs price , GR by 10rs and during invoice verification is done by 11 rs ,Then there will be change in MAP.

2)If qty 9 with 10rs during Gr and qty 10 with 10rs in IR then there qill be change in MAP.

How SAP calcualte the moving average price

Goods Receipt for Purchase Order

Balance on hand quantity + Goods Receipts quantity

Balance on hand value + Goods Receipts value

New Moving Average Price = Total Value / Total Quantity

Invoice Receipt for Purchase Order

Invoice price more than Purchase Order price

additional value add to Balance on hand value then divided by Balance on hand quantity

Invoice price less than Purchase Order price

difference is deducted from the Balance on hand value (up to 0). The rest of the amount will becomes price variance. This will result in Balance on hand value is zero while there are Balance on hand quantity. If the Balance on hand value is enough to deduct, then the remaining value will be divided by Balance on hand quantity.

When your Goods Issue price is constantly greater than your Goods Receipt price, it will result into zero value moving average price.

Hope this helps you

Regards

Kedar Kulkarni

[Former Member]

Try with table MBEWH.

[former_member680448]

Hello all,

Thanks for your answers. In my requirement, we find there is a dip in the price for the material. In the report "MB51", there are only three movment types - 101 / 351 / 601.

Here 101 is carried out against production order and the price of the material is same as MAP of the material. Immediately next to GR - 101, there is a Goods Issue - 601 against Sales order with the changed price.

How "goods issue" can change the price of the material. Also, is there any report to track the changes of the MAP of the material.

thanks & regards

Chaitanya Rayaprolu

[Former Member]

Hi,

SAP only provides moving average value for current, previous period and previous year. There is no transaction/report that can provide moving average value for a given date.

Try this way -

Option# 1. Change the updating level of the structure (S031) to "daily". In LIS the total value and the total stock are available. Divide value by the stock. It is possible to calculate this dynamically when the analysis is run and to display the result.

Option#2. Create your own structure in LIS. Populate it by copying the Moving Average Price from the material master every time there is a transaction. You will have data on those days when there was a transaction.

Reward points if helps!

Regards

[bhushan_bivalkar]

Hi,

I am also trying to develop report on MAP change monitoring . What you have suggested , structure update( S031) or create new structure , how to do that?

[JL23]

why dont you try a SAP standard report with transaction S_P00_07000139 ?

[Former Member]

Hi Chaitanya,

MAP=Total stock/Total qunatity.If any changes in stock or Qunatity of the material automatically MAP changes.

Reward me if helpfull,

ASHOK

[jagadeesh_madiwalar]

Hi,

Chaitanya

Moving Average price dependes on the stock and the Quantity , and whenever material stock increases and it calculates like : Present price/Stock Quantity= Moving price, and any GR and GI or any change in stock this will affect.

If helpful reward points

Message was edited by:

JBM