Zero Stock report in BW

[abdulwahabbaig-1]

Hi All,

I have a requirement in BW to create a report which shows number of times a material has gone to zero stock in a specific period. Example: Material A has gone zero stock on 5th of Jan 2019 and it remains out of stock for 15 days. Again on 20th of Jan 2019 it was refilled. The duration until which it was replenished should be counted as 1. Again on 24th Jan 2019 it was zero stock until 28th Jan 2019. This will be considered as count 2.

We have to show number of times a material has gone zero stock for a year. This report will provide data for last 5 years. This report will be created based on MCBE.

Please suggest how this can be achieved in BW.