Non-cumulative key figures are generally measured in related to point in time. Non cumulative key figures in Inventory management are derived in the run time based on In-flow and out-flow of stock movements. Properties of the key figures maintained at the query level will impact the results of the query output. Some of these key figures include Value of valuated stock (0VALSTCKVAL), Quantity of valuated stock (0VALSTCKQTY) etc.,
Let’s have a scenario of generating a report to view the stocks pertaining to last 6 months period including the current month. The report should output Calendar Year/Month along with the valuated stock qty and value information and the overall result should display the stocks pertaining to current month because it represents the stock currently available.
To ensure this output property ‘Calculate Result As’ should be set to ‘Nothing Defined’ for non cumulative key figures. Any other values of this property would reflect in in-correct value.
Month | Value of valuated stock | Quantity of valuated stock |
04/2011 | $ 1000 | 100 EA |
05/2011 | $ 2000 | 200 EA |
06/2011 | $ 4000 | 400 EA |
07/2011 (current month) | $ 6000 | 600 EA |
Overall Result | $ 6000 | 600 EA |
Query output with Key figure property "Calculate Result As" set to "Summation":
Month | Value of valuated stock | Quantity of valuated stock |
04/2011 | $ 1000 | 100 EA |
05/2011 | $ 2000 | 200 EA |
06/2011 | $ 4000 | 400 EA |
07/2011 (current month) | $ 6000 | 600 EA |
Overall Result | $ 13000 | 1300 EA |