...
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 |
Key Figures
| 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. |