Entering content frameProcess documentation Collecting Actual Data for the Material Ledger Locate the document in its SAP Library structure

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.

This graphic is explained in the accompanying text

 

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)

  1. Valuation-relevant transactions are posted in the system.
  2. The system collects the data in the material ledger.
  3. You perform material price determination once every posting period.

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)

  1. A valuation-relevant transaction is posted in the system.
  2. The system collects the data in the material ledger.
  3. The system automatically performs price determination for the material after that posting.

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 Structure link 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

Leaving content frame