P_PurContractPriceVariance1

DDL: P_PURCONTRACTPRICEVARIANCE1 SQL: PMMPCPRCVAR1 Type: view CONSUMPTION
33 Fields 3 Data Sources 1 Associations

P_PurContractPriceVariance1 is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_PurchaseContractItem, P_ChangeDocumentItem2, P_ChangeDocumentItem3) and exposes 33 fields with key fields PurchaseContract, PurchaseContractItem, ChangeDocument. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_PurchaseContractItem ContractItem from
P_ChangeDocumentItem2 P_ChangeDocumentItem2 left_outer
P_ChangeDocumentItem3 P_ChangeDocumentItem3 left_outer

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 (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPCPRCVAR1 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 (33)

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
NetPriceQuantity NetPriceQuantity Price Unit
OrderPriceUnit OrderPriceUnit Order Price Un.
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_PurContractPriceVariance1.
-- 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: PMMPCPRCVAR1
-- Parameters: P_Material : matnr, P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_PurContractPriceVariance1 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,
  NetPriceQuantity,
  OrderPriceUnit,
  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 P_ChangeDocumentItem2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ChangeDocumentItem3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
;

Learn More