P_InvoicePriceVariance2

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

CREATE VIEW P_InvoicePriceVariance2 AS
SELECT
  InvoicePriceVariance.PurchaseOrder AS PurchaseOrder,
  InvoicePriceVariance.PurchaseOrderItem AS PurchaseOrderItem,
  InvoicePriceVariance.MaterialDocumentYear AS MaterialDocumentYear,
  InvoicePriceVariance.MaterialDocument AS MaterialDocument,
  InvoicePriceVariance.MaterialDocumentItem AS MaterialDocumentItem,
  InvoicePriceVariance.PostingDate AS PostingDate,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Plant AS Plant,
  InvoicePriceVariance.Currency AS Currency,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  PurchaseOrderItem.BaseUnit AS BaseUnit,
  InvoicePriceVariance.OrderPriceUnit AS OrderPriceUnit,
  InvoicePriceVariance.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  cast(InvoicePriceVariance.QtyInPurchaseOrderPriceUnit as abap.dec(13,3)) AS QtyInPurchaseOrderPriceUnit,
  cast(InvoicePriceVariance.Quantity as abap.dec(13,3)) AS Quantity,
  PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  case when InvoicePriceVariance.Currency = $parameters.P_DisplayCurrency then InvoicePriceVariance.PurchaseOrderAmount else cast( currency_conversion( amount => InvoicePriceVariance.PurchaseOrderAmount, source_currency => InvoicePriceVariance.Currency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => InvoicePriceVariance.PostingDate, exchange_rate_type => 'M', error_handling => 'SET_TO_NULL' ) as abap.dec(18,2) ) end as InvoiceAmtInDisplayCurrency AS dec182endasInvoiceAmtInDisplayCurrency,
  case PurchaseOrderItem.IsReturnsItem when 'X' then -1 else 1 end AS IsReturnsItem
FROM P_InvoicePriceVariance4
INNER JOIN I_PurchaseOrderItem AS PurchaseOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
;