/SCWM/TU_DLV

-- ============================================================
-- Table  : /SCWM/TU_DLV — Transportation unit assignments — one row per delivery or handling unit loaded onto (or unloaded from) a transportation unit for one shipping-and-receiving activity
-- Purpose: Column-selected read of /SCWM/TU_DLV — auto-generated from field metadata
-- Grain  : One row per client + TU_NUM + TU_SR_ACT_NUM + SEQ_NUM
-- Caution: The grain is the assignment, not the delivery: a delivery split across two trailers has a row per trailer activity, and an HU-level assignment and a delivery-level assignment can both exist for the same load — read ASGN_TYPE before counting anything
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TU_DLV; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tu_dlv — 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.TU_NUM AS "Internal transportation unit number the assignment belongs to",
  t.TU_SR_ACT_NUM AS "Activity number — which visit of that transportation unit the assignment was made for",
  t.SEQ_NUM AS "Sequence number within the activity — what keeps two assignments of the same visit apart",
  t.LGNUM AS "Warehouse number the assignment was made in",
  t.DOCCAT AS "Document category of the assigned delivery — decides whether the GUIDs below point at the inbound or the outbound item table",
  t.DOCID AS "GUID of the assigned delivery document",
  lower(hex(t.DOCID)) AS "GUID of the assigned delivery document (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "GUID of the assigned delivery item",
  lower(hex(t.ITEMID)) AS "GUID of the assigned delivery item (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCNO AS "Readable number of that delivery document",
  t.ITEMNO AS "Readable item number of that delivery item",
  t.ASGN_TYPE AS "Assignment type — whether the row assigns a delivery or a handling unit to the transportation unit",
  t.TOP_HU AS "GUID of the top-level handling unit assigned, for an HU assignment — the warehouse-side HU, so it joins straight to the HU header",
  lower(hex(t.TOP_HU)) AS "GUID of the top-level handling unit assigned, for an HU assignment — the warehouse-side HU, so it joins straight to the HU header (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.TOP_HUIDENT AS "Readable identification of that handling unit",
  t.CROSS_HU AS "Whether the handling unit spans more than one delivery — the row that makes a per-delivery HU count double-count",
  t.STATE AS "State of the handling-unit assignment",
  t.FD_STATUS AS "Whether a final outbound delivery already exists for the assigned document",
  t.CREATED AS "Creation time of the assignment, on the warehouse-local timestamp domain rather than the UTC one the execution tables use",
  t.CHANGED AS "Last change time of the assignment, on the same warehouse-local domain"
FROM <catalog>.<schema>.scwm_tu_dlv t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.TU_NUM;