/SCMB/TOENTITY

-- ============================================================
-- Table  : /SCMB/TOENTITY — Supply chain unit header — the location object EWM resolves warehouse, door, and party GUIDs against, carrying the readable identifier, the time zone, and the geo-coordinates
-- Purpose: Column-selected read of /SCMB/TOENTITY — auto-generated from field metadata
-- Grain  : One row per client + SCUGUID
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCMB/TOENTITY; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scmb_toentity — 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.SCUGUID AS "Supply chain unit GUID — the RAW16 key warehouse, door, and party references resolve against",
  lower(hex(t.SCUGUID)) AS "Supply chain unit GUID — the RAW16 key warehouse, door, and party references resolve against (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ENTITY AS "Readable supply chain unit identifier",
  t.SCUGUID22 AS "The same GUID in its 22-character compressed form — the bridge to the CHAR22-keyed master-data tables",
  t.SCUTYPE AS "Supply chain unit type",
  t.TZONE AS "Time zone of the unit — what turns EWM's UTC stamps into local warehouse time",
  t.PARTNER_GUID AS "Business partner GUID behind the unit",
  lower(hex(t.PARTNER_GUID)) AS "Business partner GUID behind the unit (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DELFLG AS "Deletion indicator",
  t.LONGITUDE AS "Longitude of the unit",
  t.LATITUDE AS "Latitude of the unit",
  t.CREATEUSER AS "Created by",
  t.CREATEUTC AS "Creation time",  -- UTC
  t.CHANGEUSER AS "Last changed by",
  t.CHANGEUTC AS "Time of the last change"  -- UTC
FROM <catalog>.<schema>.scmb_toentity t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.SCUGUID = unhex('<SCUGUID>')  -- pass the 32-character hex form
  -- AND t.CREATEUTC >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATEUTC <= <TS_TO>
ORDER BY t.SCUGUID;