/SCDL/DB_PROCI_O

-- ============================================================
-- Table  : /SCDL/DB_PROCI_O — Outbound delivery order item — the line grain outbound: product, quantity, entitled party, stock owner, and the picking and goods-issue statuses
-- Purpose: Column-selected read of /SCDL/DB_PROCI_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_PROCI_O; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scdl_db_proci_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 outbound delivery order header",
  lower(hex(t.DOCID)) AS "Document GUID of the owning outbound delivery order 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 and wave-item references on the outbound side",
  lower(hex(t.ITEMID)) AS "Item GUID — the target of warehouse-task and wave-item references on the outbound side (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 order 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.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.STOCK_OWNER AS "Owner of the stock to be shipped",
  t.STATUS_PICK AS "Picking status value of the item",
  t.STATUS_GI AS "Goods issue 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_o t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  AND t.DOCCAT = 'PDO'  -- 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;