I_EWM_WhseTaskItemCube

Warehouse Task Item - Cube | view: IEWMWTITEMC | TRAN | Extraction: Not supported | Component: Warehouse Order Processing
Tables used: /SCWM/ORDIM_C, /SCDL/DB_TRANS, /SCDL/DB_PROCH_I, /SCDL/DB_PROCI_I, /SCWM/ORDIM_O, /SCDL/DB_PROCH_O, /SCDL/DB_PROCI_O, /SCWM/DB_ITEMSPL, /SCWM/WHO, /SCWM/WAVEHDR, MARA, BUT000, /SCWM/RSRC, /SCWM/LAGP, /SCWM/T333A, /SCMB/TOENTITY, TTZZT, /SCWM/WV_TMPLT, /SCWM/WV_TMPLTT, MARA, MAKT, PRPS, /SCWM/T300_MD, /SCWM/T340D
Column Name Description
Warehouse FK Warehouse Number/Warehouse Complex
WarehouseTask null
WarehouseTaskItem null
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
WhseTaskRetentionQuantity Retention Quantity
TargetQuantityInBaseUnit Target Quantity in Base Unit of Measure
ActualQuantityInBaseUnit null
DifferenceQuantityInBaseUnit null
📏 Weight Unit (WhseTaskNetWeightUnitOfMeasure):
WhseTaskNetWeight Loading or Net Weight
📏 Volume Unit (WhseTaskNetVolumeUnitOfMeasure):
WhseTaskNetVolume Loading or Net Volume
📏 Volume Unit (DisplayVolumeUnit):
ItemNetVolumeInDisplayUnit null
📏 Weight Unit (DisplayWeightUnit):
ItemNetWeightInDisplayUnit null
📏 Time Unit (WhseTaskProcgTimeDetnTimeUnit):
WhseTaskPlannedProcessingTime Planned Proc. Time in Warehouse Task
📏 Alternative Unit of Measure for Stockkeeping Unit (AlternativeUnit):
TargetQuantityInAltvUnit Target Quantity in Alternative Unit of Measure
ActualQuantityInAltvUnit null
DifferenceQuantityInAltvUnit null
Column Name Description
ShelfLifeExpirationDate Shelf Life Expiration Date
WhseTaskCrtnWhseTmznDate null
WhseTaskCrtnWhseTmznTime null
WhseTaskConfWhseTmznDate null
WhseTaskConfWhseTmznTime null
WhseTskPlndClsgWhseTmznDate null
WhseTskPlndClsgWhseTmznTime null
WaveActualReldWhseTmznDate null
WaveActualReldWhseTmznTime null
Column Name Description
IsHandlingUnitWarehouseTask Handling Unit Warehouse Task Show values
WarehouseTaskStatus Warehouse Task Status Show values
WarehouseTaskCodes Calling Application/Special Function for WT Creation/Conf. Show values
StockDocumentCategory Type: Sales Order Stock or Project Stock Show values
DocumentCategory Doc. Category for Doc. Reference and Doc.-Related Stock Show values
StockOwnerPartnerRole Partner Role of Owner Show values
EntitledToDisposePartnerRole Partner Role of Party Entitled to Dispose Show values
PutAwayPhysInventoryIsPlanned Truth Value: True/False Show values
WhseTaskLowStockCheckIsPlanned Truth Value: True/False Show values
HazardousSubstanceIndicator Hazardous Substance Show values
WhseTaskQualityInspectionType Inspection ID Type Show values
SourceLocationType Location Type Show values
DestinationLocationType Location Type Show values
WhseTaskDestStorageBinDtmndBy Destination Storage Bin Determined By Show values
WrhsTaskSubsystemTransmn Indicator: Pass on Warehouse Task to Subsystem Show values
WhseTaskRefToValueAddedService WT with Reference to a VAS Show values
BatchChangeIsNotAllowed Changing the Batch is not Allowed Show values
ReferenceDocumentCategory Doc. Category for Doc. Reference and Doc.-Related Stock Show values
WhseTaskTwoStepPickingType Warehouse Task Type Within Two-Step Picking Show values
WhseTaskTwoStepPickingRlvnce Relevance for Two-Step Picking Show values
DocumentReltdStockDocCat Doc. Category for Doc. Reference and Doc.-Related Stock Show values
KitItemIsCreatedAutomatically Create Kit Item in HU Automatically During Picking Show values
IsDocumentaryBatch Truth Value: True/False Show values
WarehouseOrderStatus Warehouse Order Status Show values
WarehouseOrderIsSplit Warehouse Order Was Split Show values
Column Name Description Domain name
NumberOfWarehouseTasks null
NumberOfWarehouseTaskItems null
WarehouseProcessType Warehouse Process Type /SCWM/DO_PROCTY
WarehouseProcessCategory Warehouse Process Category /SCWM/LVS_TRART
StorageProcess Storage Process /SCWM/DO_PRCES
ExternalStorageProcessStep External Storage Process Step /SCWM/DO_PROCS
CreatedByUser Created By UNAME
WhseTaskCrtnUTCDateTime Creation Time TZNTSTMPS
ExecutingResource Executing Resource (Means of Transport or User) /SCWM/DO_RSRC
WarehouseMovementsReason Reason for Movements in the Warehouse /SCWM/DO_REASON
PriorityCode null
StockItemUUID GUID Stock Item
CurrentNumberOfKeyTable Current Nummer of Key Table
ProductUUID Product /SCMB/MDL_MATID_CE
ProductName Product Number MATNR
ProductDescription Product Description TEXT40
ProductBatch Batch /SCWM/DO_BATCHID
StockType Stock Type /LIME/STOCK_CATEGORY
StockDocumentNumber null
StockItemNumber null
StockUsage Stock Usage /LIME/STOCK_USAGE
StockOwner Owner /SCMB/DO_BU_PARTNER
EntitledToDisposeParty Party Entitled to Dispose BU_PARTNER
IsBusinessPurposeCompleted null
CounterForStockSeparation Counter for Stock Separation
Batch Batch /SCWM/DO_CHARG
WhseTaskCapacityConsumption Capacity Consumption /SCWM/DO_DEC15
CountryOfOrigin Country/Region of Origin LAND1
QualityInspectionDocUUID Identification of a Quality Object
StockIdentificationOfWhseTask Stock Identification of Warehouse Task
ConsolidationGroup Consolidation Group
SourceHndlgUnitLogicalPosition Source Logical Position of Handling Unit in Storage Bin
SourceResource Source Resource (Means of Transport or User) /SCWM/DO_RSRC
SourceTransportationUnit Source Transportation Unit (Internal) /SCWM/DO_TU_NUM
SourceHandlingUnitUUID Unique Internal Identification of a Handling Unit
SourceHandlingUnit null
DestHndlgUnitLogicalPosition Destination Logical Position of Handling Unit in Storage Bin
DestinationResource Destination Resource (Means of Transport or User) /SCWM/DO_RSRC
DestinationTransportationUnit Destination Transportation Unit (Internal) /SCWM/DO_TU_NUM
DestinationHandlingUnitUUID Unique Internal Identification of a Handling Unit
ReferenceDocumentUUID Doc. Identification for Document-Related Stocks /SCWM/DO_DOCID
ReferenceDocumentItemUUID Document Item for Document-Related Stocks
EWMReferenceDeliveryDocType Document Type /SCDL/DL_DOCTYPE
ReferenceDocumentNumber Document Number /SCDL/DL_DOCNO_INT
ReferenceDocumentItemNumber null
Wave Numeric Character Field, Length 10 NUMC10
WaveItem null
DocumentReltdStockDocUUID Doc. Identification for Document-Related Stocks /SCWM/DO_DOCID
DocumentReltdStockDocItemUUID Document Item for Document-Related Stocks
StockIdentificationNumber Identification Number of Stock
WarehouseTaskUUID Unique Internal Identification of a Warehouse Task
ConveyorTechniqueSegment Conveyor Technique Segment /SCWM/DO_MFSCS
ProductionSupplyArea Production Supply Area /SCWM/DO_PSA
ProductionOrder null
WhseTaskCrtnWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseTaskCrtnWhseTmznYear null
WhseTaskCrtnWhseTmznMonth null
WhseTaskCrtnWhseTmznHour null
WhseTaskCrtnRnddTo10MinsTime null
WhseTaskConfWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseTaskConfWhseTmznYear null
WhseTaskConfWhseTmznMonth null
WhseTaskConfWhseTmznHour null
WhseTaskConfRnddTo10MinsTime null
WhseTskPlndClsgWhseTmznDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseTskPlndClsgWhseTmznYear null
WhseTskPlndClsgWhseTmznMonth null
WhseTskPlndClsgWhseTmznHour null
WhseTskPlndClsgRnddTo10MinsTme null
Kanban Unique Kanban ID /SCMB/DM_KANBAN_ID
ActivityArea Activity Area /SCWM/DO_AAREA
WarehouseOrder Warehouse Order Number /SCWM/DO_WHO_CONV_ALPHA
LogicalRecordProgramName Table Log Record: Program Name PROGRAMM
LogicalRecordTransactionCode Table Log Record: Transaction Code TCODE
EWMDummyFuncForStructureExtn Dummy function in length 1 DUMMY
CertificateText Certificate Number /SCWM/LVS_ZEUGN
WhseTaskLastChgUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Activity Activity /SCWM/DO_ACTTY
ConfirmedByUser null
WhseTaskConfUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Processor null
WarehouseTaskExceptionCode null
BusinessContext null
BusinessContextExecutionStep null
ExecutingResourceGroup null
ExecutingResourceType null
LatestStartUTCDateTime Latest Starting Date (LSD) TZNTSTMPS
HigherLevelWarehouseOrder Warehouse Order Number of Higher-Level Warehouse Order /SCWM/DO_WHO_CONV_ALPHA
WrhsOrdStrtUTCDateTime Start Time TZNTSTMPS
WarehouseOrderQueue Queue /SCWM/DO_QUEUE
WrhsOrdCrtnUTCDateTime Creation Time TZNTSTMPS
PickCompltnUTCDateTime Planned Closing Date/Time TZNTSTMPS
SourceStorageBinAisle Storage Bin Aisle /SCWM/DO_AISLE
SourceStorageBinStack Storage Bin Stack /SCWM/DO_STACK
SourceStorageBinLevel Storage Bin Level /SCWM/DO_LEVEL
DestinationStorageBinAisle Storage Bin Aisle /SCWM/DO_AISLE
DestinationStorageBinStack Storage Bin Stack /SCWM/DO_STACK
DestinationStorageBinLevel Storage Bin Level /SCWM/DO_LEVEL
OutboundDeliveryOrder null
OutboundDeliveryOrderItem null
OutboundDeliveryOrderItemType Item Type /SCDL/DL_ITEMTYPE
OutbDeliveryOrderItemCategory Item Category /SCDL/DL_ITEMCAT
InboundDeliveryItemType Item Type /SCDL/DL_ITEMTYPE
PlndPickCompltnUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndPackCompletionUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndStagingCompltnUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndLoadCompletionUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WaveActlReleasedUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WaveCutoffWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WavePlndRelWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndPickCmpltWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndPackCmpltWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndStggCmpltWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WaveCompletionWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WaveActualReldWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WaveActualReldWhseTmznYear null
WaveActualReldWhseTmznMonth null
WaveActualReldWhseTmznHour null
WaveTemplate Numeric Character Field, Length 10 NUMC10
WaveTemplateName Description /SCWM/DO_DESC40
WarehouseTaskStatusName Short Text for Fixed Values DDTEXT
WarehouseTaskCodesName Short Text for Fixed Values DDTEXT
WarehouseOrderStatusName Short Text for Fixed Values DDTEXT
WrhsTaskSubsystemTransmnName Short Text for Fixed Values DDTEXT
WhseTaskOverdueHours null
WhseTaskOverdueHoursDesc null
EWMWhseTaskConfDateIsToday Confirmation Date of Warehouse Task Is Today CHAR1
EWMWhseTaskHasException Warehouse Task Has Exceptions CHAR1
Master Data Relations Join Conditions
Destination Storage Bin
  • Destination Storage Bin
  • Warehouse Number/Warehouse Complex
  • Client
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGEBIN == /SCWM/LAGP.LGPLA
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/LAGP.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/LAGP.MANDT
Bin Access Type
  • Bin Access Type
  • Bin Access Type
  • Warehouse Number/Warehouse Complex
  • Client
