/SCWM/VEHICLE

-- ============================================================
-- Table  : /SCWM/VEHICLE — Vehicles — the tractors and trucks that move transportation units through the yard, with the means of transport, carrier, license plate, and the flag that marks a permanently coupled transportation unit
-- Purpose: Column-selected read of /SCWM/VEHICLE — auto-generated from field metadata
-- Grain  : One row per client + VEH_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/VEHICLE; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_vehicle — 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.VEH_NUM AS "Internal vehicle number — the key the vehicle's activity rows join on",
  t.VEH_NUM_EXT AS "External vehicle number — what the yard and the carrier call it",
  t.VEH_ID AS "Vehicle GUID — the identifier the rest of the shipping-and-receiving layer carries",
  lower(hex(t.VEH_ID)) AS "Vehicle GUID — the identifier the rest of the shipping-and-receiving layer carries (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.MTR AS "Means of transport the vehicle represents",
  t.OWNER AS "Business partner that owns the vehicle",
  t.TSP AS "Carrier operating the vehicle on the master record",
  t.SCAC AS "Standard carrier alpha code of that carrier",
  t.LIC_PLATE_CNTRY AS "Country or region the license plate is registered in",
  t.LIC_PLATE AS "License plate number",
  t.FIXED_ASSIGNMENT AS "Whether a transportation unit is permanently coupled to this vehicle",
  t.VEH_PERMANENT AS "Whether the vehicle is permanently needed for shipping and receiving activities rather than created per visit",
  t.CREATED_BY AS "User who created the vehicle master record",
  t.CREATED_AT AS "Creation time of the vehicle master record",  -- UTC
  t.CHANGED_AT AS "Last change time of the vehicle master record"  -- UTC
FROM <catalog>.<schema>.scwm_vehicle t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.CREATED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATED_AT <= <TS_TO>
ORDER BY t.VEH_NUM;