P_CntrlContrPriceHistComp

DDL: P_CNTRLCONTRPRICEHISTCOMP SQL: PCNTRLPRCHISTCMP Type: view CONSUMPTION Package: ODATA_MM_PUR_CCTR_ANALYTICS
38 Fields 1 Data Sources 1 Associations

Cenral Contract Price history Components

P_CntrlContrPriceHistComp is a Consumption CDS View that provides data about "Cenral Contract Price history Components" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrWthPriceHist) and exposes 38 fields with key fields ActivePurchasingDocument, PurchasingDocumentVersion, CentralPurchaseContractItem, ProcmtHubPlantUniqueID, ProcmtHubContrValidityUUID. It has 1 association to related views. Part of development package ODATA_MM_PUR_CCTR_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrWthPriceHist PriceHistory from

Parameters (2)

NameTypeDefault
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CntrlContrPriceComponents PriceComponent PriceHistory.ProcmtHubContrValidityUUID = PriceComponent.ProcmtHubContrValidityUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRLPRCHISTCMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cenral Contract Price history Components view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
KEY PurchasingDocumentVersion PurchasingDocumentVersion Version
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
KEY ProcmtHubContrValidityUUID ProcmtHubContrValidityUUID Validity ID
KEY ProcmtHubContrIsCurrentVersion ProcmtHubContrIsCurrentVersion True
CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
PurchaseContractType PurchaseContractType Order Type
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionValidityEndDate ConditionValidityEndDate Valid To
NetPriceAmount NetPriceAmount Net Price
NetPriceInReportingCurrency NetPriceInReportingCurrency NET PRICE
NetPriceInReportingCurrency2 NetPriceInReportingCurrency2 NET PRICE
NetAmount NetAmount Stated Amount
NetAmountInReportingCurrency NetAmountInReportingCurrency NET PRICE
NetAmountInReportingCurrency2 NetAmountInReportingCurrency2 NET PRICE
ProcmtHubContrBasePrDocCrcyAmt ProcmtHubContrBasePrDocCrcyAmt NET PRICE
ProcmtHubContrBasePrCrcy1Amt ProcmtHubContrBasePrCrcy1Amt NET PRICE
ProcmtHubContrBasePrCrcy2Amt ProcmtHubContrBasePrCrcy2Amt NET PRICE
DocumentCurrency DocumentCurrency Document Currency
AnalyticalReportingCurrency AnalyticalReportingCurrency Reporting Currency 1
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2 Reporting Currency 2
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
ChangeReasonIsRelevantForVers ChangeReasonIsRelevantForVers TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
CreatedByUser CreatedByUser User Name
ProcmtHubIncotermsClassfctn ProcmtHubIncotermsClassfctn Incoterms
ProcmtHubIncoterms2Classfctn ProcmtHubIncoterms2Classfctn Incoterms 2
PaymentTerms PaymentTerms Pyt Terms
ShippingCondition ShippingCondition Shipping Conditions
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
ConditionChangeReason PriceComponent ConditionChangeReason Cndn Change Reason

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_CntrlContrPriceHistComp.
-- 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: PCNTRLPRCHISTCMP
-- Parameters: P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_CntrlContrPriceHistComp AS
SELECT
  ActivePurchasingDocument,
  PurchasingDocumentVersion,
  CentralPurchaseContractItem,
  ProcmtHubPlantUniqueID,
  ProcmtHubContrValidityUUID,
  ProcmtHubContrIsCurrentVersion,
  CentralPurchaseContract,
  PurchaseContractType,
  ConditionValidityStartDate,
  ConditionValidityEndDate,
  NetPriceAmount,
  NetPriceInReportingCurrency,
  NetPriceInReportingCurrency2,
  NetAmount,
  NetAmountInReportingCurrency,
  NetAmountInReportingCurrency2,
  ProcmtHubContrBasePrDocCrcyAmt,
  ProcmtHubContrBasePrCrcy1Amt,
  ProcmtHubContrBasePrCrcy2Amt,
  DocumentCurrency,
  AnalyticalReportingCurrency,
  AnalyticalReportingCurrency2,
  CreationDate,
  Supplier,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  Material,
  MaterialGroup,
  ChangeReasonIsRelevantForVers,
  OrderQuantityUnit,
  CreatedByUser,
  ProcmtHubIncotermsClassfctn,
  ProcmtHubIncoterms2Classfctn,
  PaymentTerms,
  ShippingCondition,
  ProcmtHubCompanyCodeGroupingID,
  PriceComponent.ConditionChangeReason AS ConditionChangeReason
FROM I_CntrlPurContrWthPriceHist AS PriceHistory
LEFT OUTER JOIN I_CntrlContrPriceComponents AS PriceComponent ON PriceHistory.ProcmtHubContrValidityUUID = PriceComponent.ProcmtHubContrValidityUUID  -- association [1..1]
;

Learn More