I_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 I_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: IMPPOITM

CREATE VIEW I_MstrProjPurOrdItem AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrder.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrder.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  MasterProject.MasterProject AS MasterProject,
  MasterProject.MasterProjectName AS MasterProjectName,
  ltrim(MasterProject.ControllingObjectExternalID,'0') AS ControllingObjectExternalID,
  MasterProject.ControllingObjectDescription AS ControllingObjectDescription,
  MasterProject.WBSElement AS WBSElement,
  MasterProject.WBSDescription AS WBSDescription,
  MasterProject.WBSElementInternalID AS WBSElementInternalID,
  MasterProject.ProjectNetwork AS ProjectNetwork,
  MasterProject.ProjectNetworkDescription AS ProjectNetworkDescription,
  MasterProject.NetworkActivity AS NetworkActivity,
  MasterProject.NetworkActivityDescription AS NetworkActivityDescription,
  MasterProject.NetworkActivityInternalID AS NetworkActivityInternalID,
  MasterProject.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  PurchaseOrder.ServicePerformer AS ServicePerformer,
  PurchaseOrder._PurchaseOrder.PurchaseOrderDate AS DocumentDate,
  cast( _ScheduleLine.ScheduleLineDeliveryDate as eindt) AS DeliveryDate,
  PurchaseOrder.PurchaseOrderItemText AS MaterialName,
  PurchaseOrder.Material AS Material,
  PurchaseOrder.OrderQuantity AS TotalQuantity,
  PurchaseOrder.NetAmount AS NetAmount,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  case when HistoryPO.Quantity is not null and PurchaseOrder.IsCompletelyDelivered <> 'X' then PurchaseOrder.OrderQuantity - HistoryPO.Quantity when PurchaseOrder.IsCompletelyDelivered = 'X' then 0 else PurchaseOrder.OrderQuantity end as OpenQuantity AS OrderQuantityendasOpenQuantity,
  PurchaseOrder.BaseUnit AS BaseUnit,
  PurchaseOrder.NetPriceAmount AS NetPriceAmount,
  PurchaseOrder.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrder.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseRequisitionItem.ReleaseCode AS ReleaseCode,
  PurchaseOrder._PurchaseOrder.Supplier AS Supplier,
  _PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  PurchaseOrder._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.Plant AS Plant,
  PurchaseOrder.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrder.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _SupplierInvoice.InvoicedQuantity AS InvoicedQuantity,
  _SupplierInvoice.InvoicedAmount AS InvoicedAmount,
  HistoryPO.PurchaseOrderAmount AS PurchaseOrderAmount,
  HistoryPO.Quantity AS Quantity
INNER JOIN I_PurgDocAccountAssignment AS PurchasingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrderItem AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
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_MPPurOrdRefInvoice AS _SupplierInvoice ON PurchaseOrder = _SupplierInvoice.PurchaseOrder AND PurchaseOrderItem = _SupplierInvoice.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchasingDocument AND PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..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]
;