I_EWM_WarehouseTaskT_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 I_EWM_WarehouseTaskT_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 I_EWM_WarehouseTaskT_2 AS
SELECT
  EWMWarehouse,
  WarehouseTask,
  WarehouseTaskItem,
  IsHandlingUnitWarehouseTask,
  WarehouseProcessType,
  _WhseProcType._Text[1:Language = $session.system_language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  WarehouseProcessCategory,
  StorageProcess,
  ExternalStorageProcessStep,
  WarehouseTaskStatus,
  _WhseTaskStatusTxt.WarehouseTaskStatusName AS WarehouseTaskStatusName,
  CreatedByUser,
  WhseTaskCrtnUTCDateTime,
  WarehouseTaskCodes,
  ExecutingResource,
  WarehouseMovementsReason,
  EWMWarehouseTaskPriority,
  StockItemUUID,
  CurrentNumberOfKeyTable,
  ProductUUID,
  ProductName,
  _MaterialText[1:Language = $session.system_language].ProductName AS ProductDescription,
  Batch,
  EWMStockType,
  case when _StockType._Text[1:Language = $session.system_language].EWMStockTypeName is not null then _StockType._Text[1:Language = $session.system_language].EWMStockTypeName else _StockType._WhseIndepText[1:Language = $session.system_language].EWMStockTypeName end as EWMStockTypeName AS EWMStockTypeNameendasEWMStockTypeName,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  EWMDocumentCategory,
  EWMStockUsage,
  EWMStockOwner,
  StockOwnerPartnerRole,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  CounterForStockSeparation,
  BatchUUID,
  BaseUnit,
  AlternativeUnit,
  TargetQuantityInBaseUnit,
  TargetQuantityInAltvUnit,
  WhseTaskRetentionQuantity,
  HandlingUnitType,
  HandlingUnitTypeGroup,
  NetWeight,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetVolume,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskCapacityConsumption,
  EWMPutAwayPhysInvtryPlnSts,
  EWMWhseTskLowStkChkPlnSts,
  EWMPutAwayPhysInvtryExecSts,
  EWMWhseTskLowStkChkExecSts,
  ShelfLifeExpirationDate,
  WhseTaskGoodsReceiptDateTime,
  CountryOfOrigin,
  HazardousSubstanceIndicator,
  WhseTaskQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationOfWhseTask,
  EWMConsolidationGroup,
  SourceStorageType,
  _SrcStorageType._Text[1:Language = $session.system_language].EWMStorageTypeName AS SourceStorageTypeName,
  SourceStorageSection,
  SourceStorageBin,
  SourceHndlgUnitLogicalPosition,
  SourceResource,
  SourceTransportationUnit,
  EWMSourceLocationType,
  SourceHandlingUnitUUID,
  SourceHandlingUnit,
  DestinationStorageType,
  _DstStorageType._Text[1:Language = $session.system_language].EWMStorageTypeName AS DestinationStorageTypeName,
  DestinationStorageSection,
  DestinationStorageBin,
  DestHndlgUnitLogicalPosition,
  DestinationResource,
  DestinationTransportationUnit,
  EWMDestinationLocationType,
  DestinationHandlingUnitUUID,
  DestinationHandlingUnit,
  WhseTaskDestStorageBinDtmndBy,
  WrhsTaskSubsystemTransmn,
  WhseTaskPlannedProcessingTime,
  WhseTaskProcgTimeDetnTimeUnit,
  WhseTaskRefToValueAddedService,
  BatchChangeIsNotAllowed,
  EWMReferenceDocumentCategory,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  Wave,
  WaveItem,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  DocumentReltdStockDocCat,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  StockIdentificationNumber,
  KitItemIsCreatedAutomatically,
  WarehouseTaskUUID,
  IsDocumentaryBatch,
  ConveyorTechniqueSegment,
  EWMProductionSupplyArea,
  ProductionOrder,
  Kanban,
  StockKeepingAlternativeUoM,
  ActivityArea,
  _ActivityArea._Text[1:Language = $session.system_language].ActivityAreaName AS ActivityAreaName,
  Queue,
  WarehouseOrder,
  LogicalRecordProgramName,
  LogicalRecordTransactionCode,
  EWMDummyFuncForStructureExtn,
  CertificateText,
  WhseTaskLastChgUTCDateTime,
  WarehouseActivityType,
  WhseTaskPlannedClosingDateTime,
  ConfirmedByUser,
  ConfirmationUTCDateTime,
  Processor,
  WarehouseTaskExceptionCode,
  _ExceptionCode._Text[1:Language = $session.system_language].ExceptionCodeName AS ExceptionCodeName,
  BusinessContext,
  BusinessContextExecutionStep,
  ExecutingResourceGroup,
  ExecutingResourceType,
  ActualQuantityInBaseUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInAltvUnit,
  DifferenceQuantityInBaseUnit,
  WhseTaskSortingSequenceValue,
  WarehouseOrderSequenceValue,
  WarehouseOrderActivityArea,
  WarehouseOrderCreationRule,
  HomogeneousFullPalletPick,
  EWMRoute,
  EWMCanceledWarehouseTask
FROM I_EWM_WarehouseTask_2
LEFT OUTER JOIN I_ProductText AS _MaterialText ON ProductName = _MaterialText.Product  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseTaskStatusText AS _WhseTaskStatusTxt ON WarehouseTaskStatus = _WhseTaskStatusTxt.WarehouseTaskStatus AND _WhseTaskStatusTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EWM_WrhsProcType_2 AS _WhseProcType ON EWMWarehouse = _WhseProcType.EWMWarehouse AND WarehouseProcessType = _WhseProcType.WarehouseProcessType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockType_2 AS _StockType ON EWMWarehouse = _StockType.EWMWarehouse AND EWMStockType = _StockType.EWMStockType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType_2 AS _SrcStorageType ON EWMWarehouse = _SrcStorageType.EWMWarehouse AND SourceStorageType = _SrcStorageType.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageType_2 AS _DstStorageType ON EWMWarehouse = _DstStorageType.EWMWarehouse AND DestinationStorageType = _DstStorageType.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_ActivityArea_2 AS _ActivityArea ON EWMWarehouse = _ActivityArea.EWMWarehouse AND ActivityArea = _ActivityArea.ActivityArea  -- association [0..*]
LEFT OUTER JOIN I_EWM_ExceptionCode_2 AS _ExceptionCode ON EWMWarehouse = _ExceptionCode.EWMWarehouse AND WarehouseTaskExceptionCode = _ExceptionCode.WarehouseTaskExceptionCode  -- association [0..*]
;