Keyfigures are operational attributes which indicate numerical measure such as amount, weight, quantity etc. When working with inventory data, stock coverage is an important KPI that users look out for.
SAP provides us with a direct method to calculate the stock coverage based on available stock and demand in a time interval. Let us see how to create the stock coverage keyfigure from available stocks and demand key figure with a simple example.
Create a keyfigure info object with a Quantity data type. Enable ‘Stock Coverage’ option in the properties section as shown below, it opens a new tab as stock coverage.
You can find the exception aggregation is applied by default on the key figure to find the weighted average with a number of days.
Select the required unit to measure the coverage time for example ‘Month’ as shown below
Configure the stock coverage tab as shown below to calculate the number of months that the current stock will suffice.
Add the Stock Coverage info object to the ADSO with the reference objects as shown below, the values will be automatically calculated in the queries based on the values from the reference objects given.
The stock coverage keyfigure will give us the number of months the available stock will meet the demands.
Know more about Visual BI Solutions SAP BW Services offerings here.