I_MPProcurementCube

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_MPProcurementCube.
-- 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: IMPPROCCUBE

CREATE VIEW I_MPProcurementCube AS
SELECT
  I_MPProcurement.MasterProject AS MasterProject,
  I_MPProcurement.PurchaseOrder AS PurchaseOrder,
  I_MPProcurement.PurchaseOrderItem AS PurchaseOrderItem,
  I_MPProcurement.PurchaseRequisition AS PurchaseRequisition,
  I_MPProcurement.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MPProcurement.MasterProjectName AS MasterProjectName,
  I_MPProcurement.ControllingObjectExternalID AS ControllingObjectExternalID,
  I_MPProcurement.ControllingObjectDescription AS ControllingObjectDescription,
  I_MPProcurement.Material AS Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  I_MPProcurement.TotalQuantity AS TotalQuantity,
  I_MPProcurement.WBSElement AS WBSElement,
  I_MPProcurement.WBSDescription AS WBSDescription,
  I_MPProcurement.NetworkActivity AS NetworkActivity,
  I_MPProcurement.NetworkActivityDescription AS NetworkActivityDescription,
  I_MPProcurement.ProjectNetwork AS ProjectNetwork,
  I_MPProcurement.ProjectNetworkDescription AS ProjectNetworkDescription,
  I_MPProcurement.DocumentDate AS DocumentDate,
  I_MPProcurement.DeliveryDate AS DeliveryDate,
  I_MPProcurement.DocumentCurrency AS DocumentCurrency,
  I_MPProcurement.OpenQuantity AS OpenQuantity,
  I_MPProcurement.InvoicedAmount AS InvoicedAmount,
  I_MPProcurement.InvoicedQuantity AS InvoicedQuantity,
  I_MPProcurement.OrderedQuantity AS OrderedQuantity,
  I_MPProcurement.RequestedQuantity AS RequestedQuantity,
  I_MPProcurement.BaseUnit AS BaseUnit,
  I_MPProcurement.NetPriceAmount AS NetPriceAmount,
  I_MPProcurement.OrderPriceUnit AS OrderPriceUnit,
  I_MPProcurement.NetPriceQuantity AS NetPriceQuantity,
  I_MPProcurement.ReleaseCode AS ReleaseCode,
  _ReleaseIndicatorDesc.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  I_MPProcurement.Supplier AS Supplier,
  I_MPProcurement.MaterialGroup AS MaterialGroup,
  _MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  I_MPProcurement.ProcessingStatus AS ProcessingStatus,
  I_MPProcurement.PurchaseOrderAmount AS PurchaseOrderAmount,
  I_MPProcurement.Quantity AS Quantity,
  I_MPProcurement.OpenAmountInDisplayCrcy AS OpenAmountInDisplayCrcy,
  I_MPProcurement.PurReqnNetAmount AS PurReqnNetAmount,
  I_MPProcurement.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_MPProcurement.NetAmount AS NetAmount
FROM I_MPProcurement
LEFT OUTER JOIN I_Mppurchaseorderitemhistory AS _History ON PurchaseOrder = _History.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PRReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseStatus = ReleaseCode AND _ReleaseIndicatorDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchasingDocumentStatus ON PurchaseOrder = _PurchasingDocumentStatus.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_ServiceEntrySheetItem AS _ServicePerformer ON PurchaseOrder = _ServicePerformer.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceItemPurOrdRef AS _SupplierInvoice ON PurchaseOrder = _SupplierInvoice.PurchaseOrder AND PurchaseOrderItem = _SupplierInvoice.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_MpPurReqHistory AS _PurchaseRequisitionHistory ON PurchaseRequisition = _PurchaseRequisitionHistory.PurchaseRequisition  -- association [0..*]
LEFT OUTER JOIN I_MPPrchsRqstnVH AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition AND MasterProject = _PurchaseRequisition.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPPrchsOrdrVH AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder AND MasterProject = _PurchaseOrder.MasterProject  -- association [0..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _PurchaserequisitionExtension ON PurchaseRequisition = _PurchaserequisitionExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaserequisitionExtension.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchasingDocumentExtension ON PurchaseOrder = _PurchasingDocumentExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;