/LIME/NQUAN

-- ============================================================
-- Table  : /LIME/NQUAN — The LIME stock quantities table — the physical quantity of a stock item hanging on one node of the location/handling-unit tree, one row per stock GUID per node per unit of measure
-- Purpose: Column-selected read of /LIME/NQUAN — auto-generated from field metadata
-- Grain  : One row per client + GUID_STOCK + GUID_PARENT + VSI + UNIT
-- Caution: Rows hang on nodes of the LIME tree — never SUM across rows without resolving GUID_PARENT first, or nested handling units are counted more than once
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /LIME/NQUAN; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_nquan — adjust to your landing convention (see quirks #namespace-slashes). RAW16 GUID columns are joined raw; the hex aliases are for display only (#guid-keys). Timestamps flagged UTC are DEC(15) yyyymmddhhmmss values in UTC, not warehouse local time (#utc-timestamps).
-- ============================================================
SELECT
  t.MANDT AS "Client",
  t.GUID_STOCK AS "Stock GUID — joins to the quant attribute rows",
  lower(hex(t.GUID_STOCK)) AS "Stock GUID — joins to the quant attribute rows (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.GUID_PARENT AS "GUID of the tree node the quantity hangs on — a bin node or a handling-unit node",
  lower(hex(t.GUID_PARENT)) AS "GUID of the tree node the quantity hangs on — a bin node or a handling-unit node (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.VSI AS "Virtual stock indicator",
  t.UNIT AS "Unit of measure of the stock quantity — part of the key, so one stock item can carry several rows",
  t.QUAN AS "Physical stock quantity at this node",
  t.LFT AS "Width value of the node in the LIME tree (nested-set bookkeeping)",
  t.LVL AS "Level of the node within the LIME tree",
  t.IDX_STOCK AS "Index of the key table the stock entry belongs to",
  t.TYPE_PARENT AS "Object type of the parent node",
  t.INV_BLOCK_IND AS "Inventory blocking indicator",
  t.TS_LAST_ABS_POST AS "Time of the last absolute posting against the node — a long-form DEC(21,7) UTC stamp, not the DEC(15) shape the generated range filter parses"
FROM <catalog>.<schema>.lime_nquan t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.GUID_STOCK = unhex('<GUID_STOCK>')  -- pass the 32-character hex form
  -- AND t.GUID_PARENT = unhex('<GUID_PARENT>')  -- pass the 32-character hex form
  -- AND t.VSI = '<VSI>'
  -- AND t.UNIT = '<UNIT>'
ORDER BY t.GUID_STOCK;