P_PFMCarbonFootprintForPR

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 P_PFMCarbonFootprintForPR.
-- 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: PMMPFMCFPR
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PFMCarbonFootprintForPR AS
SELECT
  PurchaseRequisition.PurchaseRequisition AS PurchasingDocument,
  PurchaseRequisition.PurchaseRequisitionItem AS PurchasingDocumentItem,
  PurchaseRequisition.Material AS Material,
  PurchaseRequisition.Plant AS Plant,
  PurchaseRequisition.MaterialGroup AS MaterialGroup,
  PurchaseRequisition.FixedSupplier AS Supplier,
  PurchaseRequisition.PurchasingOrganization AS PurchasingOrganization,
  PurchaseRequisition.PurchasingGroup AS PurchasingGroup,
  PurchaseRequisition.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseRequisition.CreationDate AS CreationDate,
  cast(CO2eqFprnt.PFMFootprintQuantity as abap.quan( 31, 3 ) ) AS PFMFootprintQuantity,
  CO2eqFprnt.PFMFootprintUnit AS PFMFootprintUnit,
  cast( 0 as abap.curr(21,5)) as PurchaseOrderAmount AS PurchaseOrderasPurchasingDocument,
  cast( 0 as abap.curr(21,5)) AS PurchaseRequisitionPrice,
  case when PurchaseOrderItem.NetPriceQuantity > 0 then cast ( division (currency_conversion( amount => PurchaseOrderItem.NetPriceAmount , source_currency => PurchaseOrder.DocumentCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseOrder.PurchaseOrderDate, exchange_rate_type => 'M' ), PurchaseOrderItem.NetPriceQuantity,5) as abap.curr(21,5) ) else 0 end as PurchaseOrderAmount AS curr215else0endasPurchaseOrderAmount
FROM I_PurchaseRequisitionItemBasic AS PurchaseRequisition
INNER JOIN I_PFMTransDataCO2eqFprnt AS CO2eqFprnt ON /* join condition not captured in parsed metadata */
INNER JOIN R_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): R_PurchaseOrderItem
;