/SCWM/DOOR_SRACT

-- ============================================================
-- Table  : /SCWM/DOOR_SRACT — Door activities — the shipping-and-receiving activities assigned to a warehouse door, with the planned and actual occupancy window
-- Purpose: Column-selected read of /SCWM/DOOR_SRACT — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + DOOR + DOOR_SR_ACT_NUM
-- Caution: Door occupancy, not dock throughput — a row says the door was reserved for an activity between two stamps, and overlapping planned windows are the door-scheduling problem this table exposes
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/DOOR_SRACT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_door_sract — 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.LGNUM AS "EWM warehouse number — doors are unique only within it",
  t.DOOR AS "Warehouse door the activity is assigned to",
  t.DOOR_SR_ACT_NUM AS "Activity number at that door — one occupancy of the door",
  t.ACT_ID AS "GUID of the shipping-and-receiving activity — the same identifier the transportation unit's activity row carries, which is how a door occupancy is tied to the trailer standing at it",
  lower(hex(t.ACT_ID)) AS "GUID of the shipping-and-receiving activity — the same identifier the transportation unit's activity row carries, which is how a door occupancy is tied to the trailer standing at it (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 door occupancy",  -- UTC
  t.START_PLAN_TSTTO AS "Latest planned start of the door occupancy",  -- UTC
  t.START_ACTUAL AS "Actual start of the door occupancy",  -- 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 door occupancy",  -- UTC
  t.END_PLAN_TSTTO AS "Latest planned end of the door occupancy — the pair of planned windows is what a door-scheduling conflict is measured against",  -- UTC
  t.END_ACTUAL AS "Actual end of the door occupancy",  -- UTC
  t.END_TZONE AS "Time zone the end times are read in locally"
FROM <catalog>.<schema>.scwm_door_sract t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.DOOR = '<DOOR>'
  -- AND t.START_ACTUAL >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.START_ACTUAL <= <TS_TO>
ORDER BY t.LGNUM;