P_EWM_WarehouseTaskItem

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_WarehouseTaskItem.
-- 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: PEWMWTITEM

CREATE VIEW P_EWM_WarehouseTaskItem AS
SELECT
  whTaskItem.Warehouse AS Warehouse,
  ltrim(WarehouseTask,'0') AS WarehouseTask,
  ltrim(WarehouseTaskItem, '0') AS WarehouseTaskItem,
  IsHandlingUnitWarehouseTask,
  whTaskItem.WarehouseProcessType AS WarehouseProcessType,
  WarehouseProcessCategory,
  StorageProcess,
  ExternalStorageProcessStep,
  WarehouseTaskStatus,
  whTaskItem.CreatedByUser AS CreatedByUser,
  whTaskItem.CreationDateTime AS CreationDateTime,
  WarehouseTaskCodes,
  whTaskItem.ExecutingResource AS ExecutingResource,
  WarehouseMovementsReason,
  PriorityCode,
  StockItemUUID,
  CurrentNumberOfKeyTable,
  whTaskItem.ProductUUID AS ProductUUID,
  whTaskItem.ProductName AS ProductName,
  whTaskItem._Material AS _Material,
  whTaskItem.ProductBatch AS ProductBatch,
  whTaskItem.StockType AS StockType,
  whTaskItem.StockDocumentCategory AS StockDocumentCategory,
  ltrim(whTaskItem.StockDocumentNumber, '0') AS StockDocumentNumber,
  ltrim(whTaskItem.StockItemNumber, '0') AS StockItemNumber,
  DocumentCategory,
  whTaskItem.StockUsage AS StockUsage,
  whTaskItem.StockOwner AS StockOwner,
  whTaskItem.StockOwnerPartnerRole AS StockOwnerPartnerRole,
  whTaskItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  CounterForStockSeparation,
  whTaskItem.Batch AS Batch,
  BaseUnit,
  AlternativeUnit,
  TargetQuantityInBaseUnit,
  TargetQuantityInAltvUnit,
  WhseTaskRetentionQuantity,
  HandlingUnitType,
  NetWeight AS WhseTaskNetWeight,
  NetWeight,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetVolume,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskCapacityConsumption,
  PutAwayPhysInventoryIsPlanned,
  WhseTaskLowStockCheckIsPlanned,
  ShelfLifeExpirationDate,
  WhseTaskGoodsReceiptDateTime,
  whTaskItem.CountryOfOrigin AS CountryOfOrigin,
  HazardousSubstanceIndicator,
  WhseTaskQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationOfWhseTask,
  ConsolidationGroup,
  SourceStorageType,
  SourceStorageSection,
  SourceStorageBin,
  SourceHndlgUnitLogicalPosition,
  SourceResource,
  SourceTransportationUnit,
  SourceLocationType,
  SourceHandlingUnitUUID,
  ltrim(SourceHandlingUnit, '0') AS SourceHandlingUnit,
  DestinationStorageType,
  DestinationStorageSection,
  DestinationStorageBin,
  DestHndlgUnitLogicalPosition,
  DestinationResource,
  DestinationTransportationUnit,
  DestinationLocationType,
  DestinationHandlingUnitUUID,
  DestinationHandlingUnit,
  WhseTaskDestStorageBinDtmndBy,
  WrhsTaskSubsystemTransmn,
  WhseTaskPlannedProcessingTime,
  WhseTaskProcgTimeDetnTimeUnit,
  WhseTaskRefToValueAddedService,
  BatchChangeIsNotAllowed,
  whTaskItem.ReferenceDocumentCategory AS ReferenceDocumentCategory,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  whTaskItem.Wave AS Wave,
  ltrim(WaveItem, '0') AS WaveItem,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  DocumentReltdStockDocCat,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  StockIdentificationNumber,
  KitItemIsCreatedAutomatically,
  WarehouseTaskUUID,
  IsDocumentaryBatch,
  ConveyorTechniqueSegment,
  whTaskItem.ProductionSupplyArea AS ProductionSupplyArea,
  ltrim(ProductionOrder, '0') AS ProductionOrder,
  WhseTaskCrtnWhseTmznDateTime,
  WhseTaskChgWhseTmznDateTime,
  WhseTaskConfWhseTmznDateTime,
  cast(substring(cast(WhseTaskConfWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseTaskConfWhseTmznDate,
  WhseTskPlndClsgWhseTmznDteTme,
  Kanban,
  StockKeepingAlternativeUoM,
  whTaskItem.ActivityArea AS ActivityArea,
  whTaskItem.Queue AS Queue,
  whTaskItem.WarehouseOrder AS WarehouseOrder,
  LogicalRecordProgramName,
  LogicalRecordTransactionCode,
  EWMDummyFuncForStructureExtn,
  CertificateText,
  whTaskItem.LastChangeDateTime AS LastChangeDateTime,
  WarehouseActivityType,
  ConfirmedByUser,
  ConfirmationUTCDateTime,
  ltrim(whTaskItem.Processor,'0') AS Processor,
  WarehouseTaskExceptionCode,
  BusinessContext,
  BusinessContextExecutionStep,
  ExecutingResourceGroup,
  ExecutingResourceType,
  WhseTaskPlannedClosingDateTime,
  ActualQuantityInBaseUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInAltvUnit,
  DifferenceQuantityInBaseUnit,
  who.WarehouseOrderCreationRule AS WarehouseOrderCreationRule,
  who.WarehouseOrderStatus AS WarehouseOrderStatus,
  who.WhseOrderLatestStartDateTime AS WhseOrderLatestStartDateTime,
  who.WhseOrderHigherLevelWhseOrder AS WhseOrderHigherLevelWhseOrder,
  who.WarehouseOrderIsSplit AS WarehouseOrderIsSplit,
  who.WarehouseOrderStartDateTime AS WarehouseOrderStartDateTime,
  who.Queue AS WarehouseOrderQueue,
  who.CreationDateTime AS WrhsOrdCrtnUTCDateTime,
  sourceBin.StorageBinType AS SourceStorageBinType,
  sourceBin.StorageBinFreeDefinedAisleText AS SourceStorageBinAisle,
  sourceBin.StorageBinFreeDefinedStackText AS SourceStorageBinStack,
  sourceBin.StorageBinFreeDefinedLevelText AS SourceStorageBinLevel,
  sourceBin.SourceStorageBinAccessType AS SourceStorageBinAccessType,
  destBin.StorageBinType AS DestinationStorageBinType,
  destBin.StorageBinFreeDefinedAisleText AS DestinationStorageBinAisle,
  destBin.StorageBinFreeDefinedStackText AS DestinationStorageBinStack,
  destBin.StorageBinFreeDefinedLevelText AS DestinationStorageBinLevel,
  destBin.SourceStorageBinAccessType AS DestinationStorageBinAccType,
  _wave.PlndPickCompltnUTCDateTime AS PlndPickCompltnUTCDateTime,
  _wave.PlndPackCompletionUTCDateTime AS PlndPackCompletionUTCDateTime,
  _wave.PlndStagingCompltnUTCDateTime AS PlndStagingCompltnUTCDateTime,
  _wave.PlndLoadCompletionUTCDateTime AS PlndLoadCompletionUTCDateTime,
  _wave.WaveActlReleasedUTCDateTime AS WaveActlReleasedUTCDateTime,
  _wave._WaveTmpl.WaveTemplate AS WaveTemplate,
  _wave._WaveTmpl.Warehouse AS WaveWarehouse,
  _wave._WaveTmpl._Text AS _waveText,
  _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,
  whseControl.DisplayVolumeUnit AS DisplayVolumeUnit,
  whseControl.DisplayWeightUnit AS DisplayWeightUnit,
  ABS(tstmp_seconds_between (WhseTaskPlannedClosingDateTime, tstmp_current_utctimestamp(), 'NULL'))-ABS(DIV(tstmp_seconds_between (WhseTaskPlannedClosingDateTime, tstmp_current_utctimestamp(), 'NULL'), 3600)*3600) AS OpenMod,
  ABS(tstmp_seconds_between (WhseTaskPlannedClosingDateTime, ConfirmationUTCDateTime, 'NULL'))-ABS(DIV(tstmp_seconds_between (WhseTaskPlannedClosingDateTime, ConfirmationUTCDateTime, 'NULL'), 3600)*3600) AS ConfirmedMod,
  timezone.EWMWarehouseCurrentDate AS EWMWarehouseCurrentDate
FROM I_EWM_WarehouseTask AS whTaskItem
LEFT OUTER JOIN I_EWM_WarehouseOrder AS who ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_StorageBin AS sourceBin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_StorageBin AS destBin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_WaveHeader AS _wave ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_WarehouseControl AS whseControl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_AssgWhseBusinessPartner AS bp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_WarehouseTimezone AS timezone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_BusinessPartner AS _StockOwner ON StockOwner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_BusinessPartner AS _EntitledToDisposeParty ON StockOwner = _EntitledToDisposeParty.BusinessPartner  -- association [0..1]
;