Storage Bin Type
  • Storage Bin Type
  • Storage Bin Type
  • Warehouse Number/Warehouse Complex
  • Client
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGEBINTYPE == /SCWM/T303.LPTYP
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGEBINTYPE == /SCWM/T303.LPTYP
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T303.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/T303.MANDT
Destination Storage Section
  • Destination Storage Type
  • Warehouse Number/Warehouse Complex
  • Client
  • Destination Storage Section
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGETYPE == /SCWM/T302.LGTYP
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T302.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/T302.MANDT
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGESECTION == /SCWM/T302.LGBER
Destination Storage Type
  • Destination Storage Type
  • Warehouse Number/Warehouse Complex
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGETYPE == /SCWM/T301.LGNUM
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T301.MANDT
Volume Unit
  • Client
  • Volume Unit
  • I_EWM_WHSETASKITEMCUBE.MANDT == T006.MANDT
  • I_EWM_WHSETASKITEMCUBE.DISPLAYVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_EWM_WHSETASKITEMCUBE.MANDT == T006.MANDT
  • I_EWM_WHSETASKITEMCUBE.DISPLAYWEIGHTUNIT == T006.MSEHI
Source Storage Bin
  • Source Storage Bin
  • Warehouse Number/Warehouse Complex
  • Client
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGEBIN == /SCWM/LAGP.LGPLA
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/LAGP.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/LAGP.MANDT
Bin Access Type
  • Bin Access Type
  • Bin Access Type
  • Warehouse Number/Warehouse Complex
  • Client
