I_PPS_PurOrdDocumentTotalC_2

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_PPS_PurOrdDocumentTotalC_2.
-- 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_PPS_PurOrdDocumentTotalC_2 AS
SELECT
  PurchaseOrderItem.PurchasingDocument AS PurchaseOrder,
  PurchaseOrderItem.PurchasingDocumentItem AS PurchaseOrderItem,
  cast( '01' as pps_e_purord_met_tot_key_fig ) AS PPSDocTotalKeyFigure,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItem._PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem._PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _POHisEA.PPSExercisableAmount AS PPSDocTotalAmount,
  cast( 0 as bwert ) as NetAmount AS PurchasingDocumentasPurchaseOrder,
  PurchaseOrderItem.NetAmount AS NetAmount
FROM I_PurchasingDocumentItem AS PurchaseOrderItem
LEFT OUTER JOIN I_PPS_PurchaseOrderHistoryC AS _POHisEA ON _POHisEA.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _POHisEA.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _POHisEA.PPSExercisableAmount is not initial  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseOrderHistoryC AS _POHisIR ON _POHisIR.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _POHisIR.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _POHisIR.InvoiceReceiptAmount is not initial  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseOrderHistoryC AS _POHisSES ON _POHisSES.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _POHisSES.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _POHisSES.ServiceEntrySheetNetAmount is not initial  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseOrderHistoryC AS _PurchaseOrderHistory ON _PurchaseOrderHistory.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _PurchaseOrderHistory.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _PurchaseOrderHistory.GoodsReceiptAmount is not initial  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseOrderHistoryC AS _POHisOA ON _POHisOA.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _POHisOA.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _POHisOA.PPSDocTotalOptionalAmount is not initial  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurchaseOrderBudgetC AS _POBudUA ON _POBudUA.PurchaseOrder = PurchaseOrderItem.PurchasingDocument AND _POBudUA.PurchaseOrderItem = PurchaseOrderItem.PurchasingDocumentItem AND _POBudUA.PPSUnfundedAmount is not initial  -- association [0..*]
LEFT OUTER JOIN R_PPS_PurOrderItemExtension AS _PurchaseOrderItemExtension ON PurchaseOrderItem.PurchasingDocument = _PurchaseOrderItemExtension.PurchaseOrder AND PurchaseOrderItem.PurchasingDocumentItem = _PurchaseOrderItemExtension.PurchaseOrderItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurchasingDocumentItem
;