Outbound Delivery Items 
DataSource Transactional Data: 0WM_DLVI_OUT
This DataSource provides you with completed outbound delivery items.
Technical Data
Application Component | Warehouse Management 0WM |
|---|---|
Available as of Release | SAP EWM 900 |
Shipment | SAP NetWeaver 7.0 BI Content Add-On 7 |
Content Versions | EWM900 |
RemoteCube-Capable | No |
Delta-Capable | Yes, delta process AIE; generic delta |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
DOCID |
Document ID |
/SCDL/DB_DLVH_O |
DOCID |
ITEMID |
Item ID |
/SCDL/DB_DLVI_O |
ITEMID |
DOCNO |
Document Number |
/SCDL/DB_DLVH_O |
DOCNO |
ITEMNO |
Item Number |
/SCDL/DB_DLVI_O |
ITEMNO |
ITEMCAT |
Item Category |
/SCDL/DB_DLVI_O |
ITEMCAT |
ITEMTYPE |
Item Type |
/SCDL/DB_DLVI_O |
ITEMTYPE |
DOCTYPE |
Document Type |
/SCDL/DB_DLVH_O |
DOCTYPE |
LGNUM |
Warehouse Number/Warehouse Complex |
/SCDL/DB_PROCI_O |
/SCWM/WHNO |
INCO1 |
Incoterms (Part 1) |
/SCDL/DB_DLVH_O |
INCO1 |
INCO2 |
Incoterms (Part 2) |
/SCDL/DB_DLVH_O |
INCO2 |
PRODUCTID |
Product ID |
/SCDL/DB_PROCI_O |
PRODUCTID |
PRODUCTNO |
Product |
/SCDL/DB_PROCI_O |
PRODUCTNO |
GROSW |
Weight of Delivery |
/SCDL/DB_ADDMEAS |
QTY |
GWUOM |
Unit of Measure |
/SCDL/DB_ADDMEAS |
UOM |
GROSV |
Volume of Delivery |
/SCDL/DB_ADDMEAS |
QTY |
GVUOM |
Unit of Measure |
/SCDL/DB_ADDMEAS |
UOM |
ITEM_QTY |
Quantity |
/SCDL/DB_ADDMEAS |
QTY |
ITEM_QTY_UOM |
Unit of Measure |
/SCDL/DB_ADDMEAS |
UOM |
BATCHNO |
Batch Number |
/SCDL/DB_PROCI_O |
BATCHNO |
ENTITLED |
Party Entitled to Dispose |
/SCDL/DB_PROCI_O |
ENTITLED |
STOCK_USAGE |
Stock Usage |
/SCDL/DB_PROCI_O |
STOCK_USAGE |
OWNER |
Owner |
/SCDL/DB_PROCI_O |
STOCK_OWNER |
CARRIERNO |
Carrier |
/SCDL/DB_BPLOC |
PARTYNO |
TRANS_MODE |
Transportation Mode |
/SCDL/DB_TRANS |
TRANS_MODE |
MTR |
Means of Transport |
/SCDL/DB_TRANS |
TRANSMEANS_TYPE |
REFDOCNO_ERO |
Reference Document Number |
/SCDL/DB_REFDOC |
REFDOCNO |
REFITEMNO_ERO |
Reference Item Number |
/SCDL/DB_REFDOC |
REFITEMNO |
COO |
Country of Origin |
/SCDL/DB_PROCI_O |
OCOUNTRY |
VFDAT |
Best-Before Date/Shelf Life Expiration Date |
/SCDL/DB_PROCI_O |
BESTBEFORE_DATE/SHELFEXPIR_DATE |
PSA |
Production Supply Area (PSA) |
/SCDL/DB_PROCI_O |
/SCWM/PSA |
VALUE |
Product Value |
||
WAERS |
Currency Key |
/SCWM/T_VALUATE//SCWM/T_VAL_SPLT |
WAERS |
COMPL_TS |
Completion Date/Time |
/SCDL/DB_STATUS |
TSTFR |
ZERO_QTY_DLVI |
Delivery Item with Zero Quantity |
/SCDL/DB_PROCI_O |
QTY |
DLV_PROC_IND |
Delivery Item Business Process for BW Reporting |
||
NOT_RELEVANT |
Delivery Item Relevance Flag |
||
SERVICE_LEVEL |
Shipping Condition |
/SCDL/DB_PROCI_O |
SERVICE_LEVEL |
WHS_TZONE |
Time Zone of Warehouse |
/SCMB/TOENTITY |
TZONE |
GI_TS |
Goods Issue Date/Time |
/SCDL/DB_DATE |
TSTTO |
SHIP_TO_NO |
Ship-To |
/SCDL/DB_BPLOC |
PARTYNO |
ROUTE_ID |
Route Name (Identification) |
/SCDL/DB_TRANS |
ROUTE_ID |
PRIORITY |
Delivery Priority |
/SCDL/DB_PROCI_O |
PRIORITY |
EXPRT_REL |
Export Relevancy (Only Integration) |
/SCDL/DB_TRANS |
/SCWM/GTS_CODE |
DELAY_IN_MIN |
Delay of Outbound Delivery Item in Minutes |
||
POD_REL |
Relevant for Proof of Delivery |
/SCDL/DB_PROCI_O |
/SCWM/POD_REL |
Extractor Logic
The fields in the table of origin for the extract structure largely consist of a 1:1 relation to data-based fields. For an explanation of how the other fields are instead determined by the extractor, see the table below.
Fields in the Extract Structure |
Field Determined by Extractor |
|---|---|
VALUE |
Determined by extractor with ITEM_QTY and material price (/SCWM/T_VALUATE-VERPR/-STPRS, /SCWM/T_VAL_SPLT-VERPR/-STPRS) |
DLV_PROC_IND |
Determined by extractor in BAdI, Determination of Business Process for Delivery: /SCWM/EX_BW_BUSINESS_PRCSS_IND. This BAdI provides a fallback class default implementation that sets the business process for a specific delivery item. You can use this BAdI from Enhancement Spot /SCWM/ES_BW to implement your own logic for the field Business Process. |
NOT_RELEVANT |
Determined by extractor in BAdI, Setting of Not Relevant Indicator for Delivery Item: /SCWM/EX_BW_FILTER_DLVI. This BAdI provides a fallback class default implementation that sets the Not Relevant indicator to X when the Goods Issue status is other than 9 (Posted). You can use this BAdI from Enhancement Spot /SCWM/ES_BW to implement your own logic for the field Not Relevant. |
DELAY_IN_MIN |
Determined by extractor in BAdI, Delay Calculation of Outbound Delivery Item: /SCWM/EX_BW_DLVI_O_DELAY. This BadI provides a fallback class default implementation that sets the Delay in Minutes based on either planned GI date or planned out-of-yard date and actual completion date. |