/SCWM/RSRC

-- ============================================================
-- Table  : /SCWM/RSRC — Resources — the operators, vehicles, and devices that execute warehouse orders, with the queue each is working, the bin it is currently at, and the handling unit it is carrying
-- Purpose: Column-selected read of /SCWM/RSRC — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + RSRC
-- Caution: Current state, not history — the queue, bin, and carried HU columns are overwritten as work proceeds; execution history lives on the task and order tables
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/RSRC; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_rsrc — 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",
  t.RSRC AS "Resource — an RF user, vehicle, or material-flow device that executes work",
  t.RSRC_TYPE AS "Resource type",
  t.RSRC_GRP AS "Resource group used for queue assignment",
  t.UNAME AS "SAP user currently logged on to the resource",
  t.RFIND AS "RF execution environment indicator",
  t.GUID_HU AS "GUID of the handling unit the resource is currently carrying",
  lower(hex(t.GUID_HU)) AS "GUID of the handling unit the resource is currently carrying (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.QUEUE AS "Queue the resource is assigned to",
  t.ACT_QUEUE AS "Queue the resource is actually working",
  t.LGTYP AS "Storage type of the resource's last removal",
  t.ACTUAL_BIN AS "Bin where the resource currently is",
  t.DEFAULT_BIN AS "The resource's default (home) bin",
  t.LTRANSCHG_AT AS "Time of the last logical-transaction change",  -- UTC
  t.MFS_QUEUE AS "Queue assigned to the resource in material flow system scenarios",
  t.EXCCODE_OVERALL AS "Overall exception code currently set on the resource"
FROM <catalog>.<schema>.scwm_rsrc t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.RSRC = '<RSRC>'
  -- AND t.LTRANSCHG_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.LTRANSCHG_AT <= <TS_TO>
ORDER BY t.LGNUM;