/SCDL/DB_DLVH_O

-- ============================================================
-- Table  : /SCDL/DB_DLVH_O — Final outbound delivery header — the document that exists after goods issue, carrying the shipped delivery's number, type, incoterms, sales organization, and the flags that mark corrections, pickups, and scrapping
-- Purpose: Column-selected read of /SCDL/DB_DLVH_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_DLVH_O; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_dlvh_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 final outbound delivery — its own GUID, not the delivery order's",
  lower(hex(t.DOCID)) AS "Document GUID of the final outbound delivery — its own GUID, not the delivery order's (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCCAT AS "Document category — the final outbound delivery category",
  t.DOCTYPE AS "Delivery document type",
  t.DOCNO AS "Readable outbound delivery number",
  t.CRETST AS "Creation time of the final delivery — in practice the goods-issue moment the document was cut at",  -- UTC
  t.CREUSR AS "Created by",
  t.CHGTST AS "Last change time",  -- UTC
  t.CHGUSR AS "Last changed by",
  t.CHGVERSION AS "Change version counter of the document",
  t.MANUAL AS "Flag: the delivery was created manually rather than by the process",
  t.VKORG AS "Sales organization the delivery belongs to",
  t.INCO1 AS "Incoterms part 1",
  t.`/SCWM/CORRIND` AS "Flag: the document is a correction delivery — a namespaced column name",  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
  t.`/SCWM/PICKUPIND` AS "Flag: the goods were picked up rather than shipped — a namespaced column name",  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
  t.`/SCWM/SCRAPPIND` AS "Flag: the delivery is a scrapping — a namespaced column name",  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
  t.`/SCWM/COMMIND` AS "ERP communication indicator — a namespaced column name",  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
  t.`/SCWM/LOG_PROCESS` AS "Logistic process classification — a namespaced column name"  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
FROM <catalog>.<schema>.scdl_db_dlvh_o t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = '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.CRETST >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CRETST <= <TS_TO>
ORDER BY t.DOCID;