I_EWM_ProdnMatlReqItem

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_ProdnMatlReqItem.
-- 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_ProdnMatlReqItem AS
SELECT
  EWMProductionMaterialRequest,
  EWMProductionMaterialReqItem,
  EWMProductionMaterialReqUUID,
  EWMProductionMatlReqItemUUID,
  EWMProdnMatlReqDocCategory,
  EWMProdnMatlReqItemCategory,
  EWMProductionMatlReqItemType,
  EWMProdnMatlReqCrtnUTCDateTime,
  EWMProdnMatlReqCreatedByUser,
  EWMDelivLastChangeUTCDateTime,
  EWMProdnMatlReqLastChgdByUser,
  _PlndCompRqmtStrtUTCDateTime.DeliveryRelatedStartDateTime AS EWMPlndCompRqmtStrtUTCDateTime,
  ProductUUID,
  Batch,
  ProductQuantity,
  QuantityUnit,
  EWMStockUsage,
  EWMStockType,
  EntitledToDisposeParty,
  _Entitled.BusinessPartnerName AS EntitledToDisposePartyName,
  EWMStockOwner,
  _StockOwner.BusinessPartnerName AS EWMStockOwnerName,
  WBSElementInternalID,
  WBSElementExternalID,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  cast( ltrim( _Reservation.EWMWhseReqRefDocumentNumber, '0' ) as rsnum ) AS Reservation,
  cast( ltrim( _Reservation.EWMWhseRequestRefDocumentItem, '0' ) as pph_rspos ) AS ReservationItem,
  ReservationType,
  WarehouseProcessType,
  EWMMovementControl,
  EWMStagingMethod,
  EWMProductionSupplyArea,
  EWMGoodsMovementStorageBin,
  BatchClassification,
  BatchClass,
  EWMBackflushIsActive,
  Operation,
  OperationDescription,
  WorkCenter,
  EWMProdnMatlReqItemIsDeleted,
  CompletionStatus,
  EWMPlannedStagingStatus,
  EWMStagingStatus,
  EWMManufacturingOrderStatus,
  EWMGoodsMovementLockStatus,
  EWMStagingLockStatus,
  EWMItmInconsistencyBlockStatus,
  OverallBlockStatus
