InfoProvider: Stock Exceptions - Dead
Stock 
InfoCube: 0FRE_C10 / 0FRE_C30
This InfoCube contains detailed information that describes individual occurrences of dead stock (existing stock that is not being moved). It contains various 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 for a product/location is greater than zero and there have been no goods issues or sales for the past several periods. Dead (or obsolete) stock impacts the company’s cash flow and profitability in a negative way.
The analysis of dead stock is an important measurement that helps the replenishment planner in deciding whether to discontinue, mark down, or move a certain product.
Note
There are two different InfoProviders:
0FRE_C10 retrieves the F&R relevant master data from InfoObject 0MAT_PLANT.
0FRE_C30 (new as of release 7.0.3) is similar to 0FRE_C10, but uses DSO (DataStore Object) 0RT_DS01 instead of 0MAT_PLANT to retrieve the following F&R relevant master data:
Stock Cost at Moving Average Cost
ABC Indicator characteristic
Replenishment Planner characteristic
The LOCATION/PRODUCT dimension, contained in 0MAT_PLANT, does not exist in 0FRE_C30.
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 | General Counter | 0FRE_CNT |
InfoObject | Replenishment Planner | 0FRE_PLNPUR |
InfoObject | Replenishment Type | 0FRE_REPLST |
InfoObject | Selling Class | 0FRE_SELCLS |
InfoObject | Stock Cost (at moving average) | 0FRE_STKCST |
InfoObject | Stock Quantity | 0FRE_STOCK |
InfoObject | Local currency | 0LOC_CURRCY |
InfoObject | Material | 0MATERIAL |
InfoObject | Plant Material | 0MAT_PLANT |
InfoObject | Plant | 0PLANT |
InfoObject | Record type | 0RECORDTP |
InfoObject | Request ID | 0REQUID |