Warehouse Tasks

DataSource Transactional Data 0WM_WT_WO

Use

This DataSource provides you with confirmed warehouse tasks. It does not provide you with warehouse documents of goods movements or posting changes.

Technical Data

Application Component Warehouse Management (0WM)
Exchange Available as of Release SAP SCM 5.1 and SAP EWM 5.1
Shipment SAP NetWeaver 2004s BI Content Add-On 3
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 Extraction Structure

Fields in the Extraction Structure Description of the Field in the Extraction Structure Table of Origin Field in the Table of Origin
MANDT Client /SCWM/ORDIM_C MANDT
LGNUM Warehouse Number/Warehouse Complex /SCWM/ORDIM_C LGNUM
TANUM Warehouse Task /SCWM/ORDIM_C TANUM
TAPOS Warehouse Task Item /SCWM/ORDIM_C TAPOS
FLGHUTO Handling Unit Warehouse Task /SCWM/ORDIM_C FLGHUTO
PROCTY Warehouse Process Type /SCWM/ORDIM_C PROCTY
TRART Warehouse Process Category /SCWM/ORDIM_C TRART
PRCES Storage Process /SCWM/ORDIM_C PRCES
PROCS External Storage Process Step /SCWM/ORDIM_C PROCS
TOSTAT Warehouse Task Status /SCWM/ORDIM_C TOSTAT
CREATED_BY Created By /SCWM/ORDIM_C CREATED_BY
CREATED_AT Created at /SCWM/ORDIM_C CREATED_AT
CREATED_DATE Created On    
CREATED_TIME Created At    
REASON Reason for Movements in the Warehouse /SCWM/ORDIM_C REASON
PRIORITY Priority /SCWM/ORDIM_C PRIORITY
MATNR Product /SCWM/ORDIM_C MATNR
CHARG Batch Number /SCWM/ORDIM_C CHARG
CAT Stock Type /SCWM/ORDIM_C CAT
STOCK_DOCCAT Type Sales Order Stock or Project Stock /SCWM/ORDIM_C STOCK_DOCCAT
STOCK_DOCNO Number of the Sales Order or Project for Special Stock /SCWM/ORDIM_C STOCK_DOCNO
STOCK_ITMNO Sales Order Item for Sales Order Stock /SCWM/ORDIM_C STOCK_ITMNO
DOCCAT Doc. Category for Doc. Reference and Doc.-Related Stocks /SCWM/ORDIM_C DOCCAT
STOCK_USAGE Stock Usage /SCWM/ORDIM_C STOCK_USAGE
OWNER Owner /SCWM/ORDIM_C OWNER
ENTITLED Party Entitled to Dispose /SCWM/ORDIM_C ENTITLED
MEINS Base unit of measure /SCWM/ORDIM_C MEINS
ALTME Alternative Unit of Measure for Stockkeeping Unit /SCWM/ORDIM_C ALTME
VSOLM Target Quantity in Base Unit of Measure /SCWM/ORDIM_C VSOLM
VSOLA Target Quantity in Alternative Unit of Measure /SCWM/ORDIM_C VSOLA
KQUAN Retention Quantity /SCWM/ORDIM_C KQUAN
LETYP Handling Unit Type /SCWM/ORDIM_C LETYP
WEIGHT Loading/Net Weight /SCWM/ORDIM_C WEIGHT
UNIT_W Weight Unit /SCWM/ORDIM_C UNIT_W
VOLUM Loading/Net Volume /SCWM/ORDIM_C VOLUM
UNIT_V Volume Unit /SCWM/ORDIM_C UNIT_V
CAPA Capacity Consumption /SCWM/ORDIM_C CAPA
VFDAT_TS Shelf Life Expiration Date or Best-Before Date  
VFDAT Shelf Life Expiration Date /SCWM/ORDIM_C VFDAT
WDATU Date of Goods Receipt /SCWM/ORDIM_C WDATU
WDATU_DATE Date of Goods Receipt  
WDATU_TIME Goods Receipt Time  
COO Country of Origin /SCWM/ORDIM_C COO
HAZMAT Hazardous Substance /SCWM/ORDIM_C HAZMAT
INSPTYP Inspection Type /SCWM/ORDIM_C INSPTYP
INSPDOCNO QIE Entity: External Identification /SCWM/ORDIM_C INSPDOCNO
IDPLATE Identification Number of Stock /SCWM/ORDIM_C IDPLATE
VLTYP Source Storage Type /SCWM/ORDIM_C VLTYP
VLBER Source Storage Section /SCWM/ORDIM_C VLBER
VLPLA Source Storage Bin /SCWM/ORDIM_C VLPLA
VPTYP Source Bin Type /SCWM/LAGP LPTYP
SRSRC Resource (Means of Transportation or User) /SCWM/ORDIM_C SRSRC
STU_NUM Source Transportation Unit (Internal) /SCWM/ORDIM_C STU_NUM
VLENR Source Handling Unit /SCWM/ORDIM_C VLENR
NLTYP Destination Storage Type /SCWM/ORDIM_C NLTYP
NLBER Destination Storage Section /SCWM/ORDIM_C NLBER
NLPLA Destination Storage Bin /SCWM/ORDIM_C NLPLA
NPTYP Destination Bin Type /SCWM/LAGP LPTYP
DRSRC Resource (Means of Transportation or User) /SCWM/ORDIM_C DRSRC
DTU_NUM Destination Transportation Unit (Internal) /SCWM/ORDIM_C DTU_NUM
NLENR Destination Handling Unit /SCWM/ORDIM_C NLENR
KZSUB Indicator: Pass on Warehouse Task to Subsystem /SCWM/ORDIM_C KZSUB
SOLPO Planned Proc. Time in Warehouse Task /SCWM/ORDIM_C SOLPO
ZEIEI Time Unit for Processing Time Determination /SCWM/ORDIM_C ZEIEI
VAS Indicator: WT with Reference to a VAS /SCWM/ORDIM_C VAS
RDOCCAT Doc. Category for Doc. Reference and Doc.-Related Stocks /SCWM/ORDIM_C RDOCCAT
RDOCNO Document Number of Document Reference /SCWM/ORDIM_C RDOCNO
RITMNO Document Item of Document Reference /SCWM/ORDIM_C RITMNO
WAVE Wave /SCWM/ORDIM_C WAVE
WAVE_ITEM Wave Item /SCWM/ORDIM_C WAVE_ITEM
QDOCCAT Doc. Category for Doc. Reference and Doc.-Related Stocks /SCWM/ORDIM_C QDOCCAT
QDOCNO Document Number for Stock Reference /SCWM/ORDIM_C QDOCNO
QITMNO Item Number of Stock Reference /SCWM/ORDIM_C QITMNO
QIDPLATE Identification Number of Stock /SCWM/ORDIM_C QIDPLATE
CONFIRMED_BY Confirmed by /SCWM/ORDIM_C CONFIRMED_BY
CONFIRMED_AT Time of Confirmation /SCWM/ORDIM_C CONFIRMED_AT
CONFIRMED_DATE Confirmation Date    
CONFIRMED_TIME Confirmation Time    
EXCCODE Exception Code /SCWM/ORDIM_C EXCCODE
BUSCON Business Context /SCWM/ORDIM_C BUSCON
EXEC_STEP Execution Step in Business Context /SCWM/ORDIM_C EXEC_STEP
STARTED_AT Start Time /SCWM/ORDIM_C STARTED_AT
STARTED_DATE Start Date    
STARTED_TIME Start Time    
NISTM Actual Quantity in Base Unit of Measure /SCWM/ORDIM_C NISTM
NISTA Actual Quantity in Alternative Unit of Measure /SCWM/ORDIM_C NISTA
PLACE_INV Inventory on Putaway Performed /SCWM/ORDIM_C PLACE_INV
LOWCHK_INV Low Stock Check Executed /SCWM/ORDIM_C LOWCHK_INV
HUENT Indicator: Handling unit will be withdrawn completely /SCWM/ORDIM_C HUENT
SLGNUM_VIEW Warehouse Number View for Global Stocks /SCWM/ORDIM_C SLGNUM_VIEW
DLGNUM_VIEW Warehouse Number View for Global Stocks /SCWM/ORDIM_C DLGNUM_VIEW
DMENG Quantity of Difference Posting in Stock Keeping Unit /SCWM/ORDIM_C DMENG
DMENA Difference quantity in alternate unit of measure /SCWM/ORDIM_C DMENA
WHO Warehouse Order Number /SCWM/ORDIM_C WHO
AAREA Activity Area /SCWM/ORDIM_C AAREA
QUEUE Queue /SCWM/ORDIM_C QUEUE
ROCANCEL Indicator: Cancel Data Record    
CWQUAN Valuation Quantity /SCWM/ORDIM_C CWQUAN
CWQUAN_DIFF Valuation Quantity /SCWM/ORDIM_C CWQUAN_DIFF
CWUNIT Unit for Valuation Quantity /SCWM/ORDIM_C CWUNIT
PROCESS Storage Process Step    
COUNTER Index of Internal Tables /SCWM/ORDIM_C COUNTER
VLPLA_MAIN Source Storage Bin    
NLPLA_MAIN Destination Storage Bin    
PROCESSOR Processor /SCWM/ORDIM_C PROCESSOR
FULL_PALLET Indicator for Full Pallet Withdrawal    
MATKL Material Group /SAPAPO/MATKEY MATKL
VST_ROLE Source Storage Type Role /SCWM/T331 ST_ROLE
NST_ROLE Target Storage Type Role /SCWM/T331 ST_ROLE

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

