I_EWM_WhseOrderCube_2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EWM_WhseOrderCube_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EWM_WhseOrderCube_2 AS
SELECT
  EWMWarehouse,
  WarehouseOrder,
  1.0 AS NumberOfWarehouseOrders,
  WarehouseOrderCreationRule,
  WhseOrderCreationRuleCategory,
  WhseProcessTypeDocumentHdr,
  Wave,
  WarehouseOrderStatus,
  _WarehouseOrderStatusText[1:Language = $parameters.P_Language].WarehouseOrderStatusName AS WarehouseOrderStatusName,
  ActivityArea,
  EWMStorageType,
  EWMStorageBin,
  WrhsOrdCrtnUTCDateTime,
  CreatedByUser,
  Queue AS WarehouseOrderQueue,
  WarehouseOrderStartDateTime AS WrhsOrdStrtUTCDateTime,
  WarehouseOrderStartTimeIsFixed,
  WhseOrderConfirmedDateTime AS WhseOrderConfUTCDateTime,
  WarehouseOrderConfirmedBy,
  Processor,
  ExecutingResource,
  ProcessorIsManualAssigned,
  WarehouseOrderHasPhysInvtryDoc,
  WhseOrderForSplitWhseOrder,
  WarehouseOrderIsSplit,
  ResourceStartBin,
  WhseOrderLatestStartDateTime AS LatestStartUTCDateTime,
  WarehouseOrderPlannedDuration,
  WhseOrderPlanDurationTimeUnit,
  WhseOrderLastChgUTCDateTime,
  LastChangedByUser,
  WhseOrderHigherLevelWhseOrder,
  WhseOrderSubsequentWhseOrder,
  WhseOrderHasSubsqntWhseOrder,
  WarehouseOrderHasWhseTask,
  HzdsSubstanceIsRlvtForStorage,
  WhseOrderCrtnWhseTmznDateTime,
  cast(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 1, 4) as abap.numc( 4 ) ) AS WhseOrderCrtnWhseTmznYear,
  cast(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 1, 6) as abap.numc( 6 ) ) AS WhseOrderCrtnWhseTmznMonth,
  cast(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrderCrtnWhseTmznDate,
  cast(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 1, 10) as abap.numc( 10 ) ) AS WhseOrderCrtnWhseTmznHour,
  cast(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 9, 6) as abap.tims) AS WhseOrderCrtnWhseTmznTime,
  cast(concat(substring(cast(WhseOrderCrtnWhseTmznDateTime as abap.char( 17 )), 9, 3),'000') as abap.tims) AS WhseOrderCrtnRnddTo10MinsTime,
  WhseOrdLtstStrtWhseTmznDteTme,
  cast(substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 1, 4) as abap.numc( 4 ) ) AS WhseOrdLtstStrtWhseTmznYear,
  cast(substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 1, 6) as abap.numc( 6 ) ) AS WhseOrdLtstStrtWhseTmznMonth,
  cast(substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrdLtstStrtWhseTmznDate,
  cast(substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 1, 10) as abap.numc( 10 ) ) AS WhseOrdLtstStrtWhseTmznHour,
  cast(substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 9, 6) as abap.tims) AS WhseOrdLtstStrtWhseTmznTime,
  cast(concat( substring(cast(WhseOrdLtstStrtWhseTmznDteTme as abap.char( 17 )), 9, 3), '000') as abap.tims) AS WhseOrdLtstStrtRnddTo10MinsTme,
  WhseOrderConfWhseTmznDateTime,
  cast(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 1, 4) as abap.numc( 4 ) ) AS WhseOrderConfWhseTmznYear,
  cast(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 1, 6) as abap.numc( 6 ) ) AS WhseOrderConfWhseTmznMonth,
  cast(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrderConfWhseTmznDate,
  cast(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 1, 10) as abap.numc( 10 ) ) AS WhseOrderConfWhseTmznHour,
  cast(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 9, 6) as abap.tims) AS WhseOrderConfWhseTmznTime,
  cast(concat(substring(cast(WhseOrderConfWhseTmznDateTime as abap.char( 17 )), 9, 3),'000') as abap.tims) AS WhseOrderConfRnddTo10MinsTime,
  '000000' AS WaveItem,
  _Wave.PlndLoadCompletionUTCDateTime AS PlndLoadCompletionUTCDateTime,
  _Wave.PlndPackCompletionUTCDateTime AS PlndPackCompletionUTCDateTime,
  _Wave.PlndPickCompltnUTCDateTime AS PlndPickCompltnUTCDateTime,
  _Wave.PlndStagingCompltnUTCDateTime AS PlndStagingCompltnUTCDateTime,
  _Wave.WaveActlReleasedUTCDateTime AS WaveActlReleasedUTCDateTime,
  _Wave.WaveCutoffWhseTmznDateTime AS WaveCutoffWhseTmznDateTime,
  _Wave.WavePlndRelWhseTmznDateTime AS WavePlndRelWhseTmznDateTime,
  _Wave.PlndPickCmpltWhseTmznDateTime AS PlndPickCmpltWhseTmznDateTime,
  _Wave.PlndPackCmpltWhseTmznDateTime AS PlndPackCmpltWhseTmznDateTime,
  _Wave.PlndStggCmpltWhseTmznDateTime AS PlndStggCmpltWhseTmznDateTime,
  _Wave.WaveCompletionWhseTmznDateTime AS WaveCompletionWhseTmznDateTime,
  _Wave.WaveActualReldWhseTmznDateTime AS WaveActualReldWhseTmznDateTime,
  cast(substring(cast(_Wave.WaveActualReldWhseTmznDateTime as abap.char( 17 )), 1, 4) as abap.numc( 4 ) ) AS WaveActualReldWhseTmznYear,
  cast(substring(cast(_Wave.WaveActualReldWhseTmznDateTime as abap.char( 17 )), 1, 6) as abap.numc( 6 ) ) AS WaveActualReldWhseTmznMonth,
  cast(substring(cast(_Wave.WaveActualReldWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WaveActualReldWhseTmznDate,
  cast(substring(cast(_Wave.WaveActualReldWhseTmznDateTime as abap.char( 17 )), 1, 10) as abap.numc( 10 ) ) AS WaveActualReldWhseTmznHour,
  cast(substring(cast(_Wave.WaveActualReldWhseTmznDateTime as abap.char( 17 )), 9, 6) as abap.tims) AS WaveActualReldWhseTmznTime,
  _Wave._WaveTmpl.WaveTemplate AS WaveTemplate,
  _Wave._WaveTmpl._Text[1:Language = $parameters.P_Language].WaveTemplateName AS WaveTemplateName
FROM P_EWM_WarehouseOrder_2
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseOrderStatusText AS _WarehouseOrderStatusText ON WarehouseOrderStatus = _WarehouseOrderStatusText.WarehouseOrderStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseOrderCtnRule_2 AS _WhseOrderCtnRule ON WarehouseOrderCreationRule = _WhseOrderCtnRule.WarehouseOrderCreationRule AND EWMWarehouse = _WhseOrderCtnRule.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_ActivityArea_2 AS _ActivityArea ON ActivityArea = _ActivityArea.ActivityArea AND EWMWarehouse = _ActivityArea.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WaveHeader_2 AS _Wave ON Wave = _Wave.Wave AND EWMWarehouse = _Wave.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseOrderQueue_2 AS _WarehouseOrderQueue ON WarehouseOrderQueue = _WarehouseOrderQueue.WarehouseOrderQueue AND EWMWarehouse = _WarehouseOrderQueue.EWMWarehouse  -- association [0..1]
;