/SCWM/HUHDR

-- ============================================================
-- Table  : /SCWM/HUHDR — Handling unit header — one row per HU with its external number, packaging material, current storage type and bin, weights, volumes, and the entitled party whose stock it holds
-- Purpose: Column-selected read of /SCWM/HUHDR — auto-generated from field metadata
-- Grain  : One row per client + GUID_HU
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/HUHDR; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_huhdr — 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_HU AS "Internal GUID of the handling unit — the join handle from available quants, the LIME tree, and task HU references",
  lower(hex(t.GUID_HU)) AS "Internal GUID of the handling unit — the join handle from available quants, the LIME tree, and task HU references (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUIDENT AS "External handling-unit identification — the human-readable HU number, often an SSCC",
  t.PMAT_GUID AS "GUID of the packaging material product",
  lower(hex(t.PMAT_GUID)) AS "GUID of the packaging material product (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.LGNUM AS "Warehouse number the handling unit lives in",
  t.LETYP AS "Handling unit type",
  t.CREATED_BY AS "User who created the handling unit",
  t.CREATED_AT AS "Handling unit creation time",  -- UTC
  t.CHANGED_AT AS "Last change time",  -- UTC
  t.G_WEIGHT AS "Total (gross) weight of the handling unit",
  t.T_WEIGHT AS "Tare weight of the packaging",
  t.UNIT_GW AS "Unit for the weight figures",
  t.G_VOLUME AS "Total volume of the handling unit",
  t.UNIT_GV AS "Unit for the volume figures",
  t.ENTITLED AS "Party entitled to dispose of the stock in the handling unit",
  t.WSTYP AS "Storage type where the handling unit currently sits",
  t.WSBIN AS "Storage bin where the handling unit currently sits",
  t.TOP AS "Flag: the highest-level handling unit in a nesting hierarchy"
FROM <catalog>.<schema>.scwm_huhdr t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.GUID_HU = unhex('<GUID_HU>')  -- pass the 32-character hex form
  -- AND t.CREATED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATED_AT <= <TS_TO>
ORDER BY t.GUID_HU;