Stock
Exceptions: Stockouts and Undelivered Products
Technical Name: 0FRE_C03_Q0001
Use
This query is used to analyze occurrences of stockouts and undelivered products for distribution centers (DCs).
The following key performance indicators are calculated in this query:
Calculated Key Figures
Moving average cost per unit
Query formulas
Undelivered Product Cost
Actual Service Level
The following KPIs and key figures are displayed in this query:
Number of Stockouts
Undelivered Products in units (lost consumption)
Forecasted goods issues (forecasted consumption)
Goods issues (daily consumption)
Range of coverage in days
Stock quantity
Minimum Stock
Filter
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
N/A |
|
Free Characteristics
InfoObject |
Name |
0VENDOR |
Vendor |
0SUPP_PLANT |
Supplying Plant |
0MATERIAL__0MATL_GROUP |
Merchandise Category |
0MATERIAL__ORPA_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 |
Total Replenishment Lead Time |
0ABCKEY |
ABC Indicator |
0FRE_SELCLS |
Selling Class |
0FRE_STKEXC |
Stock Exception Type |
0FRE_ROCINV |
Range of Coverage Too High |
Variables Used
Variable |
Name |
0I_DAYS |
(required)Period |
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_CNTSO |
Number for Stockouts |
0FRE_CNTPSO |
Number of Possible Stockouts |
0FRE_LSTCSP |
Undelivered Product Units |
0FRE_LSTCCST |
Undelivered Product Cost |
0FRE_C03_CK003 |
Actual Service Level – (Calculated KeyFigure) Actual Service Level = Daily Consumption %A (Daily Consumption + Lost Consumption) |
0FRE_FCST |
Daily Forecasted Consumption in BuoM |
0FRE_CONSMP |
Daily Consumption |
0FRE_C03_CK001 |
Range of Coverage in Days ROC in Days (Calculated Key Figure) ROC in Days = Range of Coverage in Days / Stockouts + Possible Stockouts |
0FRE_STOCK |
Stock Quantity |
0FRE_MINSTK |
Minimum Stock |
Report Report Interface
Query |
Name |
None |
/ |