P_PurContractPriceVariance3

DDL: P_PURCONTRACTPRICEVARIANCE3 Type: view_entity CONSUMPTION Package: ODATA_MM_ANALYTICS
23 Fields 1 Data Sources

Purchase Contract Price Change

P_PurContractPriceVariance3 is a Consumption CDS View that provides data about "Purchase Contract Price Change" in SAP S/4HANA. It reads from 1 data source (P_PurContractPriceVariance2) and exposes 23 fields with key fields PurchaseContract, PurchaseContractItem, ChangeDocument. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_PurContractPriceVariance2 P_PurContractPriceVariance2 from

Parameters (4)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_Material matnr
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PriceChange PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PriceChange PurchaseContractItem Item
KEY ChangeDocument PriceChange ChangeDocument Document Number
PurchaseContractItemUniqueID PriceChange PurchaseContractItemUniqueID Document Item
PurchasingOrganization PriceChange PurchasingOrganization Purchasing Organization
PurchasingGroup PriceChange PurchasingGroup Purchasing Group
Supplier PriceChange Supplier Supplier
CompanyCode PriceChange CompanyCode Receiver Company Code
Material PriceChange Material Vehicle Model
MaterialGroup PriceChange MaterialGroup Product Group
Plant PriceChange Plant Valuation Area
Currency PriceChange DocumentCurrency Document Currency
CreationDate PriceChange CreationDate Time Stamp
NumberOfChanges NumberOfChanges
NumberOfPriceChanges NumberOfPriceChanges
OrderQuantityUnit OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity
DocumentChangeDate DocumentChangeDate
DisplayCurrency
ReleaseOrderItemNetAmount 0
QuantityInBaseUnit QuantityInBaseUnit Quantity
NetPriceQuantity NetPriceQuantity Price Unit
OrderPriceUnit OrderPriceUnit Order Price Un.

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

CREATE VIEW P_PurContractPriceVariance3 AS
SELECT
  PriceChange.PurchaseContract AS PurchaseContract,
  PriceChange.PurchaseContractItem AS PurchaseContractItem,
  PriceChange.ChangeDocument AS ChangeDocument,
  PriceChange.PurchaseContractItemUniqueID AS PurchaseContractItemUniqueID,
  PriceChange.PurchasingOrganization AS PurchasingOrganization,
  PriceChange.PurchasingGroup AS PurchasingGroup,
  PriceChange.Supplier AS Supplier,
  PriceChange.CompanyCode AS CompanyCode,
  PriceChange.Material AS Material,
  PriceChange.MaterialGroup AS MaterialGroup,
  PriceChange.Plant AS Plant,
  PriceChange.DocumentCurrency AS Currency,
  PriceChange.CreationDate AS CreationDate,
  NumberOfChanges,
  NumberOfPriceChanges,
  OrderQuantityUnit,
  TargetQuantity,
  DocumentChangeDate,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  0 AS ReleaseOrderItemNetAmount,
  QuantityInBaseUnit,
  NetPriceQuantity,
  OrderPriceUnit
FROM P_PurContractPriceVariance2
;

Learn More