/SCDL/DB_PROCH_O

-- ============================================================
-- Table  : /SCDL/DB_PROCH_O — Outbound delivery order header — the EWM-side outbound document with its readable number, type, warehouse, ship-to and carrier parties, route, and sales organization
-- Purpose: Column-selected read of /SCDL/DB_PROCH_O — auto-generated from field metadata
-- Grain  : One row per client + DOCID
-- 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_PROCH_O; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_proch_o — 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 of the outbound delivery order",
  lower(hex(t.DOCID)) AS "Document GUID of the outbound delivery order (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCCAT AS "Document category",
  t.DOCTYPE AS "Delivery document type",
  t.DOCNO AS "Readable outbound delivery order number",
  t.CRETST AS "Creation time",  -- UTC
  t.CHGTST AS "Last change time",  -- UTC
  t.WAREHOUSE_ID AS "Location GUID of the warehouse",
  lower(hex(t.WAREHOUSE_ID)) AS "Location GUID of the warehouse (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PARTNERTO_ID AS "Partner GUID of the ship-to party",
  lower(hex(t.PARTNERTO_ID)) AS "Partner GUID of the ship-to party (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PARTNERCARR_ID AS "Partner GUID of the carrier",
  lower(hex(t.PARTNERCARR_ID)) AS "Partner GUID of the carrier (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.STATUS AS "Header status value",
  t.ROUTE_ID AS "Route identification",
  t.VKORG AS "Sales organization",
  t.TW_STOP_ID AS "Transit-warehouse stop reference",
  t.CRETST_WH AS "Creation time in the warehouse time zone — warehouse-local, not UTC"
FROM <catalog>.<schema>.scdl_db_proch_o t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = 'PDO'  -- 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.CRETST >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CRETST <= <TS_TO>
ORDER BY t.DOCID;