InfoProvider: Stock Exceptions - Understocks 
InfoCube: 0FRE_C01 / 0FRE_C21
This InfoCube contains detailed information about individual understock occurrences, including several key figures that describe the stock situation for a given product/location.
The information in this InfoCube is used to create queries that allow you to analyze situations in which the stock levels fall below a minimum predefined stock level, or below a percentage of a minimum stock level that you define (that percentage is maintained in Customizing for F&R Analytics).
The analysis of understocks is an important measurement that you can use to improve the automatic replenishment process. Understocks can be used as indicators of a need to change replenishment parameters to avoid stockouts and fine-tune supply-chain processes.
Note
There are two different InfoProviders:
0FRE_C01 retrieves the F&R relevant master data from InfoObject 0MAT_PLANT.
0FRE_C21 (new as of release 7.0.3) is similar to 0FRE_C01, but uses DSO (DataStore Object) 0RT_DS01 instead of 0MAT_PLANT to retrieve the following F&R relevant master data:
Moving Average Cost (MAC) to calculate the Understock Cost
ABC Indicator characteristic
Replenishment Planner characteristic
The LOCATION/PRODUCT dimension, contained in 0MAT_PLANT, does not exist in 0FRE_C21.
Data Modeling
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | ABC Indicator | 0ABCKEY |
InfoObject | Base Unit of Measure | 0BASE_UOM |
InfoObject | Calendar Day | 0CALDAY |
InfoObject | Calendar Year/Month | 0CALMONTH |
InfoObject | Calendar Year/Week | 0CALWEEK |
InfoObject | Calendar Year | 0CALYEAR |
InfoObject | Change Run ID | 0CHNGID |
InfoObject | Fiscal year / period | 0FISCPER |
InfoObject | Fiscal year variant | 0FISCVARNT |
InfoObject | Fiscal year | 0FISCYEAR |
InfoObject | Daily Active Forecast in BUoM | 0FRE_AFCST |
InfoObject | Active Forecast Type | 0FRE_AFCTY |
InfoObject | Compared Minimum Stock | 0FRE_CMINST |
InfoObject | Counter for Understock | 0FRE_CNTUS |
InfoObject | Daily Consumption | 0FRE_CONSMP |
InfoObject | Daily DIF Effects in BUoM | 0FRE_DDIFEF |
InfoObject | Daily Forecasted Consumption in BUoM | 0FRE_FCST |
InfoObject | Replenishment Planner | 0FRE_PLNPUR |
InfoObject | Range of Coverage in Days | 0FRE_RCOVDY |
InfoObject | Replenishment Type | 0FRE_REPLST |
InfoObject | Product Substitution Relationship | 0FRE_REPLTY |
InfoObject | Range of Coverage Too High | 0FRE_ROCINV |
InfoObject | Replenishment Lead Time (in Days) | 0FRE_RPLTIM |
InfoObject | Selling Class | 0FRE_SELCLS |
InfoObject | Stock Quantity | 0FRE_STOCK |
InfoObject | Understock Cost | 0FRE_USTCST |
InfoObject | Local currency | 0LOC_CURRCY |
InfoObject | Material | 0MATERIAL |
InfoObject | Plant Material | 0MAT_PLANT |
InfoObject | Plant | 0PLANT |
InfoObject | Record type | 0RECORDTP |
InfoObject | Request ID | 0REQUID |
InfoObject | Supplying Plant | 0SUPP_PLANT |
InfoObject | Vendor | 0VENDOR |