/SCWM/WHO

-- ============================================================
-- Table  : /SCWM/WHO — Warehouse order header — the bundle of tasks one operator executes as a unit, with the creation rule that produced it, the wave it came from, its queue, activity area, assigned resource, and the timestamps that bound execution
-- Purpose: Column-selected read of /SCWM/WHO — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + WHO
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/WHO; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_who — 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 "Warehouse number",
  t.WHO AS "Warehouse order number — the table/field name collision: the table is /SCWM/WHO and so is the column",
  t.STATUS AS "Warehouse order status",
  t.WCR AS "Warehouse order creation rule that produced the order",
  t.WAVE AS "Wave the warehouse order was created from",
  t.AREAWHO AS "Activity area the warehouse order is assigned to — the column is AREAWHO here, not AAREA",
  t.QUEUE AS "Queue the warehouse order is routed to",
  t.RSRC AS "Resource (user or equipment) the warehouse order is assigned to",
  t.PROCESSOR AS "Processor working the warehouse order",
  t.CREATED_AT AS "Warehouse order creation time",  -- UTC
  t.STARTED_AT AS "Warehouse order start time",  -- UTC
  t.CONFIRMED_AT AS "Warehouse order confirmation time",  -- UTC
  t.CONFIRMED_BY AS "User who confirmed the warehouse order",
  t.LSD AS "Latest starting date and time for on-time execution",  -- UTC
  t.TOPWHOID AS "Higher-level warehouse order number, where orders are nested",
  t.FLGTO AS "Flag: the warehouse order contains warehouse tasks",
  t.WHOID AS "Unique GUID of the warehouse order — informational; joins ride warehouse number plus order number",
  lower(hex(t.WHOID)) AS "Unique GUID of the warehouse order — informational; joins ride warehouse number plus order number (hex)"  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
FROM <catalog>.<schema>.scwm_who t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.WHO = '<WHO>'
  -- AND t.CREATED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATED_AT <= <TS_TO>
ORDER BY t.LGNUM;