Query - Coverage Days

161 Views

Hello SAP gurus,

I need to make a query on the SAP B1 to give me the coverage days that I have for the materials. It needs to look to my sales orders for the next 30 days (consumption) and then looking to my inventory, gives me for how many days I'm covered.

Example:

Sales for Product01 (next 30 days): 300 qty

* Rawmaterial01 (quantity needed to produce Product01 (BOM) * quantity of Product01): 2 * 300 = 600 qty

* Rawmaterial02 (quantity needed to produce Product01 (BOM) * quantity of Product01): 0.5 * 300 = 150 qty

* Rawmaterial03 (quantity needed to produce Product01 (BOM) * quantity of Product01): 1 * 300 = 300 qty

Demand per day:

* Product01: 10 qty

* Rawmaterial01: 20 qty

* Rawmaterial02: 5 qty

* Rawmaterial03: 10 qty

Inventory:

* Product01: 100 qty

* Rawmaterial01: 100 qty

* Rawmaterial02: 50 qty

* Rawmaterial03: 10 qty

Coverage days:

* Product01: 10 days (inventory/demand per day)

* Rawmaterial01: 5 days (inventory/demand per day)

* Rawmaterial02: 10 days (inventory/demand per day)

* Rawmaterial03: 1 days (inventory/demand per day)

Thanks