Basic Information

Application	IM - Stocks
Workbook Name	BW - Inventory Aging Report (Core Workbook)
Workbook ID	4PLKYKGMEZQV0PESJGGZGZ1UV
Query Name	BW - Inventory Aging Report (Core Query)
Query Technical Name	BW_QRY_MPR_IC001_0001
Multi-Provider Name	Material Stock/Movement
Multi-Provider Technical Name	MPR_IC001
Names & Technical Names of Main Sub-Providers Used	Material Stocks (CUB_IC001) Material Prices (CUB_COPC1)
Usage type	Direct execution in Analyzer
Expected users	Controllers and supply chain

Purpose of this query

To allow BW users to view the stock quantity and value at material & batch levels.
To allow BW users to view the stock quantity and value based on the difference in days between the Key Date specified by users in the query selection against the following dates:
- Batch Manufactured Date
- Batch Explry Date
- Batch Last Goods Issued Date
- Batch Last Goods Receipt Date

Selection Screen

Example:

Assuming now we are in May 2012 (05.2012). But we want to see the report for Rhodia Asia Pacific Pte Ltd (6062) as of 15th April 2012 (15.04.2012).
To achieve this, first we need to enter 6062 in the mandatory selection Company Code (Selection Option, Mandatory). You are allowed to enter multiple values in this selection if you wish to view multiple Companies in the same report.
Next we need to enter 04.2012 in the selection Calendar Year/Month (Single Value, Mandatory). Only one single value is allowed.
Next we need to enter 15.04.2012 in the selection Calendar Day (Single Value, Mandatory). Only one single value is allowed.
Then click on the button OK to continue.

Syensqo IS - Customer Support > BW - Inventory Aging Report (Core Query) > SelectionScreen.JPG

Characteristics and Key Figures available for Display and Drilldown

Characteristics

Name	TechName	Description
Company	0COMP_CODE	Displays Company Code and Name
Material	C_MATNR	Displays Material Code and Name
Batch	C_BATCH	Displays Batch Code and Name
Plant	0PLANT	Displays Plant Code and Name
Valuation Type	0VAL_TYPE	Displays Valuation Type Code and Name

Name	Description
Final Price	Refers to the price of the material which can be the Standard Price or Moving Average Price
Base Quantity for Price	Refers to the quatity of the material that the final price is based on. It is normally in thousands (1,000).
Stock Quantity	Refers to the quatity of the material.
Stock Value	Refers to the value of the material. It is calculated using the following formula: = ( Final Price / Base Quantity for Price ) * Stock Quantity
Key Date (Calendar Day) (A)	Refers to the value entered by User in the selection Calendar Day (Single Value, Mandatory).
Batch Manufacture Date (B)	Refers to the value that is stored in the attribute Date of Manufacture (C_HSDAT) of the Batch master data (C_BATCH).
Batch Expiry Date (C)	Refers to the value that is stored in the attribute Batch Expiry Date (C_EXPIRDT) of the Batch master data (C_BATCH).
Batch Last GR Date (D)	Refers to the value that is stored in the attribute Last GR Date (C_LGRDATE) of the Batch master data (C_BATCH).
Batch Last GI Date (E)	Refers to the value that is stored in the attribute Date of Last Issue (C_DOLI) of the Batch master data (C_BATCH).
(A) - (B)	This is a formula to calculate the difference in the number of days between the Key Date (Calendar Day) (A) and Batch Manufacture Date (B): = Key Date (Calendar Day) (A) - Batch Manufacture Date (B)
(A) - (C)	This is a formula to calculate the difference in the number of days between the Key Date (Calendar Day) (A) and Batch Expiry Date (C): = Key Date (Calendar Day) (A) - Batch Expiry Date (C) Note: This value of this field can be negative because the Batch Expiry Date (C) can be later than the user specified Key Date (Calendar Day) (A).
(A) - (D)	This is a formula to calculate the difference in the number of days between the Key Date (Calendar Day) (A) and Batch Last GR Date (D): = Key Date (Calendar Day) (A) - Batch Last GR Date (D) Note: This value of this field can be negative because the Batch Last GR Date (D) can be later than the user specified Key Date (Calendar Day) (A).
(A) - (E)	This is a formula to calculate the difference in the number of days between the Key Date (Calendar Day) (A) and Batch Last GI Date (E): = Key Date (Calendar Day) (A) - Batch Last GI Date (E) Note: This value of this field can be negative because the Batch Last GI Date (E) can be later than the user specified Key Date (Calendar Day) (A).
Qty 0-30 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 0 and less than or equal to 30 Days.
Qty 31-60 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 31 and less than or equal to 60 Days.
Qty 61-90 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 61 and less than or equal to 90 Days.
Qty 91-120 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 91 and less than or equal to 120 Days.
Qty 121-150 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 121 and less than or equal to 150 Days.
Qty 151-180 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 151 and less than or equal to 180 Days.
Qty 181-365 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 181 and less than or equal to 365 Days.
Qty >365 Days	This field shows the material & batch stock quantity whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than 365 Days.
Value 0-30 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 0 and less than or equal to 30 Days.
Value 31-60 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 31 and less than or equal to 60 Days.
Value 61-90 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 61 and less than or equal to 90 Days.
Value 91-120 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 91 and less than or equal to 120 Days.
Value 121-150 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 121 and less than or equal to 150 Days.
Value151-180 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 151 and less than or equal to 180 Days.
Value181-365 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than or equal to 181 and less than or equal to 365 Days.
Value >365 Days	This field shows the material & batch stock value whose difference between the Key Date (A) and each of the 4 individual Batch Related Dates (B, C, D, E) are greater than 365 Days.