Storage Bin Type
  • Storage Bin Type
  • Storage Bin Type
  • Warehouse Number/Warehouse Complex
  • Client
  • I_EWM_WHSETASKITEMCUBE.DESTINATIONSTORAGEBINTYPE == /SCWM/T303.LPTYP
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGEBINTYPE == /SCWM/T303.LPTYP
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T303.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/T303.MANDT
Source Storage Section
  • Warehouse Number/Warehouse Complex
  • Client
  • Source Storage Section
  • Source Storage Type
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T302.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/T302.MANDT
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGESECTION == /SCWM/T302.LGBER
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGETYPE == /SCWM/T302.LGTYP
Source Storage Type
  • Warehouse Number/Warehouse Complex
  • Source Storage Type
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/T301.MANDT
  • I_EWM_WHSETASKITEMCUBE.SOURCESTORAGETYPE == /SCWM/T301.LGNUM
Warehouse Order Creation Rule
  • Warehouse Number/Warehouse Complex
  • Client
  • Warehouse Order Creation Rule
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSE == /SCWM/TWCR.LGNUM
  • I_EWM_WHSETASKITEMCUBE.MANDT == /SCWM/TWCR.MANDT
  • I_EWM_WHSETASKITEMCUBE.WAREHOUSEORDERCREATIONRULE == /SCWM/TWCR.WCR