/SCDL/DB_HUITEM

-- ============================================================
-- Table  : /SCDL/DB_HUITEM — Delivery handling unit contents — one row per delivery item packed into an HU, with the packed quantity and unit
-- Purpose: Column-selected read of /SCDL/DB_HUITEM — auto-generated from field metadata
-- Grain  : One row per client + DOCID + HUID + ITEMID + 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_HUITEM; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_huitem — 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 content belongs to",
  lower(hex(t.HUID)) AS "Handling unit GUID the content belongs to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "Delivery item GUID packed into the handling unit",
  lower(hex(t.ITEMID)) AS "Delivery item GUID packed into the handling unit (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.COUNTER AS "Counter separating repeated packings of the same delivery item into the same handling unit — the one readable key column",
  t.HUITEMNO AS "Readable handling unit item number",
  t.HUITEMID AS "GUID of the handling unit item itself",
  lower(hex(t.HUITEMID)) AS "GUID of the handling unit item itself (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.QTY AS "Quantity of the delivery item packed into this handling unit",
  t.UOM AS "Unit of measure of the packed quantity"
FROM <catalog>.<schema>.scdl_db_huitem t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.DOCID = unhex('<DOCID>')  -- pass the 32-character hex form
  -- AND t.ITEMID = unhex('<ITEMID>')  -- pass the 32-character hex form
ORDER BY t.DOCID;