P_EWM_WarehouseTask01

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.
-- 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: PEWMWHSETASK01

CREATE VIEW P_EWM_WarehouseTask01 AS
SELECT
  Warehouse,
  cast( WarehouseTask as /scwm/tanum_noconv ) AS WarehouseTask,
  cast( WarehouseTaskItem as /scwm/tapos_noconv ) AS WarehouseTaskItem,
  cast( WarehouseOrder as /scwm/de_who_noconv ) AS WarehouseOrder,
  cast( CreationDateTime as /scwm/de_created_dt_noconv ) AS CreationDateTime,
  ConfirmationUTCDateTime,
  WhseTaskPlannedClosingDateTime,
  cast( WhseTaskGoodsReceiptDateTime as /scwm/lvs_wdatu_noconv ) AS WhseTaskGoodsReceiptDateTime,
  WarehouseTaskStatus,
  WarehouseTaskStatusName,
  WarehouseProcessType,
  WarehouseProcessTypeName,
  IsHandlingUnitWarehouseTask,
  ProductName,
  ProductDescription,
  Batch,
  BatchChangeIsNotAllowed,
  StockType,
  StockTypeName,
  cast ( StockOwner as abap.char( 10 ) ) AS StockOwner,
  EntitledToDisposeParty,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  ExecutingResource,
  ProductionOrder,
  ProductionSupplyArea,
  ReferenceDocumentCategory,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  _RefDocNr.Delivery AS Delivery,
  _RefDocNr.DeliveryItem AS DeliveryItem,
  _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,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskNetVolume,
  SourceStorageType,
  SourceStorageTypeName,
  SourceStorageSection,
  SourceStorageBin,
  DestinationStorageType,
  DestinationStorageTypeName,
  DestinationStorageSection,
  DestinationStorageBin,
  DestinationResource,
  ActivityArea,
  ActivityAreaName,
  cast ( SourceHandlingUnit as /scwm/ltap_vlenr_noconv ) AS SourceHandlingUnit,
  cast ( DestinationHandlingUnit as /scwm/de_deshu_noconv ) AS DestinationHandlingUnit,
  cast( WarehouseTaskExceptionCode as abap.char( 1 ) ) AS WarehouseTaskExceptionCode
FROM I_EWM_WarehouseTaskT
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 StockDocumentCategory = 'PJS' AND StockDocumentNumber = _WBSElementBasicData.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _WBSElementDecentralized ON StockDocumentCategory = 'PJS' AND 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]
;