/SCWM/T300_MD

-- ============================================================
-- Table  : /SCWM/T300_MD — Warehouse-to-party assignment — the supply chain unit the warehouse maps to plus the default entitled-to-dispose and ship-to parties
-- Purpose: Column-selected read of /SCWM/T300_MD — auto-generated from field metadata
-- Grain  : One row per client + LGNUM
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/T300_MD; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_t300_md — 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.CUSTODIAN AS "Custodian business partner — carried for legacy data",
  t.ENTITLED AS "Default party entitled to dispose for this warehouse",
  t.SC_UNIT AS "Supply chain unit the warehouse maps to, in its readable form",
  t.SCUGUID AS "Supply chain unit GUID — the join bridge to /SCMB/TOENTITY",
  lower(hex(t.SCUGUID)) AS "Supply chain unit GUID — the join bridge to /SCMB/TOENTITY (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.SHIPTO AS "Default ship-to party for the warehouse"
FROM <catalog>.<schema>.scwm_t300_md t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;