CREATED_DATE

Determined by extractor, given in warehouse time zone.

CREATED_TIME

Determined by extractor, given in warehouse time zone.

VFDAT_TS

Determined by extractor.

WDATU_DATE

Determined by extractor, given in warehouse time zone.

WDATU_TIME

Determined by extractor, given in warehouse time zone.

CONFIRMED_DATE

Determined by extractor, given in warehouse time zone.

CONFIRMED_TIME

Determined by extractor, given in warehouse time zone.

STARTED_DATE

Determined by extractor, given in warehouse time zone.

STARTED_TIME

Determined by extractor, given in warehouse time zone.

ROCANCEL

Determined by extractor: Indicator: Cancel Data Record.

ROCANCEL is never set since warehouse tasks cannot be deleted after confirmation or cancellation.

PROCESS

Determined by the extractor for the warehouse task, which executes mapping for the PROCESS field as indicated in the table below.

VLPLA_MAIN

Determined by extractor for source bin.

NLPLA_MAIN

Determined by extractor for destination bin.

FULL_PALLET

Determined by extractor in BAdI, Indicator Setting for Full Pallet Withdrawal: /SCWM/EX_BW_FILTER_FULL_PALLET. This BAdI provides a fallback class default implementation that sets the Indicator for Full Pallet Withdrawal to X when either the indicator Handling Unit Will Be Withdrawn Completely is set or when Alternative Unit of Measure is PAL.

You can use this BAdI from Enhancement Spot /SCWM/ES_BW to implement your own logic for Indicator for Full Pallet Withdrawal.

Field Determination by the Extractor: Mapping of Field for Process

Process

Internal Process Step / Warehouse Process Catagory

Value

Cross-Docking

CD

CD

Count

CNT

CNT

Correction for EWL

CORR

CORR

Indirect Labor

INDL

INDL

Physical Inventory

INVE

INVE

Load

LOAD

LOAD

Movement w/o Stor. Control

NSCT

NSCT

Pack

PAC

PAC

Remove from Stock

PICK

PICK

Put Away

PUT

PUT

Quality Inspection

QIS

QIS

Deconsolidate

SPR

SPR

Stage

STAG

STAG

Unload

UNLO

UNLO

Value-Added Service

VAS

VAS

Posting Changes

7

POCH