/SCDL/DB_REQI

-- ============================================================
-- Table  : /SCDL/DB_REQI — Delivery request item — the line grain of the inbound notification or outbound request, with product, batch, quantity, and entitled party
-- Purpose: Column-selected read of /SCDL/DB_REQI — 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_REQI; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_reqi — 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 request header",
  lower(hex(t.DOCID)) AS "Document GUID of the owning request header (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "Item GUID",
  lower(hex(t.ITEMID)) AS "Item GUID (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOCCAT AS "Document category — inbound notification or outbound request; always filter it",
  t.ITEMCAT AS "Item category",
  t.ITEMTYPE AS "Item type",
  t.CRETST AS "Item creation time",  -- UTC
  t.CHGTST AS "Last change time",  -- UTC
  t.PRODUCTID AS "Product GUID (RAW16 form)",
  lower(hex(t.PRODUCTID)) AS "Product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PRODUCTNO AS "Readable product number",
  t.BATCHNO AS "Batch number",
  t.QTY AS "Request item quantity",
  t.UOM AS "Unit of measure",
  t.ENTITLED AS "Party entitled to dispose",
  t.STOCK_USAGE AS "Stock usage classification"
FROM <catalog>.<schema>.scdl_db_reqi t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = '<IDR|ODR>'  -- 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;