/SCWM/TDOOR

-- ============================================================
-- Table  : /SCWM/TDOOR — Doors — the loading and unloading points of the warehouse, each mapped to a bin, a default staging area, and (where a yard exists) the matching yard bin
-- Purpose: Column-selected read of /SCWM/TDOOR — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + DOOR
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TDOOR; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_tdoor — 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.DOOR AS "Warehouse door",
  t.DOOR_BIN AS "Storage bin representing the door — the join to the bin master",
  t.LOAD_DIR AS "Loading direction of the door (inbound or outbound use)",
  t.STAREA_GR_DEF AS "Default staging area group served by the door",
  t.STAREA_DEF AS "Default staging area served by the door",
  t.MTR_DEF AS "Default means of transport at the door",
  t.SC_UNIT AS "Supply chain unit representing the door, in its readable form",
  t.SCUGUID AS "Supply chain unit GUID for the door",
  lower(hex(t.SCUGUID)) AS "Supply chain unit GUID for the door (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ROUTE_PROP AS "Route proposed for shipments over this door",
  t.YARD_LGNUM AS "Warehouse number of the attached yard",
  t.YARD_DOOR_BIN AS "Yard bin that mirrors the door on the yard side",
  t.YARD_LGTYP AS "Yard storage type of that bin",
  t.YARD_LGBER AS "Yard storage section of that bin",
  t.NR_RANGE AS "Number range used for documents created at the door"
FROM <catalog>.<schema>.scwm_tdoor t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.DOOR = '<DOOR>'
ORDER BY t.LGNUM;