get_order_backlog — Order Backlog

For each item with open sales-order demand, how much is ordered versus how much stock is on hand.

This is a Named SQL Query (SAP /SQLQueries) — dynamic aggregate SQL returning per-query rows, not a fixed Service Layer entity.

Order-backlog report — for each item with open sales-order demand, how much is ordered versus how much stock is on hand. Returns one row per item with ordered_qty (summed across open sales orders), on_hand (stock on hand), shortage (ordered_qty − on_hand, floored at 0), and coverage_ok (true when on_hand >= ordered_qty), largest shortage first. A point-in-time fulfilment view — it reports every item with open-order demand, hedged or not.

Try these prompts

“show me the order backlog”
“what are we short of on open orders?”
“can we fulfil the open orders for I002?”
“order backlog for I001”

נסו גם בעברית

“הצג את צבר ההזמנות”
“במה אנחנו חסרים מול הזמנות פתוחות?”
“האם נוכל לספק את ההזמנות הפתוחות?”

Arguments

Arg	Required	Meaning
`item_code`	optional	One product, e.g. `I001`. Omit for all items.

Example result

I002 can’t be filled from stock. I002 — 120 ordered, 80 on hand, shortage 40 (coverage NOT ok). I001 — 50 ordered, 90 on hand, no shortage (coverage ok).

Result columns

Column	Type	Meaning
`item_code`	text	The item’s SAP code.
`item_name`	text	The item’s name.
`ordered_qty`	number	Quantity committed on open sales orders.
`on_hand`	number	Quantity in stock, summed across warehouses.
`shortage`	number	`ordered_qty` minus `on_hand`, floored at 0 — the unmet demand.
`coverage_ok`	text	`true` when stock covers the open orders. The row holds a boolean; the closed type set has none, so it is declared `text` — a flag to read, not a magnitude to plot.

Charts

bar: x=item_name, y=ordered_qty,on_hand, title=“Open demand vs stock”
bar: x=item_name, y=shortage, title=“Shortage by item”

get_unhedged_demand — nets open purchase orders too, dropping fully-hedged items.
get_stock_coverage — how long stock lasts at the recent sales rate.