P_EWM_WarehouseTaskItem_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_WarehouseTaskItem_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_WarehouseTaskItem_2 AS
SELECT
  whTaskItem.EWMWarehouse AS EWMWarehouse,
  whTaskItem.WarehouseTask AS WarehouseTask,
  whTaskItem.WarehouseTaskItem AS WarehouseTaskItem,
  whTaskItem.IsHandlingUnitWarehouseTask AS IsHandlingUnitWarehouseTask,
  whTaskItem.WarehouseProcessType AS WarehouseProcessType,
  whTaskItem.WarehouseProcessCategory AS WarehouseProcessCategory,
  whTaskItem.StorageProcess AS StorageProcess,
  whTaskItem.ExternalStorageProcessStep AS ExternalStorageProcessStep,
  whTaskItem.WarehouseTaskStatus AS WarehouseTaskStatus,
  whTaskItem.CreatedByUser AS CreatedByUser,
  whTaskItem.WhseTaskCrtnUTCDateTime AS WhseTaskCrtnUTCDateTime,
  whTaskItem.WarehouseTaskCodes AS WarehouseTaskCodes,
  whTaskItem.ExecutingResource AS ExecutingResource,
  whTaskItem.WarehouseMovementsReason AS WarehouseMovementsReason,
  whTaskItem.EWMWarehouseTaskPriority AS EWMWarehouseTaskPriority,
  whTaskItem.StockItemUUID AS StockItemUUID,
  whTaskItem.CurrentNumberOfKeyTable AS CurrentNumberOfKeyTable,
  whTaskItem.ProductUUID AS ProductUUID,
  whTaskItem.ProductName AS ProductName,
  whTaskItem._Material AS _Material,
  whTaskItem.BatchUUID AS BatchUUID,
  whTaskItem.EWMStockType AS EWMStockType,
  whTaskItem.StockDocumentCategory AS StockDocumentCategory,
  whTaskItem.StockDocumentNumber AS StockDocumentNumber,
  whTaskItem.StockItemNumber AS StockItemNumber,
  whTaskItem.EWMDocumentCategory AS EWMDocumentCategory,
  whTaskItem.EWMStockUsage AS EWMStockUsage,
  whTaskItem.EWMStockOwner AS EWMStockOwner,
  whTaskItem.StockOwnerPartnerRole AS StockOwnerPartnerRole,
  whTaskItem.EntitledToDisposeParty AS EntitledToDisposeParty,
  whTaskItem.EntitledToDisposePartnerRole AS EntitledToDisposePartnerRole,
  whTaskItem.CounterForStockSeparation AS CounterForStockSeparation,
  whTaskItem.Batch AS Batch,
  whTaskItem.RequirementSegment AS RequirementSegment,
  whTaskItem.StockSegment AS StockSegment,
  whTaskItem.BaseUnit AS BaseUnit,
  whTaskItem.AlternativeUnit AS AlternativeUnit,
  whTaskItem.TargetQuantityInBaseUnit AS TargetQuantityInBaseUnit,
  whTaskItem.TargetQuantityInAltvUnit AS TargetQuantityInAltvUnit,
  whTaskItem.WhseTaskRetentionQuantity AS WhseTaskRetentionQuantity,
  whTaskItem.HandlingUnitType AS HandlingUnitType,
  whTaskItem.NetWeight AS WhseTaskNetWeight,
  whTaskItem.NetWeight AS NetWeight,
  whTaskItem.WhseTaskNetWeightUnitOfMeasure AS WhseTaskNetWeightUnitOfMeasure,
  whTaskItem.WhseTaskNetVolume AS WhseTaskNetVolume,
  whTaskItem.WhseTaskNetVolumeUnitOfMeasure AS WhseTaskNetVolumeUnitOfMeasure,
  whTaskItem.WhseTaskCapacityConsumption AS WhseTaskCapacityConsumption,
  whTaskItem.PutAwayPhysInventoryIsPlanned AS PutAwayPhysInventoryIsPlanned,
  whTaskItem.WhseTaskLowStockCheckIsPlanned AS WhseTaskLowStockCheckIsPlanned,
  whTaskItem.EWMPutAwayPhysInvtryPlnSts AS EWMPutAwayPhysInvtryPlnSts,
  whTaskItem.EWMWhseTskLowStkChkPlnSts AS EWMWhseTskLowStkChkPlnSts,
  whTaskItem.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  whTaskItem.WhseTaskGoodsReceiptDateTime AS WhseTaskGoodsReceiptDateTime,
  whTaskItem.CountryOfOrigin AS CountryOfOrigin,
  whTaskItem.HazardousSubstanceIndicator AS HazardousSubstanceIndicator,
  whTaskItem.WhseTaskQualityInspectionType AS WhseTaskQualityInspectionType,
  whTaskItem.QualityInspectionDocUUID AS QualityInspectionDocUUID,
  whTaskItem.StockIdentificationOfWhseTask AS StockIdentificationOfWhseTask,
  whTaskItem.EWMConsolidationGroup AS EWMConsolidationGroup,
  whTaskItem.SourceStorageType AS SourceStorageType,
  whTaskItem.SourceStorageSection AS SourceStorageSection,
  whTaskItem.SourceStorageBin AS SourceStorageBin,
  whTaskItem.SourceHndlgUnitLogicalPosition AS SourceHndlgUnitLogicalPosition,
  whTaskItem.SourceResource AS SourceResource,
  whTaskItem.SourceTransportationUnit AS SourceTransportationUnit,
  whTaskItem.EWMSourceLocationType AS EWMSourceLocationType,
  whTaskItem.SourceHandlingUnitUUID AS SourceHandlingUnitUUID,
  ltrim(whTaskItem.SourceHandlingUnit, '0') AS SourceHandlingUnit,
  whTaskItem.DestinationStorageType AS DestinationStorageType,
  whTaskItem.DestinationStorageSection AS DestinationStorageSection,
  whTaskItem.DestinationStorageBin AS DestinationStorageBin,
  whTaskItem.DestHndlgUnitLogicalPosition AS DestHndlgUnitLogicalPosition,
  whTaskItem.DestinationResource AS DestinationResource,
  whTaskItem.DestinationTransportationUnit AS DestinationTransportationUnit,
  whTaskItem.EWMDestinationLocationType AS EWMDestinationLocationType,
  whTaskItem.DestinationHandlingUnitUUID AS DestinationHandlingUnitUUID,
  whTaskItem.DestinationHandlingUnit AS DestinationHandlingUnit,
  whTaskItem.WhseTaskDestStorageBinDtmndBy AS WhseTaskDestStorageBinDtmndBy,
  whTaskItem.WrhsTaskSubsystemTransmn AS WrhsTaskSubsystemTransmn,
  whTaskItem.WhseTaskPlannedProcessingTime AS WhseTaskPlannedProcessingTime,
  whTaskItem.WhseTaskProcgTimeDetnTimeUnit AS WhseTaskProcgTimeDetnTimeUnit,
  whTaskItem.WhseTaskRefToValueAddedService AS WhseTaskRefToValueAddedService,
  whTaskItem.BatchChangeIsNotAllowed AS BatchChangeIsNotAllowed,
  whTaskItem.EWMReferenceDocumentCategory AS EWMReferenceDocumentCategory,
  whTaskItem.ReferenceDocumentUUID AS ReferenceDocumentUUID,
  whTaskItem.ReferenceDocumentItemUUID AS ReferenceDocumentItemUUID,
  whTaskItem.Wave AS Wave,
  whTaskItem.WaveItem AS WaveItem,
  whTaskItem.WhseTaskTwoStepPickingType AS WhseTaskTwoStepPickingType,
  whTaskItem.WhseTaskTwoStepPickingRlvnce AS WhseTaskTwoStepPickingRlvnce,
  whTaskItem.DocumentReltdStockDocCat AS DocumentReltdStockDocCat,
  whTaskItem.DocumentReltdStockDocUUID AS DocumentReltdStockDocUUID,
  whTaskItem.DocumentReltdStockDocItemUUID AS DocumentReltdStockDocItemUUID,
  whTaskItem.StockIdentificationNumber AS StockIdentificationNumber,
  whTaskItem.KitItemIsCreatedAutomatically AS KitItemIsCreatedAutomatically,
  whTaskItem.WarehouseTaskUUID AS WarehouseTaskUUID,
  whTaskItem.IsDocumentaryBatch AS IsDocumentaryBatch,
  whTaskItem.ConveyorTechniqueSegment AS ConveyorTechniqueSegment,
  whTaskItem.EWMProductionSupplyArea AS EWMProductionSupplyArea,
  ltrim(whTaskItem.ProductionOrder, '0') AS ProductionOrder,
  whTaskItem.WhseTaskCrtnWhseTmznDateTime AS WhseTaskCrtnWhseTmznDateTime,
  whTaskItem.WhseTaskChgWhseTmznDateTime AS WhseTaskChgWhseTmznDateTime,
  whTaskItem.WhseTaskConfWhseTmznDateTime AS WhseTaskConfWhseTmznDateTime,
  cast(substring(cast(whTaskItem.WhseTaskConfWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseTaskConfWhseTmznDate,
  whTaskItem.WhseTskPlndClsgWhseTmznDteTme AS WhseTskPlndClsgWhseTmznDteTme,
  whTaskItem.Kanban AS Kanban,
  whTaskItem.StockKeepingAlternativeUoM AS StockKeepingAlternativeUoM,
  whTaskItem.ActivityArea AS ActivityArea,
  whTaskItem.Queue AS Queue,
  whTaskItem.WarehouseOrder AS WarehouseOrder,
  whTaskItem.LogicalRecordProgramName AS LogicalRecordProgramName,
  whTaskItem.LogicalRecordTransactionCode AS LogicalRecordTransactionCode,
  whTaskItem.EWMDummyFuncForStructureExtn AS EWMDummyFuncForStructureExtn,
  whTaskItem.CertificateText AS CertificateText,
  whTaskItem.WhseTaskLastChgUTCDateTime AS WhseTaskLastChgUTCDateTime,
  whTaskItem.WarehouseActivityType AS WarehouseActivityType,
  whTaskItem.ConfirmedByUser AS ConfirmedByUser,
  whTaskItem.ConfirmationUTCDateTime AS ConfirmationUTCDateTime,
  ltrim(whTaskItem.Processor,'0') AS Processor,
  whTaskItem.WarehouseTaskExceptionCode AS WarehouseTaskExceptionCode,
  whTaskItem.BusinessContext AS BusinessContext,
  whTaskItem.BusinessContextExecutionStep AS BusinessContextExecutionStep,
  whTaskItem.ExecutingResourceGroup AS ExecutingResourceGroup,
  whTaskItem.ExecutingResourceType AS ExecutingResourceType,
  whTaskItem.WhseTaskPlannedClosingDateTime AS WhseTaskPlannedClosingDateTime,
  whTaskItem.ActualQuantityInBaseUnit AS ActualQuantityInBaseUnit,
  whTaskItem.ActualQuantityInAltvUnit AS ActualQuantityInAltvUnit,
  whTaskItem.DifferenceQuantityInAltvUnit AS DifferenceQuantityInAltvUnit,
  whTaskItem.DifferenceQuantityInBaseUnit AS 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.WrhsOrdCrtnUTCDateTime AS WrhsOrdCrtnUTCDateTime,
  sourceBin.EWMStorageBinType AS SourceStorageBinType,
  sourceBin.EWMStorBinFreeDefinedAisleText AS SourceStorageBinAisle,
  sourceBin.EWMStorBinFreeDefinedStackText AS SourceStorageBinStack,
  sourceBin.EWMStorBinFreeDefinedLevelText AS SourceStorageBinLevel,
  sourceBin.EWMStorageBinAccessType AS SourceStorageBinAccessType,
  destBin.EWMStorageBinType AS DestinationStorageBinType,
  destBin.EWMStorBinFreeDefinedAisleText AS DestinationStorageBinAisle,
  destBin.EWMStorBinFreeDefinedStackText AS DestinationStorageBinStack,
  destBin.EWMStorBinFreeDefinedLevelText AS DestinationStorageBinLevel,
  destBin.EWMStorageBinAccessType 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.EWMWarehouse 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 (whTaskItem.WhseTaskPlannedClosingDateTime, tstmp_current_utctimestamp(), 'NULL'))-ABS(DIV(tstmp_seconds_between (whTaskItem.WhseTaskPlannedClosingDateTime, tstmp_current_utctimestamp(), 'NULL'), 3600)*3600) AS OpenMod,
  ABS(tstmp_seconds_between (whTaskItem.WhseTaskPlannedClosingDateTime, whTaskItem.ConfirmationUTCDateTime, 'NULL'))-ABS(DIV(tstmp_seconds_between (whTaskItem.WhseTaskPlannedClosingDateTime, whTaskItem.ConfirmationUTCDateTime, 'NULL'), 3600)*3600) AS ConfirmedMod,
  timezone.EWMWarehouseCurrentDate AS EWMWarehouseCurrentDate
FROM I_EWM_WarehouseTask_2 AS whTaskItem
LEFT OUTER JOIN I_BusinessPartner AS _StockOwner ON EWMStockOwner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _EntitledToDisposeParty ON EWMStockOwner = _EntitledToDisposeParty.BusinessPartner  -- association [0..1]
;