EWM Reference
/SCWM/PRDO
ChangeMaintain the outbound delivery order — the document EWM plans, picks, and stages against before goods issue
Tables behind this transaction
Curated: these are the tables an analyst reads to see what this transaction did, and how it touches each of them. Every table page carries its own field list and Databricks SQL.
How these tables connect — join details in the list below. GUID joins and text-table joins are highlighted.
Join details
ON scdl_db_proch_o.MANDT = scdl_db_proci_o.MANDT AND scdl_db_proch_o.DOCID = scdl_db_proci_o.DOCIDON scdl_db_dlvh_o.MANDT = scdl_db_status.MANDT AND scdl_db_dlvh_o.DOCID = scdl_db_status.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scdl_db_dlvh_o.MANDT = scdl_db_refdoc.MANDT AND scdl_db_dlvh_o.DOCID = scdl_db_refdoc.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scdl_db_dlvh_o.MANDT = scdl_db_date.MANDT AND scdl_db_dlvh_o.DOCID = scdl_db_date.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scdl_db_proch_o.MANDT = scdl_db_status.MANDT AND scdl_db_proch_o.DOCID = scdl_db_status.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scdl_db_proch_o.MANDT = scdl_db_refdoc.MANDT AND scdl_db_proch_o.DOCID = scdl_db_refdoc.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scdl_db_proch_o.MANDT = scdl_db_date.MANDT AND scdl_db_proch_o.DOCID = scdl_db_date.DOCID -- RAW16 GUID equality — join raw; hex is for display/conformance only
R read · W write · R/W read + write
Primary tables
- /SCDL/DB_PROCH_OOutbound delivery order header — the EWM-side outbound document with its readable number, type, warehouse, ship-to and carrier parties, route, and sales organizationRead/write accessGUID keytransaction
- /SCDL/DB_PROCI_OOutbound delivery order item — the line grain outbound: product, quantity, entitled party, stock owner, and the picking and goods-issue statusesRead/write accessGUID keytransaction
Secondary tables
- /SCDL/DB_DATEDelivery 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 pairRead/write accessMixed keytransaction
- /SCDL/DB_DLVH_OFinal outbound delivery header — the document that exists after goods issue, carrying the shipped delivery's number, type, incoterms, sales organization, and the flags that mark corrections, pickups, and scrappingRead accessGUID keytransaction
- /SCDL/DB_REFDOCReference 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 itemRead accessMixed keytransaction
- /SCDL/DB_STATUSDelivery status — the long, narrow status table every /SCDL document writes into, one row per document or item per status type with its value and validity windowRead/write accessMixed keytransaction
More Delivery Processing (Warehouse Requests) t-codes
- /SCWM/IDNMaintain the inbound delivery notification — the request document that arrives from the connected ERP system before the inbound delivery exists
- /SCWM/ODRMaintain the outbound delivery request — the request document that precedes the outbound delivery order
- /SCWM/PRDIMaintain the inbound delivery — the EWM-side receipt document goods receipt is posted against