/SCDL/DB_DATE

-- ============================================================
-- Table  : /SCDL/DB_DATE — Delivery dates — the typed date table for the /SCDL layer, one row per document, item, schedule line, date type, and category, each carrying a from/to timestamp pair
-- Purpose: Column-selected read of /SCDL/DB_DATE — auto-generated from field metadata
-- Grain  : One row per client + DOCID + ITEMID + SLINEID + TSTTYPE + TST_CATEGORY
-- Caution: Typed and long — pick the TSTTYPE (and TST_CATEGORY) you mean before joining, or one delivery contributes a row per planned and actual event it carries
-- 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_DATE; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_date — 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 delivery document",
  lower(hex(t.DOCID)) AS "GUID of the 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 delivery item — initial for header-level dates",
  lower(hex(t.ITEMID)) AS "GUID of the delivery item — initial for header-level dates (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.SLINEID AS "GUID of the schedule line the date belongs to",
  lower(hex(t.SLINEID)) AS "GUID of the schedule line the date belongs to (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.TSTTYPE AS "Date and time type code — which planned or actual event the row represents",
  t.TST_CATEGORY AS "Date and time category qualifying the type",
  t.DOCCAT AS "Document category of the owning document",
  t.TZONE AS "Time zone reference for the timestamp pair",
  t.TSTFR AS "From-timestamp of the date entry",  -- UTC
  t.TSTTO AS "To-timestamp of the date entry",  -- UTC
  t.DATE_INDICATOR AS "How the value was determined — the planned against actual determination indicator"
FROM <catalog>.<schema>.scdl_db_date 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.SLINEID = unhex('<SLINEID>')  -- pass the 32-character hex form
  -- AND t.TSTTYPE = '<TSTTYPE>'
  -- AND t.TST_CATEGORY = '<TST_CATEGORY>'
  -- AND t.TSTFR >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.TSTFR <= <TS_TO>
ORDER BY t.DOCID;