This InfoCube contains the transaction data of the material ledger in the currencies of all valuation approaches for all valuated materials. The value and quantity information for each material for the categories beginning inventory, receipts, cumulative inventory, usage and ending inventory are available for each period. The value information is composed of the valuation during the period (preliminary valuation), and the price and exchange rate differences. The total of these key figures is the valuation according to actual costs and is consequently the basis for calculating the actual prices (per quantity unit).

The categories receipts and consumption can be broken down according to process categories , enabling you to compare production and purchase order or to examine them individually, for example.

The various currencies (valuation approaches) are represented as corresponding features of the characteristics valuation view (for example company code currency) and currency type (for example legal valuation view).

For background information on the concept of InfoCubes, see InfoCubes in Controlling.

Inventory Valuation

0COPC_C02_Q0002: Production: Time Series – Cumulative Actual Costs in Current Year

0COPC_C02_Q0004: Receipts: Time Series – Actual Prices for the Cumulative Inventory

0COPC_C02_Q0005: Ending Inventory: Time Series – Actual Prices

0COPC_C02_Q0006: Ending Inventory: Greatest Range of Coverage of Materials (Previous Period)

0COPC_C02_Q0007: Receipts: Analysis – Actual Prices of Various Procurement Types

0COPC_C02_Q0010: Receipts: Analysis – Actual Prices in all Currencies

0COPC_C02_Q0011: Receipts: Analysis – Actual Prices for Material in all Currencies

0COPC_C02_Q0012: Purchasing: Time Series – Cumulative Actual Costs in Current Year

To select materials of a particular group in the queries and work books, such as material group, division, profit center and so on, you can use all of the navigation attributes of the characteristic material. To do this you must activate the navigation attributes to this InfoCube if you have not already done so (see under Activated Navigation Attributes).

You should make sure you do not total using differing currencies (valuation approaches), as this only leads to unusable results. You therefore need to restrict the characteristics valution view and currency type. For the same reason you also have to restrict the characteristic category.

0CO_PC_ACT_1: Actual Costing/Material Ledger - Costs