/SCWM/TWORKST

-- ============================================================
-- Table  : /SCWM/TWORKST — Work centers — the packing, deconsolidation, value-added-service, and counting stations in the warehouse, each modeled as a storage type and bin
-- Purpose: Column-selected read of /SCWM/TWORKST — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + WORKSTATION
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TWORKST; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tworkst — 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.WORKSTATION AS "Work center within the warehouse (packing, deconsolidation, value-added services, counting)",
  t.PROCS AS "Process interface the work center runs",
  t.LGTYP AS "Storage type the work center is modeled as",
  t.LGPLA AS "Storage bin assigned to the work center",
  t.I_SECTION AS "Inbound section of the work center, where arriving handling units land",
  t.O_SECTION AS "Outbound section of the work center, where finished handling units leave",
  t.PROCTY AS "Warehouse process type used for moves created at the work center",
  t.WRKSTTYP AS "Work center layout type",
  t.HUINPUT AS "Whether the handling-unit field is ready for input in the RF and desktop user interfaces",
  t.DLFT_PMAT AS "Default packaging material, as a product GUID",
  lower(hex(t.DLFT_PMAT)) AS "Default packaging material, as a product GUID (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.RL_PROCTY AS "Warehouse process type for return transfers from the pick point",
  t.RLTYP AS "Return storage type for pick-point returns",
  t.RLBER AS "Return storage section for pick-point returns",
  t.AAREA_PLAN AS "Activity area used for planning at this work center",
  t.SCALE AS "Identifier of the scale connected to the work center"
FROM <catalog>.<schema>.scwm_tworkst t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.WORKSTATION = '<WORKSTATION>'
ORDER BY t.LGNUM;