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.

Stock Coverage Key Figure in BW4HANA

Step 1

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.

Stock Coverage Key Figure in BW4HANA

You can find the exception aggregation is applied by default on the key figure to find the weighted average with a number of days.

Step 2

Select the required unit to measure the coverage time for example ‘Month’ as shown below

Stock Coverage Key Figure in BW4HANA

Step 3

Configure the stock coverage tab as shown below to calculate the number of months that the current stock will suffice.

Stock Coverage Key Figure in BW4HANA

Step 4

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.

Stock Coverage Key Figure in BW4HANA

Query Output

Stock Coverage Key Figure in BW4HANA

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.

Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!