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 of Origin for the Extract Structure
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.

Data Modeling: Field Determination by the Extractor
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.