I_EWM_ConfirmedWarehouseTask

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_ConfirmedWarehouseTask.
-- 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: IEWMCONFIRMEDWT

CREATE VIEW I_EWM_ConfirmedWarehouseTask AS
SELECT
  lgnum AS Warehouse,
  cast( tanum as numc12 preserving type) AS WarehouseTask,
  cast(tapos as numc4 preserving type) AS WarehouseTaskItem,
  flghuto AS IsHandlingUnitWarehouseTask,
  procty AS WarehouseProcessType,
  trart AS WarehouseProcessCategory,
  prces AS StorageProcess,
  procs AS ExternalStorageProcessStep,
  tostat AS WarehouseTaskStatus,
  created_by AS CreatedByUser,
  cast ( created_at as timestamp preserving type ) AS CreationDateTime,
  wtcode AS WarehouseTaskCodes,
  prsrc AS ExecutingResource,
  reason AS WarehouseMovementsReason,
  priority AS PriorityCode,
  guid_stock AS StockItemUUID,
  idx_stock AS CurrentNumberOfKeyTable,
  matid AS ProductUUID,
  _Material.Product AS ProductName,
  batchid AS ProductBatch,
  cat AS StockType,
  stock_doccat AS StockDocumentCategory,
  stock_docno AS StockDocumentNumber,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  stock_itmno AS StockItemNumber,
  doccat AS DocumentCategory,
  stock_usage AS StockUsage,
  owner AS StockOwner,
  owner_role AS StockOwnerPartnerRole,
  entitled AS EntitledToDisposeParty,
  entitled_role AS EntitledToDisposePartnerRole,
  stock_cnt AS CounterForStockSeparation,
  charg AS Batch,
  meins AS BaseUnit,
  altme AS AlternativeUnit,
  vsolm AS TargetQuantityInBaseUnit,
  vsola AS TargetQuantityInAltvUnit,
  kquan AS WhseTaskRetentionQuantity,
  letyp AS HandlingUnitType,
  weight AS NetWeight,
  unit_w AS WhseTaskNetWeightUnitOfMeasure,
  volum AS WhseTaskNetVolume,
  unit_v AS WhseTaskNetVolumeUnitOfMeasure,
  capa AS WhseTaskCapacityConsumption,
  place_inv_p AS PutAwayPhysInventoryIsPlanned,
  lowchk_inv_p AS WhseTaskLowStockCheckIsPlanned,
  vfdat AS ShelfLifeExpirationDate,
  cast ( wdatu as timestamp preserving type ) AS WhseTaskGoodsReceiptDateTime,
  coo AS CountryOfOrigin,
  hazmat AS HazardousSubstanceIndicator,
  insptyp AS WhseTaskQualityInspectionType,
  inspid AS QualityInspectionDocUUID,
  idplate AS StockIdentificationOfWhseTask,
  dstgrp AS ConsolidationGroup,
  vltyp AS SourceStorageType,
  vlber AS SourceStorageSection,
  vlpla AS SourceStorageBin,
  slogpos AS SourceHndlgUnitLogicalPosition,
  srsrc AS SourceResource,
  stu_num AS SourceTransportationUnit,
  sloc_type AS SourceLocationType,
  sguid_hu AS SourceHandlingUnitUUID,
  vlenr AS SourceHandlingUnit,
  nltyp AS DestinationStorageType,
  nlber AS DestinationStorageSection,
  nlpla AS DestinationStorageBin,
  dlogpos AS DestHndlgUnitLogicalPosition,
  drsrc AS DestinationResource,
  dtu_num AS DestinationTransportationUnit,
  dloc_type AS DestinationLocationType,
  dguid_hu AS DestinationHandlingUnitUUID,
  nlenr AS DestinationHandlingUnit,
  destd AS WhseTaskDestStorageBinDtmndBy,
  kzsub AS WrhsTaskSubsystemTransmn,
  solpo AS WhseTaskPlannedProcessingTime,
  zeiei AS WhseTaskProcgTimeDetnTimeUnit,
  vas AS WhseTaskRefToValueAddedService,
  batch_nochg AS BatchChangeIsNotAllowed,
  rdoccat AS ReferenceDocumentCategory,
  rdocid AS ReferenceDocumentUUID,
  ritmid AS ReferenceDocumentItemUUID,
  cast( wave as numc10 preserving type ) AS Wave,
  cast(wave_itm as numc06 preserving type ) AS WaveItem,
  l2ska AS WhseTaskTwoStepPickingType,
  l2skr AS WhseTaskTwoStepPickingRlvnce,
  qdoccat AS DocumentReltdStockDocCat,
  qdocid AS DocumentReltdStockDocUUID,
  qitmid AS DocumentReltdStockDocItemUUID,
  qidplate AS StockIdentificationNumber,
  kit_crea AS KitItemIsCreatedAutomatically,
  guid_to AS WarehouseTaskUUID,
  dbind AS IsDocumentaryBatch,
  mfs_cs AS ConveyorTechniqueSegment,
  psa AS ProductionSupplyArea,
  prod_order AS ProductionOrder,
  cast( created_at_wh as timestamp preserving type ) AS WhseTaskCrtnWhseTmznDateTime,
  cast( changed_at_wh as timestamp preserving type ) AS WhseTaskChgWhseTmznDateTime,
  Kanban,
  suom AS StockKeepingAlternativeUoM,
  aarea AS ActivityArea,
  Queue,
  cast( who as numc10 preserving type ) AS WarehouseOrder,
  repid AS LogicalRecordProgramName,
  tcode AS LogicalRecordTransactionCode,
  ordim_dummy AS EWMDummyFuncForStructureExtn,
  zeugn AS CertificateText,
  cast( changed_at as timestamp preserving type ) AS LastChangeDateTime,
  confirmed_by AS ConfirmedByUser,
  cast ( confirmed_at as timestamp preserving type ) AS ConfirmationUTCDateTime,
  cast( processor as char12 preserving type) AS Processor,
  exccode AS WarehouseTaskExceptionCode,
  buscon AS BusinessContext,
  exec_step AS BusinessContextExecutionStep,
  nistm AS ActualQuantityInBaseUnit,
  nista AS ActualQuantityInAltvUnit,
  dmeng AS DifferenceQuantityInBaseUnit,
  dmena AS DifferenceQuantityInAltvUnit,
  cast( confirmed_at_wh as timestamp preserving type ) AS WhseTaskConfWhseTmznDateTime
FROM /scwm/ordim_c
LEFT OUTER JOIN I_EWM_ExecutionResource AS _Resource ON Warehouse = _Resource.Warehouse AND ExecutingResource = _Resource.ExecutingResource  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON ProductUUID = _Material.ProductUUID AND _Material.ProdSupChnMgmtUUID22 is not initial  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON StockDocumentCategory = 'PJS' AND StockDocumentNumber = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;