Purpose
When the material ledger is active, the system automatically collects specific information on valuation-relevant transactions and account postings from inventory management, invoice verification and order settlement, and uses this data during material price determination.
This automatic collection of data from accounts and the subsequent transfer of the data to the material ledger is called the material ledger update. The data is collected in the material ledger in up to three currencies and valuation views.
The differences are posted as follows:
Inventory (transaction key BSX) against price differences (transaction key PRY)
Inventory (transaction key BSX) against exchange rate differences (transaction key KDM)
Inventory (transaction key BSX) against revaluations (transaction key UMB)
Consumption (withdrawal for a production order or a cost center, for example) is always posted at the current valuation price and collected in the material ledger. No differences occur in this case. You can see this consumption under Other inward/outward movements in the material ledger data display.
Prerequisites
Data is collected in the material ledger for all materials for which the material ledger is active, independent of the material's price determination.
Materials with Price Determination Control 3 (single-/multi-level)
The system uses the method of the weighted average price to calculate the periodic unit price in all currencies and/or valuations for the closed posting period. This does not change the valuation price (standard price) of the current posting period.
With single-level price determination, you can influence how the periodic unit price is calculated by determining how the data is collected. You can specify this through a material update structure in Customizing of Actual Costing/Material Ledger.
In Customizing under Controlling ® Product Cost Controlling ® Actual Costing/Material Ledger ® Material Update you carry out the following steps:
In this step, you assign the movement type groups to one of the following categories.
By defining which transactions flow into which categories, you can separate withdrawals that you want to have an effect on the periodic unit price from other withdrawals that should not, for example.
Materials with Price Determination Control 2 (transaction-based)
The system calculates the moving average price in all the appropriate currencies and/or valuations. If the price control is set to V, this price is used for valuation. If the price control is set to S, the moving average price is only updated in the material master for statistical purposes.
Result:
The posting logic of transaction-based price determination corresponds to that of the system without the material ledger.
For more information about the posting logic without the material ledger, see MM - Material Valuation under
Material Valuation in the SAP System.See also:
Single-Level Material Price Determination Multilevel Material Price Determination Transaction-Based Material Price Determination Example: Single-Level Material Price Determination Example: Multilevel Material Price Determination