/SCWM/TRSRC_TYP

-- ============================================================
-- Table  : /SCWM/TRSRC_TYP — Resource types — the physical characteristics of a class of resource: travel velocities and their unit, position management, RF task-interleaving behavior, and the layout type used for automated aisles
-- Purpose: Column-selected read of /SCWM/TRSRC_TYP — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + RSRC_TYPE
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TRSRC_TYP; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_trsrc_typ — adjust to your landing convention (see quirks #namespace-slashes). 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_TYPE AS "Resource type — the class of equipment or operator a resource belongs to",
  t.VELOCITY AS "Horizontal travel velocity of the resource type — the input that turns a bin-to-bin distance into an expected travel time",
  t.VELOCITY_Z AS "Vertical travel velocity, for equipment that also moves up the aisle",
  t.VELOCITY_UOM AS "Unit the two velocities are expressed in",
  t.POSTN_MNGMNT AS "Whether the resource's position in the warehouse is tracked, and how",
  t.INTLEAV AS "Activation flag for interleaving on the resource type — the data element is MFS-namespaced and the page does not state the scope, so read it as the switch rather than as a definition of which movements may be interleaved",
  t.NOINTERLEAV AS "Whether interleaving is suppressed in the RF environment specifically",
  t.RSRC_MOVE_MODE AS "How warehouse task confirmation is controlled for the resource type",
  t.MFSMAXTEL AS "Maximum number of telegrams the resource type may hold, in material flow scenarios",
  t.MFS_MAX_STOCKTRANS AS "Maximum number of stock transfers allowed in an automated aisle at once",
  t.LAYOUT_TYPE AS "Layout type the resource type works in, used for automated aisles",
  t.RSRC_TYPE_CAT AS "Category of the resource type — the broad class it falls into"
FROM <catalog>.<schema>.scwm_trsrc_typ t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;