P_EWM_WarehouseTask01_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 P_EWM_WarehouseTask01_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 P_EWM_WarehouseTask01_2 AS
SELECT
  EWMWarehouse,
  cast( WarehouseTask as /scwm/tanum_noconv preserving type ) AS WarehouseTask,
  cast( WarehouseTaskItem as /scwm/tapos_noconv preserving type ) AS WarehouseTaskItem,
  cast( WarehouseOrder as /scwm/de_who_noconv preserving type ) AS WarehouseOrder,
  cast( WhseTaskCrtnUTCDateTime as /scwm/de_created_dt_noconv preserving type ) AS WhseTaskCrtnUTCDateTime,
  ConfirmationUTCDateTime AS WhseTaskConfUTCDateTime,
  ConfirmedByUser,
  WhseTaskPlannedClosingDateTime,
  cast( WhseTaskGoodsReceiptDateTime as /scwm/lvs_wdatu_noconv preserving type ) AS WhseTaskGoodsReceiptDateTime,
  WarehouseTaskStatus,
  WarehouseTaskStatusName,
  WarehouseProcessType,
  WarehouseProcessTypeName,
  WarehouseProcessCategory,
  IsHandlingUnitWarehouseTask,
  HandlingUnitType AS EWMHandlingUnitType,
  HandlingUnitTypeGroup,
  HomogeneousFullPalletPick,
  EWMPutAwayPhysInvtryPlnSts,
  EWMWhseTskLowStkChkPlnSts,
  EWMPutAwayPhysInvtryExecSts,
  EWMWhseTskLowStkChkExecSts,
  ProductName AS Product,
  ProductDescription,
  Batch,
  CountryOfOrigin,
  ShelfLifeExpirationDate,
  BatchChangeIsNotAllowed,
  EWMStockType,
  EWMStockUsage,
  EWMStockTypeName,
  cast( EWMStockOwner as char10 preserving type ) AS EWMStockOwner,
  EntitledToDisposeParty,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  ExecutingResource,
  WarehouseMovementsReason,
  ProductionOrder,
  EWMProductionSupplyArea,
  EWMDocumentCategory,
  EWMReferenceDocumentCategory,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  _RefDocNr.Delivery AS EWMDelivery,
  _RefDocNr.DeliveryItem AS EWMDeliveryItem,
  _RefDocNr.PurchasingDocument AS PurchasingDocument,
  _RefDocNr.PurchasingDocumentItem AS PurchasingDocumentItem,
  _RefDocNr.SalesDocument AS SalesDocument,
  _RefDocNr.SalesDocumentItem AS SalesDocumentItem,
  BaseUnit,
  _BaseUnitOfMeasure.UnitOfMeasureISOCode AS EWMBaseUnitISOCode,
  AlternativeUnit,
  _AlternativeUnitOfMeasure.UnitOfMeasureISOCode AS EWMAlternativeUnitISOCode,
  TargetQuantityInBaseUnit,
  TargetQuantityInAltvUnit,
  ActualQuantityInBaseUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInBaseUnit,
  DifferenceQuantityInAltvUnit,
  WhseTaskNetWeightUnitOfMeasure,
  NetWeight AS WhseTaskNetWeight,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskNetVolume,
  SourceStorageType,
  SourceStorageTypeName,
  SourceStorageSection,
  SourceStorageBin,
  SourceResource,
  DestinationStorageType,
  DestinationStorageTypeName,
  DestinationStorageSection,
  DestinationStorageBin,
  DestinationResource,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  ActivityArea,
  ActivityAreaName,
  cast ( SourceHandlingUnit as /scwm/ltap_vlenr_noconv preserving type ) AS SourceHandlingUnit,
  cast ( DestinationHandlingUnit as /scwm/de_deshu_noconv preserving type ) AS DestinationHandlingUnit,
  WarehouseTaskExceptionCode,
  WhseTaskSortingSequenceValue,
  WarehouseOrderSequenceValue,
  WarehouseOrderActivityArea,
  WarehouseOrderCreationRule,
  Queue AS WarehouseOrderQueue,
  WarehouseActivityType,
  EWMConsolidationGroup,
  EWMWarehouseTaskPriority,
  _WarehouseTask.CreatedByUser AS CreatedByUser,
  EWMRoute,
  EWMCanceledWarehouseTask
FROM I_EWM_WarehouseTaskT_2 AS _WarehouseTask
LEFT OUTER JOIN P_EWM_WhseTaskRefDocNumber01 AS _RefDocNr ON ReferenceDocumentUUID = _RefDocNr.DeliveryOrderUUID AND ReferenceDocumentItemUUID = _RefDocNr.DeliveryItemUUID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON _WarehouseTask.StockDocumentCategory = 'PJS' AND _WarehouseTask.StockDocumentNumber = _WBSElementBasicData.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _WBSElementDecentralized ON _WarehouseTask.StockDocumentCategory = 'PJS' AND _WarehouseTask.StockDocumentNumber = _WBSElementDecentralized.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseSystIsDecentralized AS _WhseSystemIsDecentralized ON _WhseSystemIsDecentralized.WarehouseSystemIsDecentralized = 'X'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AlternativeUnitOfMeasure ON AlternativeUnit = _AlternativeUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EWM_SerialNumberHeader_2 AS _SerialNumberHeader2_h ON _WarehouseTask.EWMWarehouse = _SerialNumberHeader2_h.EWMWarehouse AND _WarehouseTask.ProductUUID = _SerialNumberHeader2_h.ProductUUID AND _WarehouseTask.EntitledToDisposeParty = _SerialNumberHeader2_h.EntitledToDisposeParty  -- association [0..1]
;