Number of Stock Exceptions (SAP Library - SAP Forecasting and Replenishment)

Number of Stock Exceptions

Technical Name: 0FRE_MC01_Q0001

Use

This query is used to analyze the total number of stock exceptions that have occurred in a given period of time.

The query is based on a multi-provider that includes all four stock exception info.cubes (MultiProvider: Stock Exceptions):

The query is executed as a query jump from the sender query (History of Manually Changed Order Proposals). This allows you to display the number of stock exceptions that exist for a product/location displayed in the History of Manually Changed Order Proposals. The date(s) included in this query represents the same date(s) as in the FRE_C06_Q0001 query, plus 15 days into the future.

Filter

InfoObject	Description of the InfoObject (and restriction or calculation formula)
N/A

Free Characteristics

InfoObject	Description
N/A

Variables Used

Variable	Description	Type of Selection
0I_DAYWT 0I_DAYWT+15	Day Value Restrict Variable and Specified an Offset of +15 for the Second Variable of the Range.	Mandatory
0S_MAT	Product	Optional
0S_PLANT	Location	Optional

The variables are used to select a range of days, products, and locations.

Rows

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0CALDAY	Calendar Day
0MATERIAL	Product
0PLANT	Location

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0FRE_CNTUS	Counter for Understocks
0FRE_CNTOS	Counter for Overstocks
0FRE_CNTSO	Counter for Stockouts
0FRE_CNTPSO	Counter for Possible Stockouts

Report/Report Interface

Query	Name
Stock Exceptions: Understocks	0FRE_C01_Q0001
Stock Exceptions: Stockouts and Lost Sales	0FRE_C02_Q0001
Stock Exceptions: Stockouts and Undelivered Products	0FRE_C03_Q0001
Stock Exceptions: Overstocks	0FRE_C04_Q0001

The following KPIs and key figures are calculated within this query:

Calculated Key Figures

N/A

Query Formulas

N/A

The following KPIs and key figures are displayed in this query:

Counter for Overstocks

Counter for Understocks

Counter for Stockouts