/SCDL/DB_DLVI_O

-- ============================================================
-- Table  : /SCDL/DB_DLVI_O — Final outbound delivery item — the shipped line, carrying its own item GUID plus the reference document and item it was created from in both GUID and readable form
-- Purpose: Column-selected read of /SCDL/DB_DLVI_O — auto-generated from field metadata
-- Grain  : One row per client + DOCID + ITEMID
-- 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_DLVI_O; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_dlvi_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 owning final outbound delivery header",
  lower(hex(t.DOCID)) AS "Document GUID of the owning final outbound delivery header (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "Item GUID of the shipped line",
  lower(hex(t.ITEMID)) AS "Item GUID of the shipped line (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCCAT AS "Document category",
  t.DOCNO AS "Readable delivery number, carried denormalized onto the item",
  t.ITEMNO AS "Readable item number",
  t.ITEMCAT AS "Item category",
  t.REFDOCID AS "Document GUID of the predecessor the item was created from — the link back to the delivery order",
  lower(hex(t.REFDOCID)) AS "Document GUID of the predecessor the item was created from — the link back to the delivery order (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.REFITEMID AS "Item GUID of that predecessor item",
  lower(hex(t.REFITEMID)) AS "Item GUID of that predecessor item (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.REFDOCNO AS "Readable predecessor document number",
  t.REFITEMNO AS "Readable predecessor item number",
  t.CRETST AS "Item creation time",  -- 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 item",
  t.MANUAL AS "Flag: the item was created manually"
FROM <catalog>.<schema>.scdl_db_dlvi_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.ITEMID = unhex('<ITEMID>')  -- 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;