/SCDL/DB_STATUS

-- ============================================================
-- Table  : /SCDL/DB_STATUS — Delivery status — the long, narrow status table every /SCDL document writes into, one row per document or item per status type with its value and validity window
-- Purpose: Column-selected read of /SCDL/DB_STATUS — auto-generated from field metadata
-- Grain  : One row per client + DOCID + ITEMID + STATUS_TYPE
-- Caution: Long and narrow — filter STATUS_TYPE (and DOCCAT) before pivoting, or a document's statuses fan out across every status type it has ever carried
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCDL/DB_STATUS; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_status — 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.DOCID AS "Document GUID the status row belongs to",
  lower(hex(t.DOCID)) AS "Document GUID the status row belongs to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "Item GUID — initial (blank) for header-level status rows",
  lower(hex(t.ITEMID)) AS "Item GUID — initial (blank) for header-level status rows (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.STATUS_TYPE AS "Status type code (picking, goods issue, warehouse activity, and so on) — filter it before pivoting",
  t.DOCCAT AS "Document category of the referenced document — all five categories share this table",
  t.STATUS_VALUE AS "Current value of the status",
  t.TZONE AS "Time zone reference for the status timestamps",
  t.TSTFR AS "Status valid-from time",  -- UTC
  t.TSTTO AS "Status valid-to time",  -- UTC
  t.CHGUSR AS "User who last changed the status row"
FROM <catalog>.<schema>.scdl_db_status t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = '<IDR|ODR|PDI|PDO|FDO>'  -- document category — one /SCDL table holds every category; see quirks guide #doccat
  -- AND t.DOCID = unhex('<DOCID>')  -- pass the 32-character hex form
  -- AND t.ITEMID = unhex('<ITEMID>')  -- pass the 32-character hex form
  -- AND t.STATUS_TYPE = '<STATUS_TYPE>'
  -- AND t.TSTFR >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.TSTFR <= <TS_TO>
ORDER BY t.DOCID;