/SCDL/DB_REFDOC

-- ============================================================
-- Table  : /SCDL/DB_REFDOC — Reference documents — the bridge from an EWM delivery document to the document that caused it in the connected ERP system, with the readable reference number and item
-- Purpose: Column-selected read of /SCDL/DB_REFDOC — auto-generated from field metadata
-- Grain  : One row per client + DOCID + ITEMID + REFDOCCAT + REFDOCID + REFITEMID
-- Caution: One EWM document can carry several reference rows (ERP delivery, purchase order, sales order, ASN) — filter REFDOCCAT before joining or documents duplicate
-- 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_REFDOC; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_refdoc — 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 "GUID of the EWM delivery document",
  lower(hex(t.DOCID)) AS "GUID of the EWM delivery document (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "GUID of the EWM delivery item — initial for header-level references",
  lower(hex(t.ITEMID)) AS "GUID of the EWM delivery item — initial for header-level references (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.REFDOCCAT AS "Category of the referenced document (ERP delivery, purchase order, sales order, ASN)",
  t.REFDOCID AS "GUID of the referenced document, where it exists in EWM",
  lower(hex(t.REFDOCID)) AS "GUID of the referenced document, where it exists in EWM (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.REFITEMID AS "GUID of the referenced item",
  lower(hex(t.REFITEMID)) AS "GUID of the referenced item (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCCAT AS "Document category of the owning EWM document",
  t.REFBSKEY AS "Business system key the reference points into — which connected system owns the number",
  t.REFDOCNO AS "Readable reference document number, typically the ERP delivery number",
  t.REFITEMNO AS "Readable reference item number, typically the ERP delivery item",
  t.TSTFR AS "Reference valid-from time",  -- UTC
  t.TSTTO AS "Reference valid-to time"  -- UTC
FROM <catalog>.<schema>.scdl_db_refdoc 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.REFDOCCAT = '<REFDOCCAT>'
  -- AND t.REFDOCID = unhex('<REFDOCID>')  -- pass the 32-character hex form
  -- AND t.REFITEMID = unhex('<REFITEMID>')  -- pass the 32-character hex form
  -- AND t.TSTFR >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.TSTFR <= <TS_TO>
ORDER BY t.DOCID;