Basic Information
| BW Server | WBP |
|---|---|
| Application | IM Stocks |
| Query Name | BW - Turn - 91 days (Core Query) |
| Query Technical Name | BW_QRY_MPR_IC001_0029 |
| Core/Specific Scope | Core - Can be used by everyone. |
| Provider Name | Material Stock MPR_IC001 |
| Usage type | Direct execution via Analysis |
| Expected users | Supply chain |
Purpose of this query
The objectif of this query is to display the inventory turnover (Turn) and days of supply (DOS) to identify materials in inventory that have a slow turnover and then take action.
In this query, the turnover is calculated based on the stock issues of the past 91 days.
The reason this query was created was because some users wanted a TURN that could updated daily (instead of having to wait the end of the month to run the 3 month version of the query).
This query can be run any time during the month by selecting the current date.
Important information
- This query calculates the Turnover at plant boundaries.
This query cannot be used to calculate a turnover at GBU or company level since transfers from one plant to another are considered as stock issues.
- As the objective of the report is to identify slow moving stocks, movements related to scrapping are excluded from the issues(otherwise scrapped materials will show with a good turnover).
- Transfers inside the plant (from one storage location to another storage location) are excluded from the issues.
Variables screen
| Variable Name | Authorization Object | Description |
|---|---|---|
| Company Code | Yes | The company code owning the stock |
| Day of analysis | No | The date used for the end of the 91days |
Careful : if you select a date in the future, the TURN will be incorrect as the stock issues will be under-evaluated. |
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Infoprovider | <> CUB_COPC1 Material Prices | This so that the data from the material prices cube are not included in this query (not needed) |
Characteristics
The list below only describes the characteristics which may need explanations :
| Characteristic Name | Characteristic code | Explanation |
|---|---|---|
| Calendar Day | 0CALDAY | Careful when using this characteristic in this report : For the stock issues this is the date of the movement. For the stock level this is the date for the stock qty/value |
| 1 - Enterprise | C_MATPLNT__C_PFCTR1 | GBU |
Key Figures
DOS
Description
Days of supplies calculated for the 91 days period. It's the number of days of supplies left considering the inventory value at day D and the average stock issues between days D-90 and D.
Calculation rule detail
It's the number of days in the year divided by the turnover.
DOS = 365 / TURN
Example
If you have turnover is 365 , then DOS will be 365/365 = 1 --> You only have stock for 1 more day.
If you have a turnover of 100, then DOS will be 365/100 = 36.5 --> You have 36,5 days of stock left.
if you have a turnover of 1, then DOS will be 365/1 = 365 --> You have 1 year of stock left.
Turn
Description
Inventory Turnover for the day D. It's calculated based on the value of the annualized stock issues of the D-90 to D period and the inventory value at the end of day D.
Calculation rule detail
Turn = (Stock Issues D-90 to D) * 4 / (End of D stock value)
Example
You want to calculate the TURN :
- During the last 91 days, you had 1.000$ of stock issues so your annualized stock issue is 4.000$.
- At end of day D, the inventory value was 10.000$
- Your turn will be 10000/4000 = 2.5 --> In 1 year, your inventory is "turning" 2,5 times if you keep the same issues as in the last 91 days.
Issued Stock - Annualized
Description
It's the amount of the stock issues between D-90 and D multiplied by 4 (annualized).
Amount is in thousands (Kilo currency).
Are considered issues the following material movement types :
Calculation rule detail
Issued Stock - Annualized = Sum of the material movements between D-90 and D, considering only the Issue movement types (list above). Then multiply by 4 to annualize.
Note that transfers inside the plant as well as scraping are not considered as issues.
Stock Value D (K Currency)
Description
This is the value of the inventory at the end of the selected date in thousands and local currency.
Calculation
No calculation. This comes directly from SAP.
Valuaed Stock Qty
Description
This is the quantity of the inventory at the end of the selected D date in thousands and local currency.
It's not actually used in the query calculations but only there for you to verify.
It includes the quantity for material that are valuated (materials with a value of 0 are not included).
Calculation
No calculation. This comes directly from SAP.
Currency Conversion
There is no currency conversion in this query as it's intended to be used usually for a single plant or single legal entity.
Conditional Formatting
See how to use in the Formatting page.
| Condition Name | Rule |
|---|---|
| TURN <> 0 | Shows only the lines for which the TURN is not equal to 0 |
| TURN = 0 | Shows only the lines for which the TURN is equal to 0 (Usually materials with 0 inventory) |
FAQ
Question : What does the X value mean in DOS ?
A "X" value in BW means that the calculation couldn't be done due to a division by 0. In the case of the DOS, it means the TURN was equal to 0.
Question : How can I remove all the lines where TURN is empty (Lines where the material has no stock) ?
You can activate one of the BEX Conditions to filter on the data
