Subiekt nexo SQL report

I will commission a SQL report for SUBIEKT NEXO PRO

calculation works on the principle of :

Check the stock

check the minimum stock of this assortment

check the bookings on ZK

check how much assortment is ordered on ZD

so for example 1 :

stock is 200

minimum stock is 100

reservations on ZK is 99

on ZD 0

then the column quantity to order will show 0 ( because it is above the minimum stock )

example 2 :

stock is 200

minimum stock is 100

reservations on ZK is 150

on ZD 0

then the column quantity to order will show 50 ( because it is below by 50 pcs from the minimum stock )

example 3 :

stock is 200

minimum stock is 100

reservations on ZK is 150

on ZD 10

then the column quantity to order will show 40 ( because it is below the minimum stock by 40 pcs )

In addition, I would like this report to still have a "keeper" for this assortment - pulled from a custom field and / or commodity group.