/SCWM/TMFSCP

-- ============================================================
-- Table  : /SCWM/TMFSCP — Communication points — the identification points, scanners, and segments of the conveyor network a controller reports against, each mapped to a storage bin, with its capacity and the clarification point faults are routed to
-- Purpose: Column-selected read of /SCWM/TMFSCP — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + PLC + CP
-- Caution: Configuration with live state mixed in — the telegram columns on this table hold the last message exchanged and are overwritten continuously, so nothing here is a history of conveyor traffic
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TMFSCP; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tmfscp — 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.PLC AS "Controller the communication point reports to",
  t.CP AS "Communication point — a place on the conveyor network the controller can report a handling unit at",
  t.CP_TYPE AS "Type of communication point",
  t.CPGRP AS "Communication point group the point belongs to",
  t.LGPLA AS "Storage bin the point maps to — what makes a conveyor movement look like an ordinary bin movement in the task tables",
  t.FLG_START AS "Whether the point is the identification point that starts a conveyor leg",
  t.FLG_END AS "Whether the point ends a conveyor leg",
  t.FLG_SCAN AS "Whether the point is a scanner point on the leg",
  t.FLG_NIO AS "Whether the point is a clarification bin faulted units are routed to",
  t.CP_CLARIFY AS "Communication point faults at this point are clarified at",
  t.LGPLA_CLF AS "Storage bin used as the clarification bin",
  t.CAPACITY AS "Capacity of the segment behind the point, in handling units",
  t.CAPA_MODE AS "How that capacity is interpreted",
  t.EXCCODE_CAPA AS "Exception code raised when the segment's capacity is exceeded",
  t.PROCTYPE AS "Warehouse process type used for putaways initiated at this point",
  t.NO_FOLLUP AS "Whether a follow-up warehouse task is suppressed at this point"
FROM <catalog>.<schema>.scwm_tmfscp t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;