/SCWM/VEH_SR_ACT

-- ============================================================
-- Table  : /SCWM/VEH_SR_ACT — Vehicle activities — the same shipping-and-receiving activity shape for a vehicle: planned and actual times, activity type and direction, the driver, the carrier, and the weighed weight
-- Purpose: Column-selected read of /SCWM/VEH_SR_ACT — auto-generated from field metadata
-- Grain  : One row per client + VEH_NUM + VEH_SR_ACT_NUM
-- Caution: One row per vehicle visit, not per vehicle — and the vehicle's activity is a different row from the transportation unit's, so a yard dwell measure must decide which object it is measuring
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/VEH_SR_ACT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_veh_sr_act — 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 activity belongs to",
  t.VEH_SR_ACT_NUM AS "Shipping-and-receiving activity number — one visit of this vehicle",
  t.ACT_ID AS "GUID of the shipping-and-receiving activity",
  lower(hex(t.ACT_ID)) AS "GUID of the shipping-and-receiving activity (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ACT_TYPE AS "Activity type",
  t.ACT_CAT AS "Activity category",
  t.ACT_DIR AS "Direction of the activity — inbound against outbound",
  t.START_PLAN_TSTFR AS "Earliest planned start of the visit",  -- UTC
  t.START_PLAN_TSTTO AS "Latest planned start of the visit",  -- UTC
  t.START_ACTUAL AS "Actual start of the visit",  -- UTC
  t.START_TZONE AS "Time zone the start times are read in locally — the stored values are UTC",
  t.END_PLAN_TSTFR AS "Earliest planned end of the visit — the open end of the departure window",  -- UTC
  t.END_PLAN_TSTTO AS "Latest planned end of the visit — the close of the departure window",  -- UTC
  t.END_ACTUAL AS "Actual end of the visit",  -- UTC
  t.END_TZONE AS "Time zone the end times are read in locally",
  t.DRIVER AS "Driver on this visit — recorded per activity, not on the vehicle master, because it changes visit to visit",
  t.TSP_CURR AS "Carrier actually serving this visit",
  t.VEH_WEIGHT AS "Weighed total weight of the vehicle for this visit",
  t.VEH_WEIGHT_UOM AS "Unit the weighed weight is expressed in",
  t.YARD AS "Warehouse number of the yard the activity takes place in"
FROM <catalog>.<schema>.scwm_veh_sr_act t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.START_ACTUAL >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.START_ACTUAL <= <TS_TO>
ORDER BY t.VEH_NUM;