P_PURGMATPRICECHGNETPRICE

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

CREATE VIEW P_PURGMATPRICECHGNETPRICE AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  MaterialDocumentYear,
  cast( MatPrice2.MaterialDocument as fikz_reginv_invoice ) AS Invoice,
  MaterialDocumentItem,
  cast( MatPrice2.PostingDate as invdt ) AS InvoiceDate,
  cast( PurchasingOrganization as mm_a_purg_org ) AS PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderType,
  CompanyCode,
  cast ( Supplier as odata_lifnr ) AS Supplier,
  Material,
  MaterialGroup,
  Plant,
  PurchaseOrderQuantityUnit,
  PurchaseOrderDate,
  DocumentCurrency,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  IsReturnItemValue,
  NetPriceQuantity,
  NetAmount,
  NetPriceAmount,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  BaseUnit,
  cast( InvoiceAmtInDisplayCurrency as mm_pur_ana_de_invoice_amount) AS InvoiceAmtInDisplayCurrency,
  cast(MatPrice2.QuantityInBaseUnit as abap.dec(13,3) ) AS QuantityInBaseUnit,
  case when QuantityInBaseUnit = 0 then 0 else cast ( division( MatPrice2.InvoiceAmtInDisplayCurrency, MatPrice2.QuantityInBaseUnit, 3 ) as abap.curr(18,2) ) end as NetPriceInvoiceAmtInBaseUnit AS curr182endasNetPriceInvoiceAmtInBaseUnit
FROM P_PurgMatlPriceChg2
LEFT OUTER JOIN I_PurOrdAccountAssignment AS AccountAssignment ON MatPrice2.PurchaseOrder = AccountAssignment.PurchaseOrder AND MatPrice2.PurchaseOrderItem = AccountAssignment.PurchaseOrderItem AND MatPrice2.AccountAssignmentNumber = AccountAssignment.AccountAssignmentNumber  -- association [1..1]
;