Material Master Price Change MR21 

How to track the price changes in material master record if it changes through MR21 ?

Use the Following Trxn Codes for Material Price Change Documents

- CKMPCD

- CKMPCSEARCH

Table :

- MLHD - Material Ledger Document: Header

- MLIT - Material Ledger Document: Items
 

How to calculate MAP?

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.

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 (price*qty) value + MIGO (price*qty) total value)/total qty

In our example:

(50*2+51*4)/6 = 50.65

Price will be updated to 50.65.

MMR price - 50.65 qty - 6 

MIRO price - 52 qty - 4

Do the same calculation to get updated MAP.

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.