I_EWM_WarehouseTaskT

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

CREATE VIEW I_EWM_WarehouseTaskT AS
SELECT
  Warehouse,
  WarehouseTask,
  WarehouseTaskItem,
  IsHandlingUnitWarehouseTask,
  WarehouseProcessType,
  _WhseProcType._Text[1:Language = $session.system_language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  WarehouseProcessCategory,
  StorageProcess,
  ExternalStorageProcessStep,
  WarehouseTaskStatus,
  _WhseTaskStatusTxt.WarehouseTaskStatusName AS WarehouseTaskStatusName,
  CreatedByUser,
  CreationDateTime,
  WarehouseTaskCodes,
  ExecutingResource,
  WarehouseMovementsReason,
  PriorityCode,
  StockItemUUID,
  CurrentNumberOfKeyTable,
  ProductUUID,
  ProductName,
  _MaterialText[1:Language = $session.system_language].ProductName AS ProductDescription,
  ProductBatch,
  StockType,
  case when _StockType._Text[1:Language = $session.system_language].StockTypeName is not null then _StockType._Text[1:Language = $session.system_language].StockTypeName else _StockType._WhseIndepText[1:Language = $session.system_language].StockTypeName end as StockTypeName AS StockTypeNameendasStockTypeName,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  DocumentCategory,
  StockUsage,
  StockOwner,
  StockOwnerPartnerRole,
  EntitledToDisposeParty,
  EntitledToDisposePartnerRole,
  CounterForStockSeparation,
  Batch,
  BaseUnit,
  AlternativeUnit,
  TargetQuantityInBaseUnit,
  TargetQuantityInAltvUnit,
  WhseTaskRetentionQuantity,
  HandlingUnitType,
  NetWeight,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetVolume,
  WhseTaskNetVolumeUnitOfMeasure,
  WhseTaskCapacityConsumption,
  PutAwayPhysInventoryIsPlanned,
  WhseTaskLowStockCheckIsPlanned,
  ShelfLifeExpirationDate,
  WhseTaskGoodsReceiptDateTime,
  CountryOfOrigin,
  HazardousSubstanceIndicator,
  WhseTaskQualityInspectionType,
  QualityInspectionDocUUID,
  StockIdentificationOfWhseTask,
  ConsolidationGroup,
  SourceStorageType,
  _SrcStorageType._Text[1:Language = $session.system_language].StorageTypeName AS SourceStorageTypeName,
  SourceStorageSection,
  SourceStorageBin,
  SourceHndlgUnitLogicalPosition,
  SourceResource,
  SourceTransportationUnit,
  SourceLocationType AS EWMSourceLocationType,
  SourceHandlingUnitUUID,
  SourceHandlingUnit,
  DestinationStorageType,
  _DstStorageType._Text[1:Language = $session.system_language].StorageTypeName AS DestinationStorageTypeName,
  DestinationStorageSection,
  DestinationStorageBin,
  DestHndlgUnitLogicalPosition,
  DestinationResource,
  DestinationTransportationUnit,
  DestinationLocationType AS EWMDestinationLocationType,
  DestinationHandlingUnitUUID,
  DestinationHandlingUnit,
  WhseTaskDestStorageBinDtmndBy,
  WrhsTaskSubsystemTransmn,
  WhseTaskPlannedProcessingTime,
  WhseTaskProcgTimeDetnTimeUnit,
  WhseTaskRefToValueAddedService,
  BatchChangeIsNotAllowed,
  ReferenceDocumentCategory,
  ReferenceDocumentUUID,
  ReferenceDocumentItemUUID,
  Wave,
  WaveItem,
  WhseTaskTwoStepPickingType,
  WhseTaskTwoStepPickingRlvnce,
  DocumentReltdStockDocCat,
  DocumentReltdStockDocUUID,
  DocumentReltdStockDocItemUUID,
  StockIdentificationNumber,
  KitItemIsCreatedAutomatically,
  WarehouseTaskUUID,
  IsDocumentaryBatch,
  ConveyorTechniqueSegment,
  ProductionSupplyArea,
  ProductionOrder,
  Kanban,
  StockKeepingAlternativeUoM,
  ActivityArea,
  _ActivityArea._Text[1:Language = $session.system_language].ActivityAreaName AS ActivityAreaName,
  Queue,
  WarehouseOrder,
  LogicalRecordProgramName,
  LogicalRecordTransactionCode,
  EWMDummyFuncForStructureExtn,
  CertificateText,
  LastChangeDateTime,
  WarehouseActivityType,
  WhseTaskPlannedClosingDateTime,
  ConfirmedByUser,
  ConfirmationUTCDateTime,
  Processor,
  WarehouseTaskExceptionCode,
  _ExceptionCode._Text[1:Language = $session.system_language].ExceptionCodeName AS ExceptionCodeName,
  BusinessContext,
  BusinessContextExecutionStep,
  ExecutingResourceGroup,
  ExecutingResourceType,
  ActualQuantityInBaseUnit,
  ActualQuantityInAltvUnit,
  DifferenceQuantityInAltvUnit,
  DifferenceQuantityInBaseUnit
FROM I_EWM_WarehouseTask
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 AS _WhseProcType ON Warehouse = _WhseProcType.Warehouse AND WarehouseProcessType = _WhseProcType.WarehouseProcessType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockType AS _StockType ON Warehouse = _StockType.Warehouse AND StockType = _StockType.StockType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType AS _SrcStorageType ON Warehouse = _SrcStorageType.Warehouse AND SourceStorageType = _SrcStorageType.StorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageType AS _DstStorageType ON Warehouse = _DstStorageType.Warehouse AND DestinationStorageType = _DstStorageType.StorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_ActivityArea AS _ActivityArea ON Warehouse = _ActivityArea.Warehouse AND ActivityArea = _ActivityArea.ActivityArea  -- association [0..*]
LEFT OUTER JOIN I_EWM_ExceptionCode AS _ExceptionCode ON Warehouse = _ExceptionCode.Warehouse AND WarehouseTaskExceptionCode = _ExceptionCode.WarehouseTaskExceptionCode  -- association [0..*]
;