/SCDL/DB_HU

-- ============================================================
-- Table  : /SCDL/DB_HU — Delivery handling units — the HUs attached to a delivery document, with the readable HU number, the packaging material, and the packaging specification and packing instruction that built them
-- Purpose: Column-selected read of /SCDL/DB_HU — auto-generated from field metadata
-- Grain  : One row per client + DOCID + HUID
-- 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_HU; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_hu — 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 handling unit is attached to",
  lower(hex(t.DOCID)) AS "Document GUID of the delivery the handling unit is attached to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUID AS "Handling unit GUID within the delivery layer — not documented as the same value as the warehouse HU GUID",
  lower(hex(t.HUID)) AS "Handling unit GUID within the delivery layer — not documented as the same value as the warehouse HU GUID (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HUNO AS "Readable handling unit number — the bridge to the warehouse-side HU header",
  t.ACTION_CODE AS "Action code from the message that created or changed the handling unit",
  t.CROSS_HU AS "Flag: the handling unit spans more than one delivery — the row that makes per-delivery HU counts double-count",
  t.DLV_COUNTER AS "Counter distinguishing repeated handling unit entries on one delivery",
  t.PRODUCTID AS "Packaging material of the handling unit, as a product GUID (RAW16 form)",
  lower(hex(t.PRODUCTID)) AS "Packaging material of the handling unit, as a product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PRODUCTNO AS "Readable packaging material number",
  t.BATCHNO AS "Batch number of the packaging material",
  t.HU_GUID_EXT AS "External handling unit GUID, where the HU originated outside this system",
  lower(hex(t.HU_GUID_EXT)) AS "External handling unit GUID, where the HU originated outside this system (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PB_ENGINE AS "Package building engine that produced the handling unit",
  t.PS_GUID AS "GUID of the packaging specification the handling unit was built from",
  lower(hex(t.PS_GUID)) AS "GUID of the packaging specification the handling unit was built from (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PS_ID AS "Readable packaging specification identifier",
  t.PS_LEVEL_SEQ AS "Which level of the packaging specification produced this handling unit",
  t.PI_GUID AS "GUID of the packing instruction applied",
  lower(hex(t.PI_GUID)) AS "GUID of the packing instruction applied (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PI_ID AS "Readable packing instruction identifier"
FROM <catalog>.<schema>.scdl_db_hu 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;