I_EWM_WarehouseWaveC_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_WarehouseWaveC_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_WarehouseWaveC_2 AS
SELECT
  _WaveItem.EWMWarehouse AS EWMWarehouse,
  _WaveItem.Wave AS Wave,
  _WaveItem.WaveItem AS WaveItem,
  1.0 AS NumberOfWaveItems,
  _WaveItem.WarehouseTaskCreationStatus AS WarehouseTaskCreationStatus,
  _WarehouseTaskStatusText[1:Language = $parameters.P_Language].WarehouseTaskStatusName AS WarehouseTaskCreationStsName,
  _WaveItem.ItemWeight AS ItemWeight,
  _WaveItem.ItemWeightUnit AS ItemWeightUnit,
  whseControl.DisplayWeightUnit AS DisplayWeightUnit,
  _WaveItem.ItemVolume AS ItemVolume,
  _WaveItem.ItemVolumeUnit AS ItemVolumeUnit,
  whseControl.DisplayVolumeUnit AS DisplayVolumeUnit,
  _WaveItem.WaveItemConsumedCapacityValue AS WaveItemConsumedCapacityValue,
  _WaveItem.ShipToParty AS ShipToParty,
  _WaveItem.ProductName AS ProductName,
  _Material._Text[1:Language = $parameters.P_Language].ProductName AS ProductDescription,
  _WaveItem.Batch AS Batch,
  _WaveItem.EWMStockOwner AS EWMStockOwner,
  _WaveItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  _WaveItem.ItemQuantity AS ItemQuantity,
  _WaveItem.ItemQuantityUnit AS ItemQuantityUnit,
  _WaveItem.ReferenceDocumentUUID AS ReferenceDocumentUUID,
  _WaveItem.ReferenceDocumentItemUUID AS ReferenceDocumentItemUUID,
  _WaveItem.SplitNumber AS SplitNumber,
  _WaveItem.EWMRefDeliveryDocumentNumber AS EWMRefDeliveryDocumentNumber,
  _WaveItem.EWMRefDeliveryDocumentItem AS EWMRefDeliveryDocumentItem,
  _WaveItem.TwoStepPickingWaveItemCategory AS TwoStepPickingWaveItemCategory,
  _WaveItem.WaveItemErrorStatus AS WaveItemErrorStatus,
  _WaveItem.EWMRoute AS EWMRoute,
  _WaveItem.SalesOrder AS SalesOrder,
  _WaveItem.ActivityArea AS ActivityArea,
  _ActivityArea._Text[1:Language = $parameters.P_Language].ActivityAreaName AS ActivityAreaName,
  _WaveItem.WarehouseProcessType AS WarehouseProcessType,
  _WarehouseProcessType._Text[1:Language = $parameters.P_Language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  _WaveItem.WaveItemSimulationStatus AS WaveItemSimulationStatus,
  _WaveItem.EWMReferenceDocumentCategory AS EWMReferenceDocumentCategory,
  _WaveItem.WaveTemplate AS WaveTemplate,
  _WaveItem._WaveTmpl._Text[1:Language = $parameters.P_Language].WaveTemplateName AS WaveTemplateName,
  _WaveItem.WaveName AS WaveName,
  _WaveItem.WaveType AS WaveType,
  _WaveType._WaveTypeText[1:Language = $parameters.P_Language].WaveTypeName AS WaveTypeName,
  _WaveItem.WaveCategory AS WaveCategory,
  _WaveCategory._WaveCategoryText[1:Language = $parameters.P_Language].WaveCategoryName AS WaveCategoryName,
  _WaveItem.WaveReleaseMethod AS WaveReleaseMethod,
  _WaveReleaseMethodText[1:Language = $parameters.P_Language].WaveReleaseMethodName AS WaveReleaseMethodName,
  _WaveItem.WaveTemplateOption AS WaveTemplateOption,
  _WaveItem.WaveFactoryCalendar AS WaveFactoryCalendar,
  _FactoryCalendar._Text[1:Language = $parameters.P_Language].FactoryCalendarName AS FactoryCalendarName,
  _WaveItem.WhseTskIsRlvtForTwoStpPicking AS WhseTskIsRlvtForTwoStpPicking,
  _WaveItem.WaveWarehouseTaskCreationMode AS WaveWarehouseTaskCreationMode,
  _WarehouseModesText[1:Language = $parameters.P_Language].WaveWhseTaskCrtnModeText AS WaveWhseTaskCrtnModeText,
  _WaveItem.EWMStorageType AS EWMStorageType,
  _StorageType._Text[1:Language = $parameters.P_Language].EWMStorageTypeName AS EWMStorageTypeName,
  _WaveItem.EWMStorageSection AS EWMStorageSection,
  _StorageSection._Text[1:Language = $parameters.P_Language].StorageSectionName AS StorageSectionName,
  _WaveItem.SpclActyCatInWhse AS SpclActyCatInWhse,
  _WhseSpclActyCatText[1:Language = $parameters.P_Language].WhseSpclActyCatText AS WhseSpclActyCatText,
  _WaveItem.EWMWaveReleasedByUser AS EWMWaveReleasedByUser,
  _WaveItem.TwoStepPickingDependency AS TwoStepPickingDependency,
  _WaveItem.MaximumNumberOfWaveItems AS MaximumNumberOfWaveItems,
  _WaveItem.WaveSimulationStatus AS WaveSimulationStatus,
  _WaveItem.WaveCutoffUTCDateTime AS WaveCutoffUTCDateTime,
  _WaveItem.PlndWaveReleaseUTCDateTime AS PlndWaveReleaseUTCDateTime,
  _WaveItem.PlndPickCompltnUTCDateTime AS PlndPickCompltnUTCDateTime,
  _WaveItem.PlndPackCompletionUTCDateTime AS PlndPackCompletionUTCDateTime,
  _WaveItem.PlndStagingCompltnUTCDateTime AS PlndStagingCompltnUTCDateTime,
  _WaveItem.PlndLoadCompletionUTCDateTime AS PlndLoadCompletionUTCDateTime,
  _WaveItem.WaveAssgmtIsPossibleAftWaveRel AS WaveAssgmtIsPossibleAftWaveRel,
  _WaveItem.WaveCapacityProfile AS WaveCapacityProfile,
  _WaveItem.BehaviourDuringPickDenial AS BehaviourDuringPickDenial,
  _WaveItem.WaveCutoffWhseTmznDateTime AS WaveCutoffWhseTmznDateTime,
  _WaveItem.WaveCutoffWhseTmznYear AS WaveCutoffWhseTmznYear,
  _WaveItem.WaveCutoffWhseTmznMonth AS WaveCutoffWhseTmznMonth,
  _WaveItem.WaveCutoffWhseTmznDate AS WaveCutoffWhseTmznDate,
  _WaveItem.WaveCutoffWhseTmznHour AS WaveCutoffWhseTmznHour,
  _WaveItem.WaveCutoffWhseTmznTime AS WaveCutoffWhseTmznTime,
  _WaveItem.WavePlndRelWhseTmznDateTime AS WavePlndRelWhseTmznDateTime,
  _WaveItem.WavePlndRelWhseTmznYear AS WavePlndRelWhseTmznYear,
  _WaveItem.WavePlndRelWhseTmznMonth AS WavePlndRelWhseTmznMonth,
  _WaveItem.WavePlndRelWhseTmznDate AS WavePlndRelWhseTmznDate,
  _WaveItem.WavePlndRelWhseTmznHour AS WavePlndRelWhseTmznHour,
  _WaveItem.WavePlndRelWhseTmznTime AS WavePlndRelWhseTmznTime,
  _WaveItem.PlndPickCmpltWhseTmznDateTime AS PlndPickCmpltWhseTmznDateTime,
  _WaveItem.PlndPickCmpltWhseTmznYear AS PlndPickCmpltWhseTmznYear,
  _WaveItem.PlndPickCmpltWhseTmznMonth AS PlndPickCmpltWhseTmznMonth,
  _WaveItem.PlndPickCmpltWhseTmznDate AS PlndPickCmpltWhseTmznDate,
  _WaveItem.PlndPickCmpltWhseTmznHour AS PlndPickCmpltWhseTmznHour,
  _WaveItem.PlndPickCmpltWhseTmznTime AS PlndPickCmpltWhseTmznTime,
  _WaveItem.PlndPackCmpltWhseTmznDateTime AS PlndPackCmpltWhseTmznDateTime,
  _WaveItem.PlndPackCmpltWhseTmznYear AS PlndPackCmpltWhseTmznYear,
  _WaveItem.PlndPackCmpltWhseTmznMonth AS PlndPackCmpltWhseTmznMonth,
  _WaveItem.PlndPackCmpltWhseTmznDate AS PlndPackCmpltWhseTmznDate,
  _WaveItem.PlndPackCmpltWhseTmznHour AS PlndPackCmpltWhseTmznHour,
  _WaveItem.PlndPackCmpltWhseTmznTime AS PlndPackCmpltWhseTmznTime,
  _WaveItem.PlndStggCmpltWhseTmznDateTime AS PlndStggCmpltWhseTmznDateTime,
  _WaveItem.PlndStggCmpltWhseTmznYear AS PlndStggCmpltWhseTmznYear,
  _WaveItem.PlndStggCmpltWhseTmznMonth AS PlndStggCmpltWhseTmznMonth,
  _WaveItem.PlndStggCmpltWhseTmznDate AS PlndStggCmpltWhseTmznDate,
  _WaveItem.PlndStggCmpltWhseTmznHour AS PlndStggCmpltWhseTmznHour,
  _WaveItem.PlndStggCmpltWhseTmznTime AS PlndStggCmpltWhseTmznTime,
  _WaveItem.WaveCompletionWhseTmznDateTime AS WaveCompletionWhseTmznDateTime,
  _WaveItem.WaveCompletionWhseTmznYear AS WaveCompletionWhseTmznYear,
  _WaveItem.WaveCompletionWhseTmznMonth AS WaveCompletionWhseTmznMonth,
  _WaveItem.WaveCompletionWhseTmznDate AS WaveCompletionWhseTmznDate,
  _WaveItem.WaveCompletionWhseTmznHour AS WaveCompletionWhseTmznHour,
  _WaveItem.WaveCompletionWhseTmznTime AS WaveCompletionWhseTmznTime,
  _WaveItem.WaveActualReldWhseTmznDateTime AS WaveActualReldWhseTmznDateTime,
  _WaveItem.WaveActualReldWhseTmznYear AS WaveActualReldWhseTmznYear,
  _WaveItem.WaveActualReldWhseTmznMonth AS WaveActualReldWhseTmznMonth,
  _WaveItem.WaveActualReldWhseTmznDate AS WaveActualReldWhseTmznDate,
  _WaveItem.WaveActualReldWhseTmznHour AS WaveActualReldWhseTmznHour,
  _WaveItem.WaveActualReldWhseTmznTime AS WaveActualReldWhseTmznTime,
  _WaveItem.WaveIsReleasedManually AS WaveIsReleasedManually,
  _WaveItem.WaveStatus AS WaveStatus,
  _WaveStatusText[1:Language = $parameters.P_Language].WaveStatusName AS WaveStatusName,
  _WaveItem.WaveActlReleasedUTCDateTime AS WaveActlReleasedUTCDateTime
FROM P_EWM_WarehouseWaveItem_2 AS _WaveItem
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON ProductName = _Material.Product AND _Material.ProdSupChnMgmtUUID22 is not initial  -- association [0..1]
LEFT OUTER JOIN I_EWM_WaveReleaseMethodT AS _WaveReleaseMethodText ON WaveReleaseMethod = _WaveReleaseMethodText.WaveReleaseMethod  -- association [0..*]
LEFT OUTER JOIN I_EWM_WaveStatusText AS _WaveStatusText ON WaveStatus = _WaveStatusText.WaveStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_WaveType_2 AS _WaveType ON EWMWarehouse = _WaveType.EWMWarehouse AND WaveType = _WaveType.WaveType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WaveType_3 AS _WaveType_3 ON EWMWarehouse = _WaveType_3.EWMWarehouse AND WaveType = _WaveType_3.EWMWaveType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WaveCategory_2 AS _WaveCategory ON EWMWarehouse = _WaveCategory.EWMWarehouse AND WaveCategory = _WaveCategory.WaveCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseTaskStatusText AS _WarehouseTaskStatusText ON WarehouseTaskCreationStatus = _WarehouseTaskStatusText.WarehouseTaskStatus  -- association [0..*]
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_WrhsProcType_2 AS _WarehouseProcessType ON EWMWarehouse = _WarehouseProcessType.EWMWarehouse AND WarehouseProcessType = _WarehouseProcessType.WarehouseProcessType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType_2 AS _StorageType ON EWMWarehouse = _StorageType.EWMWarehouse AND EWMStorageType = _StorageType.EWMStorageType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageSection_2 AS _StorageSection ON EWMWarehouse = _StorageSection.EWMWarehouse AND EWMStorageType = _StorageSection.EWMStorageType AND EWMStorageSection = _StorageSection.EWMStorageSection  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON WaveFactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseModesText_2 AS _WarehouseModesText ON EWMWarehouse = _WarehouseModesText.EWMWarehouse AND WaveWarehouseTaskCreationMode = _WarehouseModesText.WaveWarehouseTaskCreationMode  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseSpclActyCatText_2 AS _WhseSpclActyCatText ON EWMWarehouse = _WhseSpclActyCatText.EWMWarehouse AND SpclActyCatInWhse = _WhseSpclActyCatText.SpclActyCatInWhse  -- association [0..*]
;