Stock Exceptions: Understocks 
Query: 0FRE_C01_Q0001 / 0FRE_C21_Q0001
Use this query to analyze the occurrence of understocks.
The following KPIs and key figures are calculated within this query:
Understock quantity
Understock percentage
The following KPIs and key figures are displayed within this query:
Number of Understocks
Inventory Quantity
Minimum Stock
Understock Cost (at moving average cost)
Daily Forecast
Daily Consumption
Daily DIF Effects in BUoM
Range of Coverage in Days
Active Daily Forecast
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| N/A |
- |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
InfoObject |
| Location Type |
0PLANT__0PLANTCAT |
| Vendor |
0VENDOR |
| Supplying Plant |
0SUPP_PLANT |
| Merchandise Category |
0MATERIAL__0MATL_GROUP |
| Merchandise Category Level 1 |
0MATERIAL__ORPA_WGH1 |
| Merchandise Category Level 2 |
0MATERIAL__ORPA_WGH2 |
| Merchandise Category Level 3 |
0MATERIAL__ORPA_WGH3 |
| Merchandise Category Level 4 |
0MATERIAL__ORPA_WGH4 |
| Replenishment Type |
0FRE_REPLST |
| Replenishment Planner |
0FRE_PLNPUR |
| Total Replenishment Lead Time |
0FRE_RPLTIM |
| ABC Indicator |
0ABCKEY |
| Selling Class |
0FRE_SELCLS |
| Range of Coverage too High |
0FRE_ROCINV |
| Active Forecast Type |
0FRE_AFCTY |
| Product Substitution Type |
0FRE_REPLTY |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
Variable |
| (required) Period From/To (in Calendar Days) |
0I_DAYS |
| Product |
0S_PROD |
| Location |
0S_LOC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Period |
0CALDAY |
- |
| Product |
0MATERIAL |
- |
| Location |
0PLANT |
- |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Understocks |
0FRE_CNTUS |
- |
| Stock Quantity |
0FRE_STOCK |
- |
| Minimum Stock |
0FRE_CMINSTK |
- |
| Understock Quantity – (Calculated Key Figure) |
0FRE_C01_CK001 |
Understock Quantity = Compared Minimum Stock – inventory quantity |
| Understock Cost |
0FRE_USTCST |
- |
| Understock Percentage – (Calculated Key Figure) |
0FRE_C01_CK002 |
Understock Percentage = Understock Quantity %A Compared Minimum Stock |
| Daily Forecasted Consumption in BuoM |
0FRE_FCST |
- |
| Daily Consumption |
0FRE_CONSMP |
- |
| Daily DIF Effects in BUoM |
0FRE_DDIFEF |
- |
| Range of Coverage in Days |
0FRE_C01_CK003 |
ROC in Days = Range of Coverage in Days /Understocks |
| Daily Active Forecast in BuoM |
0FRE_AFCST |
- |