P_EWM_WhseDocumentItem

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_WhseDocumentItem.
-- 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_WhseDocumentItem AS
SELECT
  EWMWarehouse,
  EWMWarehouseDocument,
  EWMWarehouseDocumentItem,
  WarehouseTimeZone,
  LogicalRecordTransactionCode,
  EWMWhseDocItemIsCancelable,
  EWMWhseDocGoodsReceiptDate,
  Product,
  _ProductText[1:Language = $session.system_language].ProductName AS ProductDescription,
  Batch,
  EWMStockType,
  StockDocumentCategory,
  StockDocumentNumber,
  StockItemNumber,
  ExternalStockDocumentNumber,
  EWMStockUsage,
  EWMStockOwner,
  EntitledToDisposeParty,
  ShelfLifeExpirationDate,
  CountryOfOrigin,
  WhseTaskCapacityConsumption,
  WhseTaskCrtnWhseTmznDateTime,
  WhseTaskCrtnUTCDateTime,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as ewm_de_createdbyname preserving type ) AS CreatedByUserName,
  _User.UserDescription AS test,
  WhseTaskConfWhseTmznDateTime,
  ConfirmationUTCDateTime,
  ConfirmedByUser,
  cast(_ConfirmedByUser.UserDescription as ewm_de_confirmedbyname preserving type ) AS ConfirmedByUserName,
  IsHandlingUnitWarehouseTask,
  WarehouseProcessType,
  WarehouseProcessCategory,
  EWMWarehouseDocumentItemStatus,
  WarehouseMovementsReason,
  WarehouseMovementsText,
  EWMGoodsMovementProcess,
  ActualQuantityInBaseUnit,
  BaseUnit,
  ActualQuantityInAltvUnit,
  AlternativeUnit,
  EWMValuationQuantity,
  EWMValuationQuantityUnit,
  EWMValuationQuantityStatus,
  EWMDifferenceValuationQuantity,
  EWMDiffValuationQuantityStatus,
  EWMAccountAssignmentCategory,
  EWMAccountAssignmentObject,
  EWMAccountAssignmentSubObject,
  WhseTaskNetWeight,
  WhseTaskNetWeightUnitOfMeasure,
  WhseTaskNetVolume,
  WhseTaskNetVolumeUnitOfMeasure,
  EWMCanceledWarehouseDocument,
  ProductionOrder,
  Kanban,
  EWMWarehouseTaskIsJITRelevant,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  PostingDate,
  EWMWarehouseDocumentItemUUID,
  SourceStorageType,
  SourceStorageSection,
  SourceStorageBin,
  SourceHandlingUnit,
  DestinationStorageType,
  DestinationStorageSection,
  DestinationStorageBin,
  DestinationHandlingUnit,
  EWMStorageType,
  EWMStorageSection,
  EWMStorageBin,
  HandlingUnitNumber
FROM P_EWM_WhseDocument
LEFT OUTER JOIN I_EWM_WarehouseNumberText_2 AS _WarehouseText ON EWMWarehouse = _WarehouseText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockTypeText_2 AS _EWMStockTypeText ON EWMStockType = _EWMStockTypeText.EWMStockType AND EWMWarehouse = _EWMStockTypeText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockDocCategoryText AS _StockDocCategoryText ON StockDocumentCategory = _StockDocCategoryText.StockDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockUsageText_2 AS _EWMStockUsageText ON EWMStockUsage = _EWMStockUsageText.EWMStockUsage  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _EWMStockOwnerText ON EWMStockOwner = _EWMStockOwnerText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _EWMEntitledToDisposePartyText ON EntitledToDisposeParty = _EWMEntitledToDisposePartyText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON CountryOfOrigin = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_EWM_WrhsProcTypeText_2 AS _WhseProcTypeText ON EWMWarehouse = _WhseProcTypeText.EWMWarehouse AND WarehouseProcessType = _WhseProcTypeText.WarehouseProcessType  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseProcessCategoryText AS _WhseProcCategoryText ON WarehouseProcessCategory = _WhseProcCategoryText.WarehouseProcessCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_WarehouseTaskStatusText AS _WhseDocumentItemStatusText ON EWMWarehouseDocumentItemStatus = _WhseDocumentItemStatusText.WarehouseTaskStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseMovementsReasonText AS _WarehouseMovementReasonText ON EWMWarehouse = _WarehouseMovementReasonText.EWMWarehouse AND WarehouseMovementsReason = _WarehouseMovementReasonText.WarehouseMovementsReason  -- association [0..*]
LEFT OUTER JOIN I_EWM_ValuationQuantityStatusT AS _ValuationQuantityStatusText ON EWMValuationQuantityStatus = _ValuationQuantityStatusText.EWMValuationQuantityStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_ValuationQuantityStatusT AS _EWMDiffValuationQntyStatusT ON EWMValuationQuantityStatus = _EWMDiffValuationQntyStatusT.EWMValuationQuantityStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_AccountAssgmtCatText AS _AccountAssgmtCatText ON EWMAccountAssignmentCategory = _AccountAssgmtCatText.EWMAccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageTypeText_2 AS _SrcStorageTypeText ON EWMWarehouse = _SrcStorageTypeText.EWMWarehouse AND SourceStorageType = _SrcStorageTypeText.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageTypeText_2 AS _DstStorageTypeText ON EWMWarehouse = _DstStorageTypeText.EWMWarehouse AND DestinationStorageType = _DstStorageTypeText.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageTypeText_2 AS _EWMStorageTypeText ON EWMWarehouse = _EWMStorageTypeText.EWMWarehouse AND EWMStorageType = _EWMStorageTypeText.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText_2 AS _SrcStorageSectionText ON EWMWarehouse = _SrcStorageSectionText.EWMWarehouse AND EWMStorageType = _SrcStorageSectionText.EWMStorageType AND SourceStorageSection = _SrcStorageSectionText.EWMStorageSection  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText_2 AS _DstStorageSectionText ON EWMWarehouse = _DstStorageSectionText.EWMWarehouse AND EWMStorageType = _DstStorageSectionText.EWMStorageType AND DestinationStorageSection = _DstStorageSectionText.EWMStorageSection  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText_2 AS _EWMStorageSectionText ON EWMWarehouse = _EWMStorageSectionText.EWMWarehouse AND EWMStorageType = _EWMStorageSectionText.EWMStorageType AND EWMStorageSection = _EWMStorageSectionText.EWMStorageSection  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID association[0..1] to I_User as _User on CreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ConfirmedByUser ON ConfirmedByUser = _ConfirmedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureBaseUnit ON BaseUnit = _UnitOfMeasureBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureAlternativeUnit ON AlternativeUnit = _UnitOfMeasureAlternativeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureValnQtyUnit ON EWMValuationQuantityUnit = _UnitOfMeasureValnQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureNetVolumeUoM ON WhseTaskNetVolumeUnitOfMeasure = _UnitOfMeasureNetVolumeUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureNetWeightUoM ON WhseTaskNetWeightUnitOfMeasure = _UnitOfMeasureNetWeightUoM.UnitOfMeasure  -- association [0..1]
;