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.
|
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. |
|
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 |