P_PurgMatlPriceChg2

DDL: P_PURGMATLPRICECHG2 SQL: PMMMATLPRC2 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
28 Fields 1 Data Sources

Material Price Change 2

P_PurgMatlPriceChg2 is a Consumption CDS View that provides data about "Material Price Change 2" in SAP S/4HANA. It reads from 1 data source (P_PurgMatlPriceChg1) and exposes 28 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, MaterialDocumentYear, MaterialDocument. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_PurgMatlPriceChg1 P_PurgMatlPriceChg1 from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate budat
P_EndDate budat

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMMATLPRC2 view
EndUserText.label Material Price Change 2 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder MatPriceChange PurchaseOrder Purchasing Document
KEY PurchaseOrderItem MatPriceChange PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber MatPriceChange AccountAssignmentNumber Account Assgmt No.
KEY MaterialDocumentYear MatPriceChange MaterialDocumentYear Material Document Year
KEY MaterialDocument MatPriceChange MaterialDocument Material Doc.
KEY MaterialDocumentItem MatPriceChange MaterialDocumentItem Material Document Item
PostingDate MatPriceChange PostingDate Posting Date for GR
PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseOrderType PurchaseOrderType PO Type
CompanyCode MatPriceChange CompanyCode Receiver Company Code
Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
NetPriceAmount NetPriceAmount Net Price
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
PurchaseOrderDate PurchaseOrderDate PO Date
DocumentCurrency DocumentCurrency Document Currency
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
IsReturnsItem IsReturnsItem Returns Item
IsReturnItemValue
NetAmount NetAmount Stated Amount
DisplayCurrency
BaseUnit BaseUnit Unit of Measure
NetPriceQuantity NetPriceQuantity Price Unit
QuantityendendasQuantityInBaseUnit

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

CREATE VIEW P_PurgMatlPriceChg2 AS
SELECT
  MatPriceChange.PurchaseOrder AS PurchaseOrder,
  MatPriceChange.PurchaseOrderItem AS PurchaseOrderItem,
  MatPriceChange.AccountAssignmentNumber AS AccountAssignmentNumber,
  MatPriceChange.MaterialDocumentYear AS MaterialDocumentYear,
  MatPriceChange.MaterialDocument AS MaterialDocument,
  MatPriceChange.MaterialDocumentItem AS MaterialDocumentItem,
  MatPriceChange.PostingDate AS PostingDate,
  cast( PurchasingOrganization as mm_a_purg_org ) AS PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderType,
  MatPriceChange.CompanyCode AS CompanyCode,
  cast ( Supplier as odata_lifnr ) AS Supplier,
  Material,
  MaterialGroup,
  Plant,
  NetPriceAmount,
  PurchaseOrderQuantityUnit,
  PurchaseOrderDate,
  DocumentCurrency,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  IsReturnsItem,
  cast( case when IsReturnsItem = 'X' then -1 else 1 end as int2 ) AS IsReturnItemValue,
  NetAmount,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  BaseUnit,
  NetPriceQuantity,
  case when BaseUnit = '' then MatPriceChange.Quantity else case when OrderItemQtyToBaseQtyDnmntr = 0 then 0 else DIVISION(OrderItemQtyToBaseQtyNmrtr, OrderItemQtyToBaseQtyDnmntr, 3 ) * MatPriceChange.Quantity end end as QuantityInBaseUnit AS QuantityendendasQuantityInBaseUnit
FROM P_PurgMatlPriceChg1
;

Learn More