P_EWM_WhseDocument

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_WhseDocument.
-- 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_WhseDocument AS
SELECT
  EWMWarehouse,
  cast( WarehouseTask as ewm_de_whsedocument preserving type ) AS EWMWarehouseDocument,
  cast( WarehouseTaskItem as ewm_de_warehousedocumentitem preserving type ) AS EWMWarehouseDocumentItem,
  _WarehouseNumber.TimeZoneID AS WarehouseTimeZone,
  ProductName AS Product,
  Batch,
  EWMStockType,
  cast( StockDocumentCategory as ewm_de_stockdocumentcat preserving type ) AS StockDocumentCategory,
  StockItemNumber,
  EWMStockUsage,
  cast( EWMStockOwner as ewm_de_stockowner preserving type ) AS EWMStockOwner,
  EntitledToDisposeParty,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  WhseTaskCapacityConsumption,
  cast( WhseTaskCrtnWhseTmznDateTime as ewm_de_created_dt_wh_no_conv preserving type ) AS WhseTaskCrtnWhseTmznDateTime,
  cast( WhseTaskCrtnUTCDateTime as ewm_de_created_dt_wh_no_conv) AS WhseTaskCrtnUTCDateTime,
  CreatedByUser,
  cast( WhseTaskConfWhseTmznDateTime as ewm_de_confirmed_dt_wh_no_conv preserving type ) AS WhseTaskConfWhseTmznDateTime,
  cast( ConfirmationUTCDateTime as ewm_de_confirmed_dt_wh_no_conv) AS ConfirmationUTCDateTime,
  ConfirmedByUser,
  WhseTaskGoodsReceiptDateTime,
  IsHandlingUnitWarehouseTask,
  cast(WarehouseProcessType as ewm_de_warehouseprocesstype preserving type ) AS WarehouseProcessType,
  cast(WarehouseProcessCategory as ewm_de_whseprocesscategory preserving type ) AS WarehouseProcessCategory,
  cast( WarehouseTaskStatus as ewm_de_whsedocitemstatus preserving type ) AS EWMWarehouseDocumentItemStatus,
  WarehouseMovementsReason,
  WarehouseMovementsText,
  EWMGoodsMovementProcess,
  cast( ActualQuantityInBaseUnit as ewm_de_actqtyinbaseuom preserving type ) AS ActualQuantityInBaseUnit,
  BaseUnit,
  cast( ActualQuantityInAltvUnit as ewm_de_actqtyinaltuom preserving type ) AS ActualQuantityInAltvUnit,
  AlternativeUnit,
  cast( EWMValuationQuantity as ewm_de_valuationquantity preserving type ) AS EWMValuationQuantity,
  EWMValuationQuantityUnit,
  cast( EWMValuationQuantityStatus as ewm_de_valuationquantitystatus preserving type ) AS EWMValuationQuantityStatus,
  cast( EWMDifferenceValuationQuantity as ewm_de_differencevaluationqty preserving type ) AS EWMDifferenceValuationQuantity,
  cast( EWMDiffValuationQuantityStatus as ewm_de_diffvaluationqtystatus preserving type ) AS EWMDiffValuationQuantityStatus,
  cast( EWMAccountAssignmentCategory as ewm_de_acc_cat preserving type ) AS EWMAccountAssignmentCategory,
  cast( EWMAccountAssignmentSubObject as ewm_de_accsubobject preserving type ) AS EWMAccountAssignmentSubObject,
  NetWeight AS WhseTaskNetWeight,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetVolume,
  WhseTaskNetVolumeUnitOfMeasure,
  cast( EWMCanceledWarehouseTask as ewm_de_canceledwhsedoc preserving type ) AS EWMCanceledWarehouseDocument,
  ProductionOrder,
  Kanban,
  EWMWarehouseTaskIsJITRelevant,
  MaterialDocument,
  cast( MaterialDocumentYear as ewm_de_materialdocumentyear preserving type ) AS MaterialDocumentYear,
  cast( MaterialDocumentItem as ewm_de_materialdocumentitem preserving type ) AS MaterialDocumentItem,
  cast( PostingDate as ewm_de_postingdate preserving type ) AS PostingDate,
  LogicalRecordTransactionCode,
  cast(WarehouseTaskUUID as ewm_de_whsedocumentitemuuid preserving type ) AS EWMWarehouseDocumentItemUUID,
  SourceStorageType,
  cast( SourceStorageSection as ewm_de_sourcestoragesection preserving type ) AS SourceStorageSection,
  SourceStorageBin,
  cast( SourceHandlingUnit as ewm_de_sourcehuident preserving type ) AS SourceHandlingUnit,
  cast( DestinationStorageType as ewm_de_destinationstoragetype preserving type ) AS DestinationStorageType,
  cast( DestinationStorageSection as ewm_de_deststoragesection preserving type ) AS DestinationStorageSection,
  DestinationStorageBin,
  cast( DestinationHandlingUnit as ewm_de_destinationhuident preserving type ) AS DestinationHandlingUnit
FROM I_EWM_ConfirmedWarehouseTask_2
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _WarehouseNumber ON EWMWarehouse = _WarehouseNumber.EWMWarehouse  -- association [0..1]
;