FROM I_EWM_ProdnMatlReqItmBasic
LEFT OUTER JOIN I_EWM_DeliveryDateAndTime AS _PlndCompRqmtStrtUTCDateTime ON EWMProductionMaterialReqUUID = _PlndCompRqmtStrtUTCDateTime.DeliveryOrderUUID AND EWMProductionMatlReqItemUUID = _PlndCompRqmtStrtUTCDateTime.DeliveryOrderItemUUID AND EWMProdnMatlReqDocCategory = _PlndCompRqmtStrtUTCDateTime.EWMDeliveryDocumentCategory AND _PlndCompRqmtStrtUTCDateTime.DeliveryDateTimeType = 'SCMPREQ' AND _PlndCompRqmtStrtUTCDateTime.DeliveryDateTimeCategory = 'PLAN'  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Entitled ON EntitledToDisposeParty = _Entitled.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _StockOwner ON EWMStockOwner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestRefDoc AS _ManufacturingOrder ON EWMProductionMaterialReqUUID = _ManufacturingOrder.EWMWarehouseRequestUUID AND EWMProdnMatlReqDocCategory = _ManufacturingOrder.EWMWhseRequestDocumentCategory AND _ManufacturingOrder.EWMReferenceDocumentCategory = 'PPO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestRefDoc AS _Reservation ON EWMProductionMaterialReqUUID = _Reservation.EWMWarehouseRequestUUID AND EWMProductionMatlReqItemUUID = _Reservation.EWMWarehouseRequestItemUUID AND EWMProdnMatlReqDocCategory = _Reservation.EWMWhseRequestDocumentCategory AND _Reservation.EWMReferenceDocumentCategory = 'RES'  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemCatText_2 AS _EWMProdnMatlReqItmCatTxt ON EWMProdnMatlReqItemCategory = _EWMProdnMatlReqItmCatTxt.EWMInboundDeliveryItemCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_DeliveryItemTypeText_2 AS _EWMProdnMatlReqItemTypeTxt ON EWMProdnMatlReqDocCategory = _EWMProdnMatlReqItemTypeTxt.EWMDeliveryDocumentCategory AND EWMProductionMatlReqItemType = _EWMProdnMatlReqItemTypeTxt.DeliveryItemType  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductTxt ON Product = _ProductTxt.Product  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockTypeText_2 AS _EWMStockTypeTxt ON EWMWarehouse = _EWMStockTypeTxt.EWMWarehouse AND EWMStockType = _EWMStockTypeTxt.EWMStockType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockUsageText_2 AS _EWMStockUsageTxt ON EWMStockUsage = _EWMStockUsageTxt.EWMStockUsage  -- association [0..*]
LEFT OUTER JOIN I_EWM_WrhsProcTypeText_2 AS _EWMWarehouseProcessTypeTxt ON EWMWarehouse = _EWMWarehouseProcessTypeTxt.EWMWarehouse AND WarehouseProcessType = _EWMWarehouseProcessTypeTxt.WarehouseProcessType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StagingMethodText AS _EWMStagingMethodTxt ON EWMStagingMethod = _EWMStagingMethodTxt.EWMStagingMethod  -- association [0..*]
LEFT OUTER JOIN I_EWM_ProductionSupplyAreaText AS _EWMProductionSupplyAreaTxt ON EWMWarehouse = _EWMProductionSupplyAreaTxt.EWMWarehouse AND EWMProductionSupplyArea = _EWMProductionSupplyAreaTxt.EWMProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockDocCategoryText AS _StockDocCategoryTxt ON StockDocumentCategory = _StockDocCategoryTxt.StockDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMPlannedStagingStatusTxt ON EWMPlannedStagingStatus = _EWMPlannedStagingStatusTxt.EWMWarehouseRequestStatus AND _EWMPlannedStagingStatusTxt.EWMWarehouseRequestStatusType = 'DMP'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMStagingStatusTxt ON EWMStagingStatus = _EWMStagingStatusTxt.EWMWarehouseRequestStatus AND _EWMStagingStatusTxt.EWMWarehouseRequestStatusType = 'DMS'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _GoodsIssueStatusTxt ON GoodsIssueStatus = _GoodsIssueStatusTxt.EWMWarehouseRequestStatus AND _GoodsIssueStatusTxt.EWMWarehouseRequestStatusType = 'DGI'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _CompletionStatusTxt ON CompletionStatus = _CompletionStatusTxt.EWMWarehouseRequestStatus AND _CompletionStatusTxt.EWMWarehouseRequestStatusType = 'DCO'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMManufacturingOrdStatusTxt ON EWMManufacturingOrderStatus = _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatus AND _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatusType = 'DMC'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMGoodsMvtLockStatusTxt ON EWMGoodsMovementLockStatus = _EWMGoodsMvtLockStatusTxt.EWMWarehouseRequestStatus AND _EWMGoodsMvtLockStatusTxt.EWMWarehouseRequestStatusType = 'DBG'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMStagingLockStatusTxt ON EWMStagingLockStatus = _EWMStagingLockStatusTxt.EWMWarehouseRequestStatus AND _EWMStagingLockStatusTxt.EWMWarehouseRequestStatusType = 'DBS'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMItmInconstcyBlkStsTxt ON EWMItmInconsistencyBlockStatus = _EWMItmInconstcyBlkStsTxt.EWMWarehouseRequestStatus AND _EWMItmInconstcyBlkStsTxt.EWMWarehouseRequestStatusType = 'DBD'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _OverallBlockStatusTxt ON OverallBlockStatus = _OverallBlockStatusTxt.EWMWarehouseRequestStatus AND _OverallBlockStatusTxt.EWMWarehouseRequestStatusType = 'DBO'  -- association [0..*]
;