I_EWM_WarehouseTaskLog

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_WarehouseTaskLog.
-- 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_WarehouseTaskLog AS
SELECT
  lgnum AS EWMWarehouse,
  cast ( tanum as /scwm/tanum_conv_alpha preserving type ) AS WarehouseTask,
  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 /scwm/de_created_dt_noconv preserving type ) AS WhseTaskCrtnUTCDateTime,
  wtcode AS WarehouseTaskCodes,
  prsrc AS ExecutingResource,
  reason AS WarehouseMovementsReason,
  priority AS EWMWarehouseTaskPriority,
  guid_stock AS StockItemUUID,
  idx_stock AS CurrentNumberOfKeyTable,
  cast( matid as matid_no_conv preserving type ) AS ProductUUID,
  _Material.Product AS ProductName,
  batchid AS BatchUUID,
  cat AS EWMStockType,
  stock_doccat AS StockDocumentCategory,
  stock_docno AS StockDocumentNumber,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  stock_itmno AS StockItemNumber,
  doccat AS EWMDocumentCategory,
  stock_usage AS EWMStockUsage,
  owner AS EWMStockOwner,
  owner_role AS StockOwnerPartnerRole,
  entitled AS EntitledToDisposeParty,
  entitled_role AS EntitledToDisposePartnerRole,
  stock_cnt AS CounterForStockSeparation,
  charg AS Batch,
  req_seg_long AS RequirementSegment,
  stk_seg_long AS StockSegment,
  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 EWMPutAwayPhysInvtryPlnSts,
  lowchk_inv_p AS EWMWhseTskLowStkChkPlnSts,
  vfdat AS ShelfLifeExpirationDate,
  cast ( wdatu as /scwm/lvs_wdatu_noconv preserving type ) AS WhseTaskGoodsReceiptDateTime,
  coo AS CountryOfOrigin,
  hazmat AS HazardousSubstanceIndicator,
  insptyp AS WhseTaskQualityInspectionType,
  inspid AS QualityInspectionDocUUID,
  idplate AS StockIdentificationOfWhseTask,
  dstgrp AS EWMConsolidationGroup,
  vltyp AS SourceStorageType,
  vlber AS SourceStorageSection,
  vlpla AS SourceStorageBin,
  slogpos AS SourceHndlgUnitLogicalPosition,
  srsrc AS SourceResource,
  stu_num AS SourceTransportationUnit,
  sloc_type AS EWMSourceLocationType,
  sguid_hu AS SourceHandlingUnitUUID,
  cast(vlenr as ewm_de_sourcehuident preserving type ) AS SourceHandlingUnit,
  nltyp AS DestinationStorageType,
  nlber AS DestinationStorageSection,
  nlpla AS DestinationStorageBin,
  dlogpos AS DestHndlgUnitLogicalPosition,
  drsrc AS DestinationResource,
  dtu_num AS DestinationTransportationUnit,
  dloc_type AS EWMDestinationLocationType,
  dguid_hu AS DestinationHandlingUnitUUID,
  cast(nlenr as ewm_de_destinationhuident preserving type ) AS DestinationHandlingUnit,
  destd AS WhseTaskDestStorageBinDtmndBy,
  kzsub AS WrhsTaskSubsystemTransmn,
  solpo AS WhseTaskPlannedProcessingTime,
  zeiei AS WhseTaskProcgTimeDetnTimeUnit,
  vas AS WhseTaskRefToValueAddedService,
  jit_relevance AS EWMWarehouseTaskIsJITRelevant,
  batch_nochg AS BatchChangeIsNotAllowed,
  rdoccat AS EWMReferenceDocumentCategory,
  rdocid AS ReferenceDocumentUUID,
  ritmid AS ReferenceDocumentItemUUID,
  cast( wave as numc10 preserving type ) AS Wave,
  cast( wave as ewm_de_wave preserving type ) AS EWMWave,
  cast(wave_itm as numc06 preserving type ) AS WaveItem,
  cast(wave_itm as ewm_de_waveitem preserving type ) AS EWMWaveItem,
  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 EWMProductionSupplyArea,
  prod_order AS ProductionOrder,
  cast( created_at_wh as timestamp preserving type ) AS WhseTaskCrtnWhseTmznDateTime,
  cast( changed_at_wh as timestamp preserving type ) AS WhseTaskChgWhseTmznDateTime,
  cast(kanban as pkkey ) AS Kanban,
  suom AS StockKeepingAlternativeUoM,
  aarea AS ActivityArea,
  Queue,
  cast ( who as /scwm/de_who_conv_alpha 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 WhseTaskLastChgUTCDateTime,
  mmim_mblnr AS MaterialDocument,
  mmim_zeile AS MaterialDocumentItem,
  mmim_mjahr AS MaterialDocumentYear,
  mmim_budat_migration AS PostingDate,
  act_type AS WarehouseActivityType,
  hu_empty AS HandlingUnitIsEmpty,
  stokey1 AS WhseTaskHazardRating1,
  stokey2 AS WhseTaskHazardRating2,
  vanzl AS NumberOfHndlgUnitsToBeRemoved,
  nanzl AS NumberOfHndlgUnitsToBePutAway,
  homve AS HomogeneousFullPalletPick,
  movehu AS SourceHandlingUnitMovement,
  posty AS WarehouseTaskType,
  negat AS WhseTaskNgtvStockQuantityCode,
  pick_all AS WithdrawAllStockFromStorageBin,
  routeto AS WhseTaskCrtedForStorageControl,
  route AS EWMRoute,
  rtext AS WarehouseRequestDocHasTxt,
  whcount AS WhseTaskCountIsRequested,
  gr_open AS GoodsReceiptIsNotYetPosted,
  cast( noitm as abap.numc( 4 )) AS NumberOfConfdWhseTaskItems,
  str_repl AS ReplenishmentStrategy,
  pick_comp_dt AS WhseTaskPlannedClosingDateTime,
  wklid AS WorkloadIdentification,
  tologno AS WarehouseTaskLogNumber,
  diffsrc AS DiffsAreOnlyAllowedInSrceBin,
  areawho AS WarehouseOrderActivityArea,
  wcr AS WarehouseOrderCreationRule,
  hutypgrp AS HandlingUnitTypeGroup,
  wavecat AS WaveCategory,
  wavecat AS EWMWaveCategory,
  huid AS HandlingUnitUUID,
  shiphuid AS ShippingHandlingUnitUUID,
  squant_set AS SourceQuantityIdnIsPredefined,
  guid_stock0 AS StockItem0UUID,
  dput_gr AS DistributivePutAwayFromGRZone,
  check_capa AS CapacityIsToBeChecked,
  cwrel AS ProductIsCatchWeightRelevant,
  conf_error AS IsWhseTaskConfirmationError,
  ord_cancel AS HasItemWithReducedOrder,
  cast( pick_comp_dt_wh as timestamp preserving type ) AS WhseTskPlndClsgWhseTmznDteTme,
  pathseq AS WhseTaskSortingSequenceValue,
  whoseq AS WarehouseOrderSequenceValue
FROM /scwm/ordim_l AS ordiml
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]
;