Inventory Valuation: Material Prices and Inventory Values (SAP Library

Inventory Valuation: Material Prices and Inventory Values

Technical Name: 0COPC_C04

Use

With this InfoCube, you can per period and for each

Material
Sales order stock
Project stock

analyze the standard price or moving average price/periodic unit price, and also the inventory values and quantities.

You have the option of carrying out the evaluations of the inventory values and quantities per drilldown according to characteristics such as plant or material attributes such as material group or profit center.

Providing the material ledger is active, the data in all of the valuation approaches is available. You should make sure that you restrict the various valuation approaches (valuation view and currency type) for the query definition.

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

Higher-Level Objects

Roles

This InfoCube provides information on the following role:

Inventory Valuation

Queries

The following queries are available for this InfoCube:

0COPC_C04_Q0001: Inventory Valuation: Time Series – Inventory Values in the Current Year

0COPC_C04_Q0002: Inventory Valuation: Time Series - Valuation Prices in the Current Year

0COPC_C04_Q0003: Inventory Valuation: Top 10 – Inventory Values

0COPC_C04_Q0004: Inventory Valuation: Top 10 – Price Change last Period

0COPC_C04_Q0005: Inventory Valuation: Inventory per Valuation Class in the Current Year

Note on Query Definition

To select materials of a particular group in the queries and workbooks, 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).

InfoSources

0CO_PC_ACT_02 periodic ending inventories

0CO_PC_ACT_03 periodic ending inventories (sales order stocks)

0CO_PC_ACT_04 periodic ending inventories (project stocks)

0CO_PC_ACT_05 material prices

0CO_PC_ACT_06 material prices (sales order stocks)

0CO_PC_ACT_07 material prices (project stocks)

Loading Behavior

Recommendation

SAP recommends that you load the data following period-end closing for the closed period.

Selection when Loading

You can select using the following characteristics:

Company code
Plant
Material
Price category (only in the case of InfoSources for material prices)
Fiscal year/period

Setting the data source in OLTP enables you to select using the following additional characteristics:

Currency type
Valuation view
Price determination
Valuation class

Characteristics

InfoObject	Description
0COMP_CODE	Company code
0PLANT	Plant
0MATERIAL	Material number
0MAT_PLANT	Plant material
0VAL_TYPE	Valuation type
0VAL_CLASS	Valuation class
0PRICE_CTRL	Price control indicator
0STLMT_CTRL	Price determination control
0DOC_NUMBER	Sales Document
0S_ORD_ITEM	Sales Document Item
0WBS_ELEMT	Work breakdown structure element (WBS element)
0CURTYPE	Currency type
0VALUATION	Valuation view

Time Characteristics

InfoObject	Description
0FISCPER	Fiscal year/period
0FISCYEAR	Fiscal year
0FISCPER3	Posting period
0FISCVARNT	Fiscal year variant

Key Figures

InfoObject	Description
0STOCK_QTY	Inventory quantity
0STOCK_VAL	Inventory value
0PRICE_BASE	Base quantity for price
0PRICE_VAL	Valuation price
0PRICE_STD	Standard price
0PRICE_AVG	Moving average price/periodic unit price

Units

InfoObject	Description
0UNIT	Unit of measure
0CURRENCY	Currency

Structures

InfoObject	Description
0COPC_C04_S001	Quarters
0COPC_C04_S002	Periods

Activated Navigation Attributes

A number of navigation attributes were activated as an example. You are free to activate additional attributes, or deactivate attributes to improve performance.

InfoObject	Description
0MATERIAL__0DIVISION	Division
0MATERIAL__0MATL_GROUP	Material group
0MATERIAL__0MATL_TYPE	Material type
0MATERIAL__0PROD_HIER	Product hierarchy
0MAT_PLANT__0CO_AREA	Controlling area
0MAT_PLANT__0PROFIT_CTR	Profit center