Inventory Turnover 

Technical Name: 0IC_C03_Q0017

Use

Specifies how often the average valuated stock is consumed (total issue value / valuated stock with average aggregation).

If you do not select any materials in the variable query, the query runtime is longer.

If the key figure cannot be calculated in the query (for example, if the total issue value in the relevant period = 0), the system enters "No calc possible” in the relevant cell.

This query is available in this definition as of 3.0B SP13, 3.1 Content SP7, and 3.2 Content. For more information, see SAP note 591063.

If you create queries that have the characteristics Storage Location (0STOR_LOC) and Stock Type (0STOCKTYPE) in the drilldown, see SAP note 589024.

This query replaces object 0IC_C01_Q0001 (for more information, see collective note 586163).

Corresponding role: SAP_BW_0ROLE_0003 (MRP Controller MM).

This query is also used in the “Inventory Analysis 50.3” business package. This enables you to execute relevant evaluations in the SAP Enterprise Portal.

Navigation in the SAP Enterprise Portal: Inventory Controlling Overview Overview BW.

Filters

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
‑	‑

Free Characteristics

InfoObject	Description
0CALDAY	Calendar day

Variables Used

Variable	Description
0P_CSDAT	Query key date (single value entry, required entry) Enter any date to select all dates in the last 12 months.
0S_MAT	Material (selection options, optional)

Rows

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
0MATERIAL	Material
0PLANT	Plant
0CALYEAR	Calendar year

Columns

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
Formula	Inventory turnover
0ISSVS_VAL (hidden)	Issue value valuated stock
0IC_C03_CK004 (hidden)	Average stock value