Variances Dynamic versus Static Minimum
Stock 
Query: 0FRE_C08_Q0001 / 0FRE_C28_Q0001
This report provides a list of instances in which the static and dynamic minimum stocks for a product/location differ. It shows the quantity difference between these two minimum stocks, helping the replenishment manager to validate the statistically-defined minimum stock.
The data is displayed at the most detailed level by period, product, and location. You can drill down to see additional information as well as filter the data in the query by the following characteristics: location type, merchandise category, stock planner, replenishment lead time, and selling class.
Variables are provided so you can enter a selection range of periods, product, and location.
The following KPIs and key figures are calculated in this query:
Dynamic/static minimum stock MAD
Mean percentage dynamic/static minimum stock
The following KPIs and key figures are displayed in this query:
Dynamic minimum stock
Minimum stock
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| N/A |
- |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
InfoObject |
| Location Type |
0PLANT_0PLANTCAT |
| Merchandise Category |
0MATERIAL_0MATL_GROUP |
| Material Group Hierarchy 1 |
0MATERIAL_ORPA_WGH1 |
| Material Group Hierarchy 2 |
0MATERIAL_ORPA_WGH2 |
| Material Group Hierarchy 3 |
0MATERIAL_ORPA_WGH3 |
| Material Group Hierarchy 4 |
0MATERIAL_ORPA_WGH4 |
| Replenishment Type |
0FRE_REPLST |
| Replenishment Planner |
0MAT_PLANT_FRE_PLNPUR |
| Replenishment Lead Time |
0FRE_RPLTIM |
| Selling Class |
0FRE_SELCLS |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
Variable |
| (required) Period |
0I_DAYS |
| Product |
0S_PROD |
| Location |
0S_LOC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar Day |
0CALDAY |
- |
| Product |
0MATERIAL |
- |
| Location |
0PLANT |
- |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Dynamic Minimum Stock (in BUoM) |
0FRE_DMINST |
- |
| Minimum Stock (in BUoM) |
0FRE_MINSTK |
- |
| Dynamic/Static Minimum Stock Absolute Difference (Calculated Key Figure) |
0FRE_C08_CK001 |
(Note: This is not an actual column in the query itself. It is displayed here for documentation purposes only.) |
| Dynamic/Static Minimum Stock MAD (Calculated Key Figure) |
0FRE_C08_CK002 |
Note = The total and summary lines display the average, or MAD. |
| Percentage Difference Dynamic/Static Minimum Stock (Calculated Key Figure). |
0FRE_C08_CK003 |
Note: This is not a column in the query, it is displayed here for documentation purposes only. |
| Mean percentage deviation Dynamic / Static Minimum Stock (calculated key figure). |
0FRE_C08_CK004 |
Note: The total and summary lines display the average or mean percentage deviation. |