Stock
Exceptions: Overstocks
Technical Name: 0FRE_C04_Q0001
Use
This query is used to analyze the occurrence of overstocks.
The following KPIs and key figures are calculated within this query:
Query Formulas
Overstock Quantity
Overstock Percentage
The following KPIs and key figures are displayed in this query:
Number of Overstocks
Stock Quantity
Maximum Stock
Overstock Cost
Overstock Storage Cost (at Storage Handling Cost)
Forecasted Consumption
Consumption
Range of Coverage in Days
Filter
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
N/A |
|
Free Characteristics
InfoObject |
Name |
0PLANTCAT__0PLANTCAT |
Location type |
0VENDOR |
Vendor |
0SUPP_PLANT |
Supplying plant |
0MATERIAL__0MATL_GROUP |
Merchandise Category |
0MATERIAL__0RPA_WGH1 |
Merchandise Category Level 1 |
0MATERIAL__ORPA_WGH2 |
Merchandise Category Level 2 |
0MATERIAL__ORPA_WGH3 |
Merchandise Category Level 3 |
0MATERIAL__ORPA_WGH4 |
Merchandise Category Level 4 |
0FRE_PLNPUR |
Replenishment Planner |
0FRE_RPLTIM |
Replenishment Lead Time |
0ABCKEY |
ABC Indicator |
0FRE_SELCLS |
Selling Class |
0FRE_ROCINV |
Range of Coverage too High |
Variables Used
Variable |
Name |
0I_DAYS |
(required) Period From/To (in Calendar Days) |
0S_PROD |
Product |
0S_LOC |
Location |
Rows
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
||
0CALDAY |
Period |
|
|
0MATERIAL |
Product |
|
|
0PLANT |
Location |
|
|
Columns
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
0FRE_CNTOS |
Counter for Overstock |
0FRE_STOCK |
Stock Quantity |
0FRE_CMAXST |
Compared Maximum Stock |
0FRE_C04_CK001 |
Overstock Quantity – (Calculated Key Figure) Overstock Quantity = Stock Quantity – Compared Maximum Stock |
0FRE_OSTCST |
Overstock Cost |
0FRE_C04_CK002 |
Overstock Percentage – (Calculated Key Figure) Overstock Percentage = ‘Overstock Quantity’ %A ‘Compared Maximum Stock’ |
0FRE_OSTSCS |
Overstock Storage Cost |
0FRE_FCST |
Forecasted Consumption |
0FRE_CONSMP |
Daily Consumption |
0FRE_C04_CK003 |
Range of Coverage in Days ROC in Days (Calculated Key Figures) ROC in Days = Range of Coverage in Days / Overstocks |
Report Report Interface
Query |
Name |
None |
/ |