/LIME/NTREE

-- ============================================================
-- Table  : /LIME/NTREE — The LIME tree structure — one row per node of the location and handling-unit hierarchy stock hangs on, with its object type, its parent node, and the nested-set interval bookkeeping the engine walks the tree with
-- Purpose: Column-selected read of /LIME/NTREE — auto-generated from field metadata
-- Grain  : One row per client + GUID + OVERFLOW
-- Caution: Structure, not stock — no quantity column exists here; this is the table that resolves a /LIME/NQUAN row's GUID_PARENT into the bin or handling unit it is sitting on
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /LIME/NTREE; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_ntree — 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 AS "GUID of the tree node — the value a quantity row's GUID_PARENT points at",
  lower(hex(t.GUID)) AS "GUID of the tree node — the value a quantity row's GUID_PARENT points at (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.OVERFLOW AS "Overflow counter — a node with many children spills across several rows, so node identity is the GUID, not the row",
  t.TYPE AS "Object type of the node — what kind of object the GUID identifies (a location or a handling unit, for instance)",
  t.IDX AS "Index of the key table the node's object is registered in",
  t.GUID_PARENT AS "GUID of the node above this one — the column a hierarchy walk recurses on",
  lower(hex(t.GUID_PARENT)) AS "GUID of the node above this one — the column a hierarchy walk recurses on (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.TYPE_PARENT AS "Object type of the parent node",
  t.IDX_PARENT AS "Index of the key table the parent object is registered in",
  t.LFT AS "Left interval bound of the node — nested-set bookkeeping the engine uses to read a subtree in one pass",
  t.RGT AS "Right interval bound of the node",
  t.LVL AS "Depth of the node in the tree",
  t.GAP AS "Interval gap kept free below the node so children can be inserted without renumbering",
  t.GUID_PN_ADD AS "GUID of the posting-change or additional document line the node was written by",
  lower(hex(t.GUID_PN_ADD)) AS "GUID of the posting-change or additional document line the node was written by (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ID_ADD AS "Line item identifier of that additional document line",
  t.TARGET_ADD AS "Whether the additional record is the source or the target side of the movement",
  t.TS_LIME_ADD AS "LIME internal timestamp of the node in long form (yyyymmddhhmmss with fractional seconds), not the short form the rest of this reference filters on"
FROM <catalog>.<schema>.lime_ntree t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.GUID;