# SAP Material Valuation and Price Unit Worksheet > Source: https://netray.co/tools/sap-material-valuation-price-unit-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A fill-in worksheet that recomputes inventory value per material from quantity, price and price unit, so you can reconcile with MBEW or migration loads. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP MM consultant - Cost accountant - Controller - Auditor ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Material **Key:** material **Type:** text #### Plant **Key:** plant **Type:** text #### Price control **Key:** price_ctrl **Type:** select **Options:** - S - V **Help:** S = standard price, V = moving average price #### Stock quantity **Key:** qty **Type:** number #### Price **Key:** price **Type:** number **Format:** currency #### Price unit **Key:** price_unit **Type:** number **Help:** Quantity the price refers to, for example 1, 100 or 1000 #### Stock value **Key:** value **Type:** number **Expr:** qty * price / price_unit **Format:** currency #### Value per ledger **Key:** book_value **Type:** number **Format:** currency **Help:** Optional: value from the G/L or MBEW for comparison #### Difference **Key:** diff **Type:** number **Expr:** value - book_value **Format:** currency **Rows:** **Material:** RM-10042 **Plant:** 1000 **Price ctrl:** V **Qty:** 1250 **Price:** 3.42 **Price unit:** 1 **Value:** 0 **Book value:** 4275 **Diff:** 0 **Material:** RM-20311 **Plant:** 1000 **Price ctrl:** V **Qty:** 40000 **Price:** 18.5 **Price unit:** 1000 **Value:** 0 **Book value:** 740 **Diff:** 0 **Material:** SF-30077 **Plant:** 1000 **Price ctrl:** S **Qty:** 320 **Price:** 46.2 **Price unit:** 1 **Value:** 0 **Book value:** 14784 **Diff:** 0 **Material:** FG-40110 **Plant:** 1000 **Price ctrl:** S **Qty:** 85 **Price:** 612 **Price unit:** 1 **Value:** 0 **Book value:** 52020 **Diff:** 0 **Material:** PK-50008 **Plant:** 2000 **Price ctrl:** V **Qty:** 9600 **Price:** 7.8 **Price unit:** 100 **Value:** 0 **Book value:** 749 **Diff:** 0 **Totals:** #### Total stock value **Key:** value **Agg:** sum **Format:** currency #### Total per ledger **Key:** book_value **Agg:** sum **Format:** currency #### Total difference **Key:** diff **Agg:** sum **Format:** currency **Summary:** #### Average value per line **Key:** avg_value **Expr:** sum_value / count **Format:** currency #### Difference as share of ledger **Key:** diff_pct **Expr:** sum_diff / sum_book_value * 100 **Format:** percent **Notes:** Stock value is quantity times price divided by price unit, which is how SAP treats MBEW-PEINH. Materials with a price unit of 100 or 1000 are a frequent source of reconciliation errors. Quantity should be in the base unit of measure. ## Content **Intro:** Inventory valuation reconciliation starts with one rule: value equals quantity times price divided by price unit. This worksheet applies it to each material and compares the result with the ledger value, which is the quickest way to find a migration or posting error. **Sections:** #### How to use the worksheet **Body:** Add a row per material and plant. Enter the price control (S or V), quantity in the base unit, the price and the price unit exactly as they appear in the accounting view or table MBEW. The stock value is calculated automatically. If you have a ledger or balance value from the G/L, enter it in the comparison column and the difference is computed per row. Totals and the difference share update as you edit, and the whole table exports to Excel. **Bullets:** - Start with the highest value materials - Use base unit quantities only - Paste figures from MBEW or an ALV export #### Price unit explained **Body:** The price unit (PEINH) says how many units the price refers to. A price of 18.50 per 1,000 pieces means each piece costs 0.0185. If someone enters the price unit as 1 by mistake, the value is overstated by a factor of 1,000. This is one of the most frequent causes of absurd inventory values after a data load, along with wrong units of measure and decimal separators. The worksheet makes the effect visible immediately in the difference column. #### Standard price vs moving average **Body:** Under price control S, price is fixed until a price change or a material ledger update, so stock value changes only with quantity. Under price control V, price is recalculated on receipts, so stock value can move without a quantity change when invoices post at different prices. For reconciliation, S materials should tie closely to quantity times standard, while V materials can show differences due to invoice variances and exchange rate effects. #### Common mistakes **Body:** Mixing plants that are valuated at company code level with those at plant level, ignoring special stocks that have their own value lines, and comparing a quantity from MARD with a value from MBEW at a different date all produce false differences. Keep the comparison date consistent across both sides. **Bullets:** - Same posting date on both sides - Check valuation level in OX14 - Include special stock separately **Cta:** Netray can reconcile quantities and values across your full material master against the ledger and highlight the lines that explain the gap. **Faq:** #### What is the price unit in SAP? **Answer:** It is the quantity to which the price in the valuation view refers, stored in field PEINH of table MBEW. Common values are 1, 10, 100 and 1000. Value equals quantity times price divided by price unit. #### Which table holds stock value per material? **Answer:** Table MBEW holds valuation data, including standard price STPRS, moving average price VERPR, total value SALK3 and total quantity LBKUM. In S/4HANA, MBEW remains the valuation table with material ledger tables added. #### Why does the worksheet differ from my ledger? **Answer:** Common causes are price unit errors, valuation at a different date, special stocks, material ledger actual costing, or open GR/IR items. Sort by absolute difference and check the biggest lines first. #### Can I use this for migration validation? **Answer:** Yes. Compare the value computed from migrated quantity and price with the legacy ledger total, and investigate lines where the price unit or unit of measure differs between source and target. ## Search terms sap material valuation worksheet, sap price unit peinh, sap stock value calculation excel, sap mbew reconciliation, sap inventory valuation template, sap standard price vs moving average sheet, sap data migration valuation check --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json