/SCDL/DB_HUREFHU

-- ============================================================
-- Table  : /SCDL/DB_HUREFHU — Delivery handling unit hierarchy — the parent-to-child links between nested HUs on a delivery, and nothing else
-- Purpose: Column-selected read of /SCDL/DB_HUREFHU — auto-generated from field metadata
-- Grain  : One row per client + DOCID + HUID + HUID_LOW
-- Caution: A recursive parent/child edge list — walk it, never aggregate it: summing HU quantities across the join double-counts every unit that sits inside a nested HU
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCDL/DB_HUREFHU; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_hurefhu — 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.DOCID AS "Document GUID of the delivery the nesting belongs to",
  lower(hex(t.DOCID)) AS "Document GUID of the delivery the nesting belongs to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUID AS "GUID of the higher-level handling unit",
  lower(hex(t.HUID)) AS "GUID of the higher-level handling unit (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUID_LOW AS "GUID of the handling unit nested inside it",
  lower(hex(t.HUID_LOW)) AS "GUID of the handling unit nested inside it (hex)"  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
FROM <catalog>.<schema>.scdl_db_hurefhu t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.DOCID = unhex('<DOCID>')  -- pass the 32-character hex form
ORDER BY t.DOCID;