C_MstrProjPurOrdItem

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 C_MstrProjPurOrdItem.
-- 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: CMPPOITM

CREATE VIEW C_MstrProjPurOrdItem AS
SELECT
  cast(PurchaseOrder.PurchaseOrder as vdm_purchaseorder) AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderItem AS PurchaseOrderItem,
  cast(PurchaseOrder.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  cast((ltrim(PurchaseOrder.PurchaseOrderItem,'0')) as vdm_purchaseorderitem) AS OrderItem,
  PurchaseOrder.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrder.MasterProject AS MasterProject,
  PurchaseOrder.MasterProjectName AS MasterProjectName,
  PurchaseOrder.ControllingObjectDescription AS ControllingObjectDescription,
  PurchaseOrder.ServicePerformer AS ServicePerformer,
  PurchaseOrder.DocumentDate AS DocumentDate,
  PurchaseOrder.DeliveryDate AS DeliveryDate,
  PurchaseOrder.Material AS Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  PurchaseOrder.TotalQuantity AS TotalQuantity,
  PurchaseOrder.NetAmount AS NetAmount,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  PurchaseOrder.InvoicedQuantity AS InvoicedQuantity,
  PurchaseOrder.BaseUnit AS BaseUnit,
  _UnitOfMeasure.UnitOfMeasure AS UnitOfMeasure,
  PurchaseOrder.NetPriceAmount AS NetPriceAmount,
  PurchaseOrder.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrder.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrder.ReleaseCode AS ReleaseCode,
  _ReleaseIndicatorDesc.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder._SupplierHeadOffice.FullName AS SupplierName,
  PurchaseOrder.MaterialGroup AS MaterialGroup,
  _MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  cast(PurchaseOrder.PurchaseOrderAmount as /cpd/cpm_delivamt) AS PurchaseOrderAmount,
  cast(PurchaseOrder.Quantity as /cpd/cpm_delivqty) AS Quantity,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.Plant AS Plant
FROM I_MstrProjPurOrdItem AS PurchaseOrder
LEFT OUTER JOIN C_MPPurchaseOrderItemHistory AS _History ON PurchaseOrder = _History.PurchaseOrder AND OrderItem = _History.PurchaseOrderItem AND Material = _History.Material  -- 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 C_MstrProjSuplrCntctCard 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_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformerBP ON ServicePerformer = _ServicePerformerBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _Extension ON PurchaseOrder.PurchaseOrder = _Extension.PurchasingDocument  -- association [0..1]
;