This InfoCube contains the split 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, both fixed and variable. 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).

The cost component split information for the key figures is mapped in the characteristics cost element and indicator level/lower level . If you drill down in the queries and work books by cost component, then you can see the individual cost components, for example for the valuation during the period. Other characteristics for the cost component split include the type of cost component split (main or auxilliary cost component split) and the cost component structure.

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

• The material ledger is active.
• The actual costing is active
• The actual cost component split is active (possible as of release 4.6C).

Inventory Valuation

0COPC_C07_Q0001: Production: Time Series – Actual Cost Component Split in Current Year

0COPC_C07_Q0002: Ending Inventory: Time Series – Split Actual Prices

0COPC_C07_Q0003: Receipts: Time Series – Split Actual Prices

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 the following characteristics, as this only leads to unusable results. Restrict the following characteristics:

• Valuation view and currency type (differing currencies and valuation approaches)
• Category (exception: you can total beginning inventory and receipts).
• Type of cost component split

0CO_PC_ACT_10: Actual Costing/Material Ledger

Characteristic 0CCOMP_HLP is a purely technical characteristic. It is linked to the characteristics cost component structure, cost component, and level/lower level indicator. This enables exception aggregation for the key figure quantity across all characteristics rather than just one of these characteristics The exception aggregation is required because this key figure occurs in several data records each containing a value which in turn relates to the same quantity. This means when summing across all data records (for example, across all cost components), this key figure would also be summed. Exception aggregation prevents the summation of these key figures.