/SCWM/TMFSPLC

-- ============================================================
-- Table  : /SCWM/TMFSPLC — Programmable logic controllers — the material flow system's definition of each controller EWM exchanges telegrams with, including the warehouse process types used for conveyor putaway, fault handling, and stock transfer
-- Purpose: Column-selected read of /SCWM/TMFSPLC — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + PLC
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TMFSPLC; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tmfsplc — 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 the controller belongs to",
  t.PLC AS "Programmable logic controller code — what the queue master's PLC column points at",
  t.PROCTYPE AS "Warehouse process type used for putaways over the conveyor — the reason automated warehouses show process types nobody chose by hand",
  t.PROCTYPE_ERR AS "Warehouse process type used when a handling unit ends up in fault handling",
  t.PROCTYPE_ATF AS "Warehouse process type used for movement postings raised by the material flow system",
  t.PROCTYPE_STOCK_TRANS AS "Warehouse process type used for stock transfers by material-flow resources",
  t.CL_MODE AS "Communication layer mode EWM talks to the controller through",
  t.RFCDST AS "Logical destination the telegrams are sent to",
  t.PLCIFTYPE AS "Interface type of the controller",
  t.PLC_MODE AS "Operating mode the controller is in",
  t.EXCCODE AS "Exception code raised when the material flow system changes a destination bin",
  t.EWM_ID AS "Identification EWM sends as the telegram sender",
  t.LOGGING AS "Whether telegram traffic for this controller is logged"
FROM <catalog>.<schema>.scwm_tmfsplc t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;