NORMA Tool ๐Ÿ“Š Report Customers Suppliers Warehouse

get_unhedged_demand โ€” Unhedged Demand

For each item, how much open sales-order demand is NOT covered by current stock plus open purchase orders.

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

Unhedged-demand report โ€” for each item, how much open sales-order demand is NOT covered by current stock plus open purchase orders. Returns one row per exposed item with open_so_qty (summed across open sales orders), on_hand_qty (stock on hand), open_po_qty (on open purchase orders), and unhedged_gap (open_so โˆ’ on_hand โˆ’ open_po, floored at 0), largest gap first. Only items with a positive gap appear โ€” a fully covered item is omitted.

Try these prompts

  • “show me unhedged demand”
  • “what am I short of?”
  • “which items have unhedged demand?”
  • “where will I run out against open orders?”

ื ืกื• ื’ื ื‘ืขื‘ืจื™ืช

  • “ื”ืฆื’ ื‘ื™ืงื•ืฉ ืœื ืžื›ื•ืกื””
  • “ื‘ืžื” ืื ื™ ืขืœื•ืœ ืœื”ื™ื•ืช ื—ืกืจ?”
  • “ื”ื™ื›ืŸ ื™ื™ื’ืžืจ ืœื™ ื”ืžืœืื™ ืžื•ืœ ื”ื–ืžื ื•ืช ืคืชื•ื—ื•ืช?”

Arguments

No arguments.

Example result

Two items are exposed. I002 โ€” 120 ordered, 80 on hand, 20 on open POs, gap 20. I001 โ€” 90 ordered, 40 on hand, 30 on open POs, gap 20.

Result columns

ColumnTypeMeaning
item_codetextThe item’s SAP code.
item_nametextThe item’s name.
open_so_qtynumberQuantity committed on open sales orders โ€” the demand side.
on_hand_qtynumberQuantity in stock, summed across warehouses.
open_po_qtynumberQuantity on open purchase orders โ€” the inbound cover.
unhedged_gapnumberopen_so_qty minus on_hand_qty minus open_po_qty, floored at 0. Only rows above 0 are returned.

Charts

  • bar: x=item_name, y=unhedged_gap, title=“Unhedged demand by item”
  • bar: x=item_name, y=open_so_qty,on_hand_qty,open_po_qty, title=“Demand against stock and inbound”
  • get_stock_coverage โ€” how long stock lasts at the recent sales rate (a demand-rate view).
  • report_inventory_valuation โ€” the money value of on-hand stock.
  • get_order_backlog โ€” open-order demand against stock, without netting POs.