/SCDL/DB_HUIDENT

-- ============================================================
-- Table  : /SCDL/DB_HUIDENT — Alternative handling unit identifiers — the other numbers an HU is known by, one row per identifier type
-- Purpose: Column-selected read of /SCDL/DB_HUIDENT — auto-generated from field metadata
-- Grain  : One row per client + DOCID + HUID + HUIDTYPE + COUNTER
-- 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_HUIDENT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_huident — 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",
  lower(hex(t.DOCID)) AS "Document GUID of the delivery (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUID AS "Handling unit GUID the identifier belongs to",
  lower(hex(t.HUID)) AS "Handling unit GUID the identifier belongs to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUIDTYPE AS "Identification type — which kind of identifier the row carries",
  t.COUNTER AS "Counter allowing several identifiers of the same type on one handling unit",
  t.HUIDENT AS "The identifier value — 40 characters here, wider than the 20-character external HU number on the warehouse-side HU header"
FROM <catalog>.<schema>.scdl_db_huident 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;