P_PurchaseOrderPriceVariance

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_PurchaseOrderPriceVariance.
-- 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: PMMPOPRICEVAR
-- Parameters: P_DisplayCurrency : displaycurrency, P_Material : matnr, P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_PurchaseOrderPriceVariance AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  cast( PurchaseOrderItem.PurchaseOrderItem as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  cast('3' as mm_a_doctype ) AS DocNumber,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  NetAmount,
  case when OrdPriceUnitToOrderUnitDnmntr = 0 then 0 else DIVISION(OrderPriceUnitToOrderUnitNmrtr, OrdPriceUnitToOrderUnitDnmntr, 1 ) * PurchaseOrderItem.OrderQuantity end as QuantityInBaseUnit AS OrderQuantityendasQuantityInBaseUnit,
  PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  OrderPriceUnit,
  PurchaseOrder._CompanyCode AS _CompanyCode,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  YearQuarter,
  YearMonth,
  YearWeek
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS CalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BR_Domain AS _DocText ON DocNumber = _DocText.DomainValue AND _DocText.Name = 'MM_A_DOCTYPE' AND _DocText.Language = $session.system_language  -- association [0..1]
;