P_PriceVariance3

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_PriceVariance3.
-- 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: PMMPRICEVAR3
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_PriceVariance3 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderDate,
  PriceVariance.PurchasingOrganization AS PurchasingOrganization,
  Supplier,
  CompanyCode,
  PurchasingGroup,
  Plant,
  Material,
  MaterialGroup,
  PurchasingDocumentCategory,
  PriceVariance.PurchasingCategory AS PurchasingCategory,
  PurgCatName,
  DeliveredQuantity,
  OrderedQuantity,
  Currency,
  cast ($parameters.P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  cast(PurchaseOrderNetPriceAmount as mm_po_net_price_amount ) AS PurchaseOrderNetPriceAmount,
  cast(InvoiceAmountPerUnit as mm_invoice_price_amount ) AS InvoicePrice,
  cast(PriceVarianceAmount as mm_a_price_variance_amount) AS PriceVarianceAmount,
  NetAmount,
  Scoring.SupplierEvaluationScore AS SupplierEvaluationScore,
  cast ('' as migration_completed) AS PurgDocMigrtnIsCmpltdForAnlyts,
  cast ( '1' as mmpur_ana_de_se_doc_config ) as SuplrEvalRelevantDocCategory AS P_DisplayCurrency,
  P_StartDate : $parameters.P_StartDate AS P_StartDate,
  PriceVarianceInPct,
  SuplrEvalRelevantDocCategory
FROM P_PriceVariance2
INNER JOIN P_SuplrEvalCritrnVarcScore AS Scoring ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON PriceVariance.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
-- UNION ALL with additional select branch(es): P_PRICEVARIANCECURRCONV
;