/SCWM/TUNIT

-- ============================================================
-- Table  : /SCWM/TUNIT — Transportation units — the trailers, containers, and swap bodies goods are loaded into, with the internal and external number, the means of transport, the carrier, and the license plate
-- Purpose: Column-selected read of /SCWM/TUNIT — auto-generated from field metadata
-- Grain  : One row per client + TU_NUM
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TUNIT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tunit — 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 key the activity and assignment tables join on",
  t.TU_NUM_EXT AS "External transportation unit number — what the yard and the carrier call the trailer",
  t.LIME_ID AS "Location GUID of the transportation unit — a TU is a place stock can sit, so it exists as a location in the stock engine",
  lower(hex(t.LIME_ID)) AS "Location GUID of the transportation unit — a TU is a place stock can sit, so it exists as a location in the stock engine (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.LIME_ID_UNPACKED AS "Handling-unit GUID of the transportation unit in its unpacked form",
  lower(hex(t.LIME_ID_UNPACKED)) AS "Handling-unit GUID of the transportation unit in its unpacked form (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.HU_ID AS "Handling-unit GUID of the transportation unit — the TU seen as an HU, which is how loaded stock hangs off it",
  lower(hex(t.HU_ID)) AS "Handling-unit GUID of the transportation unit — the TU seen as an HU, which is how loaded stock hangs off it (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.MTR AS "Means of transport the unit represents",
  t.OWNER AS "Business partner that owns the transportation unit",
  t.TSP AS "Carrier assigned to the transportation unit on the master record",
  t.SCAC AS "Standard carrier alpha code of that carrier",
  t.MAX_SEAL_NUM AS "Maximum number of seals the unit takes",
  t.FIXED_VEH_NUM AS "Vehicle permanently coupled to the unit, where the yard works with fixed pairings",
  t.LIC_PLATE_CNTRY AS "Country or region the license plate is registered in",
  t.LIC_PLATE AS "License plate number",
  t.TU_PERMANENT AS "Whether the unit is permanently needed for shipping and receiving activities rather than created per visit"
FROM <catalog>.<schema>.scwm_tunit t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.TU_NUM;