P_MaterialPriceVariance

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

CREATE VIEW P_MaterialPriceVariance AS
SELECT
  cast( PurchaseContract as mm_a_purchasing_document ) AS PurchasingDocument,
  cast( PurchaseContractItem as ebelp ) AS PurchasingDocumentItem,
  ChangeDocument,
  cast('' as gjahr ) AS MaterialDocumentYear,
  cast('' as mm_a_material_doc_item ) AS MaterialDocumentItem,
  cast('' as esokz ) AS PurchasingInfoRecordCategory,
  PurchasingGroup,
  concat( PurchaseContract, concat( '/' , PurchaseContractItem) ) AS FormattedDocumentKey,
  cast(PurchaseContract as vdm_purchasecontract ) AS PurchaseContract,
  cast(PurchaseContractItem as vdm_purchasecontractitem) AS PurchaseContractItem,
  cast('' as vdm_purchaseorder) AS PurchaseOrder,
  cast('' as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  cast('' as fikz_reginv_invoice ) AS Invoice,
  cast( cast( '' as abap.char(10)) as mm_a_info_record preserving type ) AS PurchasingInfoRecord,
  cast('' as budat ) AS InvoiceDate,
  CreationDate,
  DocumentChangeDate,
  PurchasingOrganization,
  Supplier,
  Material,
  MaterialGroup,
  CompanyCode,
  Plant,
  PurchaseContract AS DocNumber,
  cast( '01' as mm_pur_ana_de_doctype ) AS PurchasingDocumentType,
  Currency AS DocumentCurrency,
  :P_DisplayCurrency AS DisplayCurrency,
  cast('' as bstme) AS PurchaseOrderQuantityUnit,
  cast(0 as bstmg) AS OrderQuantity,
  OrderQuantityUnit,
  TargetQuantity,
  cast( PurchaseContractTargetAmount as mm_a_target_amount ) AS TargetAmount,
  cast(0 as mm_pur_ana_de_invoice_amount) AS InvoiceAmtInDisplayCurrency,
  cast(0 as purchase_order_net_amount) AS PurOrdNetAmountInDisplayCrcy,
  fltp_to_dec( ContractNetPriceAmount as mm_pur_ana_mat_avg_price ) AS NetPriceAmount,
  cast( NetPriceQuantity as abap.quan( 13, 3 ) ) AS NetPriceQuantity,
  OrderPriceUnit,
  cast(0 as abap.quan(13,3) ) AS QuantityInBaseUnit,
  cast('' as abap.char(1)) AS BOMHasHeaderInfoRecord,
  NumberOfChanges AS NumberOfContractChanges,
  cast( 0 as abap.int4) AS NumberOfPriceChanges,
  cast(0 as mm_a_numberofpurchaseorders ) AS NumberOfPurchaseOrders,
  cast(0 as menge_d) as InvoiceQuantity AS P_DisplayCurrency,
  P_Material : $parameters.P_Material AS P_Material,
  P_StartDate: $parameters.P_StartDate AS P_StartDate,
  cast( 0 as mm_a_release_order_net_amount ) AS ReleaseOrderItemNetAmount,
  cast( 0 as mm_pur_ana_mat_net_unit_price ) AS NetUnitPriceAmount,
  cast(0 as menge_d) AS InvoiceQuantity
FROM P_PurContractPriceVariance2
INNER JOIN I_ProductPlant AS ProductPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialPlant AS MaterialPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_Material AS MatMaster ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_InvoicePriceVariance, P_PurchaseOrderPriceVariance, P_InfoRecordPriceVariance1, P_MatlMovingAvgPrice
;