P_PURCONTRACTPRICEVARIANCE

DDL: P_PURCONTRACTPRICEVARIANCE SQL: PMMPCPRCVAR Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
31 Fields 1 Data Sources 1 Associations

Purchase Contract Price Variance 1

P_PURCONTRACTPRICEVARIANCE is a Consumption CDS View that provides data about "Purchase Contract Price Variance 1" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 31 fields with key fields PurchaseContract, PurchaseContractItem, ChangeDocument. It has 1 association to related views. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem ContractItem from

Parameters (3)

NameTypeDefault
P_Material matnr
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGroup $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMPCPRCVAR view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ChangeDocument ChangeItem ChangeDocument Document Number
CreationDate _PurchaseContract CreationDate Time Stamp
PurchasingOrganization _PurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseContract PurchasingGroup Purchasing Group
Supplier _PurchaseContract Supplier Supplier
CompanyCode _PurchaseContract CompanyCode Receiver Company Code
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant I_PurchaseContractItem Plant Valuation Area
PurchasingCategory
ContractCurrency I_PurchaseContractItem DocumentCurrency Document Currency
Currency ChangeItem Currency Valuation Crcy
DocumentCurrencyendasDocumentCurrency
CreationDateendasDocumentChangeDate
OrderQuantityUnit OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity
TargetAmount TargetAmount Target Value
IsDocumentChanged IsDocumentChanged
NumberOfChanges NumberOfChanges
NumberOfPriceChanges ChangeItem NumberOfPriceChanges
TotalNumberOfChanges NumberOfChangeItems NumberOfPriceChanges
_Material _Material
_MaterialGroup _MaterialGroup
_Plant _Plant
_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGroup
_Supplier
_CompanyCode
_PurchasingGroup
_PurchasingOrganization

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_PURCONTRACTPRICEVARIANCE.
-- 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: PMMPCPRCVAR
-- Parameters: P_Material : matnr, P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_PURCONTRACTPRICEVARIANCE AS
SELECT
  ContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem,
  ChangeItem.ChangeDocument AS ChangeDocument,
  _PurchaseContract.CreationDate AS CreationDate,
  _PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchaseContract.Supplier AS Supplier,
  _PurchaseContract.CompanyCode AS CompanyCode,
  Material,
  MaterialGroup,
  ContractItem.Plant AS Plant,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  ContractItem.DocumentCurrency AS ContractCurrency,
  ChangeItem.Currency AS Currency,
  case when ChangeDocument is not initial and ChangeItem.Currency is not initial then ChangeItem.Currency else ContractItem.DocumentCurrency end as DocumentCurrency AS DocumentCurrencyendasDocumentCurrency,
  case when ChangeDocument is not initial then CreationDate else _PurchaseContract.CreationDate end as DocumentChangeDate AS CreationDateendasDocumentChangeDate,
  OrderQuantityUnit,
  TargetQuantity,
  TargetAmount,
  IsDocumentChanged,
  NumberOfChanges,
  ChangeItem.NumberOfPriceChanges AS NumberOfPriceChanges,
  NumberOfChangeItems.NumberOfPriceChanges AS TotalNumberOfChanges,
  ContractItem._PurchaseContract._Supplier AS _Supplier,
  ContractItem._PurchaseContract._CompanyCode AS _CompanyCode,
  ContractItem._PurchaseContract._PurchasingGroup AS _PurchasingGroup,
  ContractItem._PurchaseContract._PurchasingOrganization AS _PurchasingOrganization
FROM I_PurchaseContractItem AS ContractItem
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
;

Learn More