I_ContractRelevance

DDL: I_CONTRACTRELEVANCE SQL: ICOMONCTRREL Type: view COMPOSITE Package: VDM_MM_PUR_CON
16 Fields 1 Data Sources

Purchase Contract Relevance Calculations

I_ContractRelevance is a Composite CDS View (Fact) that provides data about "Purchase Contract Relevance Calculations" in SAP S/4HANA. It reads from 1 data source (I_Comonavg_Agg) and exposes 16 fields with key field PurchaseContract. Part of development package VDM_MM_PUR_CON.

Data Sources (1)

SourceAliasJoin Type
I_Comonavg_Agg A from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICOMONCTRREL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Relevance Calculations view
Analytics.dataCategory #FACT view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_Comonavg_Agg PurchaseContract Purchasing Doc.
TimeVarianceInDays I_Comonavg_Agg TimeVarianceInDays Overdue Days
OverdueToEndPercent I_Comonavg_Agg OverdueToEndPercent
QuantityFulfillmentPercent I_Comonavg_Agg QuantityFulfillmentPercent
DocumentCurrency I_Comonavg_Agg DocumentCurrency Document Currency
PurchaseContractTargetAmount I_Comonavg_Agg PurchaseContractTargetAmount Target Value
AmountFulfillmentPercent I_Comonavg_Agg AmountFulfillmentPercent
WeightedRelevance I_Comonavg_Agg WeightedRelevance Weighted Relevance
PurchaseContractType I_Comonavg_Agg PurchaseContractType Order Type
PurchaseContractClassification I_Comonavg_Agg PurchaseContractClassification
PurContrConsumedVal I_Comonavg_Agg PurchaseContractConsumedAmount
PurchaseContractConsumedAmount I_Comonavg_Agg PurchaseContractConsumedAmount
ContractConsumptionInPct I_Comonavg_Agg ContractConsumptionInPct Consumption Pct
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate I_Comonavg_Agg ValidityEndDate ValidTo
CreatedByUser I_Comonavg_Agg CreatedByUser User Name

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 I_ContractRelevance.
-- 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: ICOMONCTRREL

CREATE VIEW I_ContractRelevance AS
SELECT
  A.PurchaseContract AS PurchaseContract,
  A.TimeVarianceInDays AS TimeVarianceInDays,
  A.OverdueToEndPercent AS OverdueToEndPercent,
  A.QuantityFulfillmentPercent AS QuantityFulfillmentPercent,
  A.DocumentCurrency AS DocumentCurrency,
  A.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  A.AmountFulfillmentPercent AS AmountFulfillmentPercent,
  A.WeightedRelevance AS WeightedRelevance,
  A.PurchaseContractType AS PurchaseContractType,
  A.PurchaseContractClassification AS PurchaseContractClassification,
  A.PurchaseContractConsumedAmount AS PurContrConsumedVal,
  A.PurchaseContractConsumedAmount AS PurchaseContractConsumedAmount,
  A.ContractConsumptionInPct AS ContractConsumptionInPct,
  ValidityStartDate,
  A.ValidityEndDate AS ValidityEndDate,
  A.CreatedByUser AS CreatedByUser
FROM I_Comonavg_Agg AS A
;

Learn More