/SCWM/T346

-- ============================================================
-- Table  : /SCWM/T346 — Queue definition — the execution queues warehouse tasks, warehouse orders, and resources are routed through, with the operating environment each queue serves and the material-flow controller behind it where the queue drives automation
-- Purpose: Column-selected read of /SCWM/T346 — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + QUEUE
-- Caution: Configuration as it stands now — a queue definition is overwritten in place, so it describes today's routing, never the routing a historic task was created under
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/T346; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_t346 — 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 — queues are unique only within it",
  t.QUEUE AS "Queue code — the value every queue column on tasks, orders, and resources carries",
  t.RFRSRC AS "Operating environment the queue serves — which execution channel picks its work up",
  t.PLC AS "Programmable logic controller the queue's work is driven by, where the queue belongs to the material flow system",
  t.QTYPE AS "Queue type used for RF task interleaving — how work from this queue may be mixed with work from another",
  t.SEMI_SGUID AS "Whether semi-system-guided processing is allowed for RF tasks in the queue",
  t.QUEUE_PRINT AS "Printing behavior for work issued from the queue",
  tx.TEXT AS "Queue description in the row's language"
FROM <catalog>.<schema>.scwm_t346 t
LEFT JOIN <catalog>.<schema>.scwm_t346t tx
  ON tx.MANDT = t.MANDT
 AND tx.QUEUE = t.QUEUE
 AND tx.LGNUM = t.LGNUM
 AND tx.SPRAS = '<language>'  -- one language or rows multiply
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;