/SCDL/DB_PROCI_I

-- ============================================================
-- Table  : /SCDL/DB_PROCI_I — Inbound delivery item — the line grain of the inbound delivery: product, batch, quantity, entitled party, and the goods-receipt and completion statuses
-- Purpose: Column-selected read of /SCDL/DB_PROCI_I — 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_PROCI_I; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_proci_i — 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 inbound delivery header",
  lower(hex(t.DOCID)) AS "Document GUID of the owning inbound delivery header (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEMID AS "Item GUID — the target of warehouse-task item references when the category is inbound",
  lower(hex(t.ITEMID)) AS "Item GUID — the target of warehouse-task item references when the category is inbound (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.ITEMTYPE AS "Item type",
  t.PRODUCTID AS "Product GUID (RAW16 form) — note the name carries no underscore",
  lower(hex(t.PRODUCTID)) AS "Product GUID (RAW16 form) — note the name carries no underscore (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 "Delivery item quantity",
  t.UOM AS "Unit of measure of the item quantity",
  t.CRETST AS "Item creation time",  -- UTC
  t.ENTITLED AS "Party entitled to dispose",
  t.STATUS_GR AS "Goods receipt status value of the item",
  t.STATUS_COMPL AS "Completion status value of the item",
  t.`/SCWM/WHNO` AS "Warehouse number stamped on the delivery item — a namespaced column name"  -- namespaced column — most replication targets rename it; see quirks guide #namespace-slashes
FROM <catalog>.<schema>.scdl_db_proci_i t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = 'PDI'  -- 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;