I_EWM_WhseOrderCube

Warehouse Order - Cube | view: IEWMWOC | TRAN | Extraction: Not supported | Component: Warehouse Order Processing
Tables used: /SCWM/WHO, /SCWM/WAVEHDR, /SCWM/WV_TMPLT, /SCWM/WV_TMPLTT
Column Name Description
Warehouse FK Warehouse Number/Warehouse Complex
WarehouseOrder Warehouse Order Number
Column Name Description
Column Name Description
📏 Warehouse Order: Time Unit (WhseOrderPlanDurationTimeUnit):
WarehouseOrderPlannedDuration Planned Execution Time of Warehouse Order
Column Name Description
WhseOrderCrtnWhseTmznDate null
WhseOrderCrtnWhseTmznTime null
WhseOrdLtstStrtWhseTmznDate null
WhseOrdLtstStrtWhseTmznTime null
WhseOrderConfWhseTmznDate null
WhseOrderConfWhseTmznTime null
WaveActualReldWhseTmznDate null
WaveActualReldWhseTmznTime null
Column Name Description
WhseOrderCreationRuleCategory Category of Warehouse Order Creation Rule Show values
WarehouseOrderStatus Warehouse Order Status Show values
WarehouseOrderStartTimeIsFixed Warehouse Order Start Time Fixed Show values
ProcessorIsManualAssigned Manual Assignment of Processor Show values
WarehouseOrderHasPhysInvtryDoc WO Contains Physical Inventory Document Show values
WarehouseOrderIsSplit Warehouse Order Was Split Show values
WhseOrderHasSubsqntWhseOrder WO Contains Warehouse Order Show values
WarehouseOrderHasWhseTask Warehouse Order Contains Warehouse Task Show values
HzdsSubstanceIsRlvtForStorage Hazardous Substance Relevant for Storage Show values
Column Name Description Domain name
NumberOfWarehouseOrders null
Wave Warehouse Order Number /SCWM/DO_WHO_CONV_ALPHA
WarehouseOrderStatusName Short Text for Fixed Values DDTEXT
ActivityArea Activity Area /SCWM/DO_AAREA
StorageBin Storage Bin /SCWM/LGPLA
WrhsOrdCrtnUTCDateTime Creation Time TZNTSTMPS
CreatedByUser Created By UNAME
WarehouseOrderQueue Queue /SCWM/DO_QUEUE
WrhsOrdStrtUTCDateTime Start Time TZNTSTMPS
WhseOrderConfUTCDateTime Time of Confirmation TZNTSTMPS
WarehouseOrderConfirmedBy Confirmed By UNAME
Processor Processor /SCWM/DO_PROCESSOR_CONV_ALPHA
ExecutingResource Resource (Means of Transportation or User)
WhseOrderForSplitWhseOrder Warehouse Order Number of WO That Was Split /SCWM/DO_WHO_CONV_ALPHA
LatestStartUTCDateTime Latest Starting Date (LSD) TZNTSTMPS
WhseOrderLastChgUTCDateTime Time of Change TZNTSTMPS
LastChangedByUser Changed By UNAME
WhseOrderHigherLevelWhseOrder Warehouse Order Number of Higher-Level Warehouse Order /SCWM/DO_WHO_CONV_ALPHA
WhseOrderSubsequentWhseOrder Warehouse Order Number of Subsequent Warehouse Order /SCWM/DO_WHO_CONV_ALPHA
WhseOrderCrtnWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseOrderCrtnWhseTmznYear null
WhseOrderCrtnWhseTmznMonth null
WhseOrderCrtnWhseTmznHour null
WhseOrderCrtnRnddTo10MinsTime null
WhseOrdLtstStrtWhseTmznDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseOrdLtstStrtWhseTmznYear null
WhseOrdLtstStrtWhseTmznMonth null
WhseOrdLtstStrtWhseTmznHour null
WhseOrdLtstStrtRnddTo10MinsTme null
WhseOrderConfWhseTmznDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WhseOrderConfWhseTmznYear null
WhseOrderConfWhseTmznMonth null
WhseOrderConfWhseTmznHour null
WhseOrderConfRnddTo10MinsTime null
WhseOrderOverdueHours null
WaveItem null
PlndLoadCompletionUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndPackCompletionUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndPickCompltnUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndStagingCompltnUTCDateTime 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
Master Data Relations Join Conditions
Starting Point for Processing Resource
  • Client
  • Warehouse Number/Warehouse Complex
  • Starting Point for Processing Resource
  • I_EWM_WHSEORDERCUBE.MANDT == /SCWM/LAGP.MANDT
  • I_EWM_WHSEORDERCUBE.WAREHOUSE == /SCWM/LAGP.LGNUM
  • I_EWM_WHSEORDERCUBE.RESOURCESTARTBIN == /SCWM/LAGP.LGPLA
Storage Type
  • Storage Type
  • Warehouse Number/Warehouse Complex
  • I_EWM_WHSEORDERCUBE.STORAGETYPE == /SCWM/T301.LGNUM
  • I_EWM_WHSEORDERCUBE.WAREHOUSE == /SCWM/T301.MANDT
Warehouse Number I_EWM_WHSEORDERCUBE.WAREHOUSE == /SCWM/T300.MANDT
Warehouse Order Creation Rule
  • Client
  • Warehouse Order Creation Rule
  • Warehouse Number/Warehouse Complex
  • I_EWM_WHSEORDERCUBE.MANDT == /SCWM/TWCR.MANDT
  • I_EWM_WHSEORDERCUBE.WAREHOUSEORDERCREATIONRULE == /SCWM/TWCR.WCR
  • I_EWM_WHSEORDERCUBE.WAREHOUSE == /SCWM/TWCR.LGNUM
Document Header Warehouse Process Type
  • Client
  • Document Header Warehouse Process Type
  • Warehouse Number/Warehouse Complex
  • I_EWM_WHSEORDERCUBE.MANDT == /SCWM/T333.MANDT
  • I_EWM_WHSEORDERCUBE.WHSEPROCESSTYPEDOCUMENTHDR == /SCWM/T333.PROCTY
  • I_EWM_WHSEORDERCUBE.WAREHOUSE == /SCWM/T333.LGNUM