I_EWM_WarehouseWaveC

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.
-- 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.
-- SQL view name: IEWMWAVEC

CREATE VIEW I_EWM_WarehouseWaveC AS
SELECT
  _WaveHeader.Warehouse AS Warehouse,
  Wave,
  WaveItem,
  1.0 AS NumberOfWaveItems,
  WarehouseTaskCreationStatus,
  _WarehouseTaskStatusText[1:Language = $parameters.P_Language].WarehouseTaskStatusName AS WarehouseTaskCreationStsName,
  ItemWeight,
  ItemWeightUnit,
  whseControl.DisplayWeightUnit AS DisplayWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  whseControl.DisplayVolumeUnit AS DisplayVolumeUnit,
  WaveItemConsumedCapacityValue,
  ShipToParty,
  Product,
  _Material.Product AS ProductName,
  _Material._Text[1:Language = $parameters.P_Language].ProductName AS ProductDescription,
  Batch,
  StockOwner,
  EntitledToDisposeParty,
  ItemQuantity,
  ItemQuantityUnit,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  SplitNumber,
  ReferenceDocumentNumber,
  ReferenceDocumentItemNumber,
  TwoStepPickingWaveItemCategory,
  WaveItemErrorStatus,
  Route,
  SalesOrder,
  ActivityArea,
  _ActivityArea._Text[1:Language = $parameters.P_Language].ActivityAreaName AS ActivityAreaName,
  WarehouseProcessType,
  _WarehouseProcessType._Text[1:Language = $parameters.P_Language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  WaveItemSimulationStatus,
  ReferenceDocumentCategory,
  WaveTemplate,
  _WaveHeader._WaveTmpl._Text[1:Language = $parameters.P_Language].WaveTemplateName AS WaveTemplateName,
  WaveName,
  WaveType,
  _WaveType._WaveTypeText[1:Language = $parameters.P_Language].WaveTypeName AS WaveTypeName,
  WaveCategory,
  _WaveCategory._WaveCategoryText[1:Language = $parameters.P_Language].WaveCategoryName AS WaveCategoryName,
  WaveReleaseMethod,
  _WaveReleaseMethodText[1:Language = $parameters.P_Language].WaveReleaseMethodName AS WaveReleaseMethodName,
  WaveTemplateOption,
  WaveFactoryCalendar,
  _FactoryCalendar._Text[1:Language = $parameters.P_Language].FactoryCalendarName AS FactoryCalendarName,
  WhseTskIsRlvtForTwoStpPicking,
  WaveWarehouseTaskCreationMode,
  _WarehouseModesText[1:Language = $parameters.P_Language].WaveWhseTaskCrtnModeText AS WaveWhseTaskCrtnModeText,
  StorageType,
  _StorageType._Text[1:Language = $parameters.P_Language].StorageTypeName AS StorageTypeName,
  StorageSection,
  _StorageSection._Text[1:Language = $parameters.P_Language].StorageSectionName AS StorageSectionName,
  SpclActyCatInWhse,
  _WhseSpclActyCatText[1:Language = $parameters.P_Language].WhseSpclActyCatText AS WhseSpclActyCatText,
  ReleasedByUser,
  TwoStepPickingDependency,
  MaximumNumberOfWaveItems,
  WaveSimulationStatus,
  WaveCutoffUTCDateTime,
  PlndWaveReleaseUTCDateTime,
  PlndPickCompltnUTCDateTime,
  PlndPackCompletionUTCDateTime,
  PlndStagingCompltnUTCDateTime,
  PlndLoadCompletionUTCDateTime,
  WaveAssgmtIsPossibleAftWaveRel,
  WaveCapacityProfile,
  BehaviourDuringPickDenial,
  WaveCutoffWhseTmznDateTime,
  WaveCutoffWhseTmznYear,
  WaveCutoffWhseTmznMonth,
  WaveCutoffWhseTmznDate,
  WaveCutoffWhseTmznHour,
  WaveCutoffWhseTmznTime,
  WavePlndRelWhseTmznDateTime,
  WavePlndRelWhseTmznYear,
  WavePlndRelWhseTmznMonth,
  WavePlndRelWhseTmznDate,
  WavePlndRelWhseTmznHour,
  WavePlndRelWhseTmznTime,
  PlndPickCmpltWhseTmznDateTime,
  PlndPickCmpltWhseTmznYear,
  PlndPickCmpltWhseTmznMonth,
  PlndPickCmpltWhseTmznDate,
  PlndPickCmpltWhseTmznHour,
  PlndPickCmpltWhseTmznTime,
  PlndPackCmpltWhseTmznDateTime,
  PlndPackCmpltWhseTmznYear,
  PlndPackCmpltWhseTmznMonth,
  PlndPackCmpltWhseTmznDate,
  PlndPackCmpltWhseTmznHour,
  PlndPackCmpltWhseTmznTime,
  PlndStggCmpltWhseTmznDateTime,
  PlndStggCmpltWhseTmznYear,
  PlndStggCmpltWhseTmznMonth,
  PlndStggCmpltWhseTmznDate,
  PlndStggCmpltWhseTmznHour,
  PlndStggCmpltWhseTmznTime,
  WaveCompletionWhseTmznDateTime,
  WaveCompletionWhseTmznYear,
  WaveCompletionWhseTmznMonth,
  WaveCompletionWhseTmznDate,
  WaveCompletionWhseTmznHour,
  WaveCompletionWhseTmznTime,
  WaveActualReldWhseTmznDateTime,
  WaveActualReldWhseTmznYear,
  WaveActualReldWhseTmznMonth,
  WaveActualReldWhseTmznDate,
  WaveActualReldWhseTmznHour,
  WaveActualReldWhseTmznTime,
  WaveIsReleasedManually,
  WaveStatus,
  _WaveStatusText[1:Language = $parameters.P_Language].WaveStatusName AS WaveStatusName,
  WaveActlReleasedUTCDateTime
FROM P_EWM_WarehouseWaveItem AS _WaveHeader
LEFT OUTER JOIN I_EWM_WarehouseControl AS whseControl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _Warehouse ON _WaveHeader.Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Product = _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 AS _WaveType ON Warehouse = _WaveType.Warehouse AND WaveType = _WaveType.WaveType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WaveCategory AS _WaveCategory ON Warehouse = _WaveCategory.Warehouse 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 AS _ActivityArea ON ActivityArea = _ActivityArea.ActivityArea AND Warehouse = _ActivityArea.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WrhsProcType AS _WarehouseProcessType ON Warehouse = _WarehouseProcessType.Warehouse AND WarehouseProcessType = _WarehouseProcessType.WarehouseProcessType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType AS _StorageType ON Warehouse = _StorageType.Warehouse AND StorageType = _StorageType.StorageType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageSection AS _StorageSection ON Warehouse = _StorageSection.Warehouse AND StorageType = _StorageSection.StorageType AND StorageSection = _StorageSection.StorageSection  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON WaveFactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseModesText AS _WarehouseModesText ON Warehouse = _WarehouseModesText.Warehouse AND WaveWarehouseTaskCreationMode = _WarehouseModesText.WaveWarehouseTaskCreationMode  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseSpclActyCatText AS _WhseSpclActyCatText ON Warehouse = _WhseSpclActyCatText.Warehouse AND SpclActyCatInWhse = _WhseSpclActyCatText.SpclActyCatInWhse  -- association [0..*]
;