What is C_CntrlPurContrHdrCndnAmount in SAP S/4HANA?

C_CntrlPurContrHdrCndnAmount is a consumption CDS view in SAP S/4HANA. Central Purchase Contract Hdr Condition It contains 51 fields.

Which tables does C_CntrlPurContrHdrCndnAmount read from?

C_CntrlPurContrHdrCndnAmount reads data from: I_CntrlPurContrHdrCndnAmountTP.

What VDM layer is C_CntrlPurContrHdrCndnAmount?

C_CntrlPurContrHdrCndnAmount is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CntrlPurContrHdrCndnAmount

DDL: C_CNTRLPURCONTRHDRCNDNAMOUNT SQL: CCCTRHCNDNAMT Type: view CONSUMPTION

51 Fields 1 Data Sources 7 Associations

Central Purchase Contract Hdr Condition

C_CntrlPurContrHdrCndnAmount is a Consumption CDS View that provides data about "Central Purchase Contract Hdr Condition" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrHdrCndnAmountTP) and exposes 51 fields with key fields CentralPurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CntrlPurContrHdrCndnAmountTP	I_CntrlPurContrHdrCndnAmountTP	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..1]	C_CntrlPurContrHdrCndnValdty	_CntrlPurContrHdrCndnValdty	`$projection.CentralPurchaseContract = _CntrlPurContrHdrCndnValdty.CentralPurchaseContract and $projection.ConditionRecord = _CntrlPurContrHdrCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _CntrlPurContrHdrCndnValdty.ConditionValidityEndDate`
[1..1]	C_CentralPurchaseContractTP	_CentralPurchaseContractTP	`_CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract`
[0..*]	C_CntrlPurContrHdrCndnScalesTP	_CntrlPurContrHdrCndnScalesTP	`_CntrlPurContrHdrCndnScalesTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrHdrCndnScalesTP.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrHdrCndnScalesTP.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _CntrlPurContrHdrCndnScalesTP.ConditionSequentialNumber = $projection.ConditionSequentialNumber`
[0..1]	I_PurConditionText	_ConditionText	`$projection.ConditionType = _ConditionText.ConditionType and _ConditionText.ConditionApplication = 'M' and _ConditionText.Language = $session.system_language`
[0..1]	I_PricingScaleBasisText	_PricingScaleBasisText	`_PricingScaleBasisText.PricingScaleBasis = $projection.PricingScaleBasis and _PricingScaleBasisText.Language = $session.system_language`
[0..1]	I_PrcgScaleCheckingRuleText	_PrcgScaleCheckingRuleText	`_PrcgScaleCheckingRuleText.PricingScaleCheckingRule = $projection.PricingScaleCheckingRule and _PrcgScaleCheckingRuleText.Language = $session.system_language`
[0..1]	I_PurgCndnChangeReasonText	_PurgCndnChangeReasonText	`$projection.ConditionChangeReason = _PurgCndnChangeReasonText.ConditionChangeReason and _PurgCndnChangeReasonText.Language = $session.system_language`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	CCCTRHCNDNAMT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Central Purchase Contract Hdr Condition	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.createEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
UI.headerInfo.typeName	Condition Amount	view
UI.headerInfo.typeNamePlural	Condition Amounts	view
UI.headerInfo.title.value	ConditionText	view
UI.headerInfo.description.value	ConditionType	view

Fields (51)

Key	Field	Source Table	Source Field	Description
KEY	CentralPurchaseContract		CentralPurchaseContract	Purchasing Doc.
KEY	ConditionRecord		ConditionRecord	Cond.Record No.
KEY	ConditionValidityEndDate		ConditionValidityEndDate	Valid To
KEY	ConditionSequentialNumber		ConditionSequentialNumber	SequNo of Cond.
	ConditionType		ConditionType	Condition type
	ConditionText	_ConditionText	ConditionText	Node Condition Text
	ConditionTextID		ConditionTextID	Text number
	ConditionCalculationType		ConditionCalculationType	Calculat.Type
	ConditionRateValue		ConditionRateValue	Condition Rate Value
	ConditionRateValueUnit		ConditionRateValueUnit	Unit of Condition Rate Value
	ConditionRateRatioUnit		ConditionRateRatioUnit	Unit of Measure
	ConditionRateRatio		ConditionRateRatio	Ratio
	ConditionCurrency		ConditionCurrency	Currency
	ConditionRateAmount		ConditionRateAmount	Condition Amount
	ConditionRateValueIsAmount		ConditionRateValueIsAmount	TRUE
	ConditionRateValueIsRatio		ConditionRateValueIsRatio	TRUE
	ConditionQuantity		ConditionQuantity	Pricing Unit
	ConditionQuantityUnit		ConditionQuantityUnit	Order Price Unit
	ConditionToBaseQtyNmrtr		ConditionToBaseQtyNmrtr	Numerator
	ConditionToBaseQtyDnmntr		ConditionToBaseQtyDnmntr	Denominator
	BaseUnit		BaseUnit	Unit of Measure
	ConditionLowerLimit		ConditionLowerLimit	Lower limit
	ConditionUpperLimit		ConditionUpperLimit	Upper limit
	ConditionAlternativeCurrency		ConditionAlternativeCurrency	Cndn Currency
	ConditionExclusion		ConditionExclusion	Exclusion
	ConditionIsDeleted		ConditionIsDeleted	Deletion Indic.
	AdditionalValueDays		AdditionalValueDays	Add. Value Days
	FixedValueDate		FixedValueDate	Fixed Val. Date
	PaymentTerms		PaymentTerms	Pyt Terms
	CndnMaxNumberOfSalesOrders		CndnMaxNumberOfSalesOrders	NumberOfOrders
	MinimumConditionBasisValue		MinimumConditionBasisValue	MinCondBaseVal.
	MaximumConditionBasisValue		MaximumConditionBasisValue	MaxCondBaseVal.
	MaximumConditionAmount		MaximumConditionAmount	MaxConditValue
	ConditionReleaseStatus		ConditionReleaseStatus	Release Status
	ConditionChangeReason		ConditionChangeReason	Reason
	ConditionChangeReasonText	_PurgCndnChangeReasonText	ConditionChangeReasonText	Description
	CmmdtyPricingEngineIsEnabled		CmmdtyPricingEngineIsEnabled	Enabled for CPE
	ConditionValidityStartDate		ConditionValidityStartDate	Valid From
	PricingScaleType		PricingScaleType	Scale Type
	PricingScaleBasis		PricingScaleBasis	Scale Basis
	PricingScaleBasisName	_PricingScaleBasisText	PricingScaleBasisName	Scale Basis Description
	PricingScaleCheckingRule		PricingScaleCheckingRule	Check
	PricingScaleCheckingRuleName	_PrcgScaleCheckingRuleText	PricingScaleCheckingRuleName
	PricingScaleLine		PricingScaleLine	Pricing scale
	ConditionHasScales		ConditionHasScales	Scale
	IsExtPurgScenario	_CentralPurchaseContractTP	IsExtPurgScenario	Is Central PR
	_CentralPurchaseContractTP		_CentralPurchaseContractTP
	_DocumentCurrency		_DocumentCurrency
	_CntrlPurContrHdrCndnValdty		_CntrlPurContrHdrCndnValdty
	_CntrlPurContrHdrCndnScalesTP		_CntrlPurContrHdrCndnScalesTP
	_ConditionText		_ConditionText

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 C_CntrlPurContrHdrCndnAmount.
-- 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: CCCTRHCNDNAMT

CREATE VIEW C_CntrlPurContrHdrCndnAmount AS
SELECT
  CentralPurchaseContract,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionSequentialNumber,
  ConditionType,
  _ConditionText.ConditionText AS ConditionText,
  ConditionTextID,
  ConditionCalculationType,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateRatioUnit,
  ConditionRateRatio,
  ConditionCurrency,
  ConditionRateAmount,
  ConditionRateValueIsAmount,
  ConditionRateValueIsRatio,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  ConditionChangeReason,
  _PurgCndnChangeReasonText.ConditionChangeReasonText AS ConditionChangeReasonText,
  CmmdtyPricingEngineIsEnabled,
  ConditionValidityStartDate,
  PricingScaleType,
  PricingScaleBasis,
  _PricingScaleBasisText.PricingScaleBasisName AS PricingScaleBasisName,
  PricingScaleCheckingRule,
  _PrcgScaleCheckingRuleText.PricingScaleCheckingRuleName AS PricingScaleCheckingRuleName,
  PricingScaleLine,
  ConditionHasScales,
  _CentralPurchaseContractTP.IsExtPurgScenario AS IsExtPurgScenario
FROM I_CntrlPurContrHdrCndnAmountTP
LEFT OUTER JOIN C_CntrlPurContrHdrCndnValdty AS _CntrlPurContrHdrCndnValdty ON CentralPurchaseContract = _CntrlPurContrHdrCndnValdty.CentralPurchaseContract AND ConditionRecord = _CntrlPurContrHdrCndnValdty.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrHdrCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHdrCndnScalesTP AS _CntrlPurContrHdrCndnScalesTP ON _CntrlPurContrHdrCndnScalesTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrCndnScalesTP.ConditionRecord = ConditionRecord AND _CntrlPurContrHdrCndnScalesTP.ConditionValidityEndDate = ConditionValidityEndDate AND _CntrlPurContrHdrCndnScalesTP.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON ConditionType = _ConditionText.ConditionType AND _ConditionText.ConditionApplication = 'M' AND _ConditionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PricingScaleBasisText AS _PricingScaleBasisText ON _PricingScaleBasisText.PricingScaleBasis = PricingScaleBasis AND _PricingScaleBasisText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrcgScaleCheckingRuleText AS _PrcgScaleCheckingRuleText ON _PrcgScaleCheckingRuleText.PricingScaleCheckingRule = PricingScaleCheckingRule AND _PrcgScaleCheckingRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgCndnChangeReasonText AS _PurgCndnChangeReasonText ON ConditionChangeReason = _PurgCndnChangeReasonText.ConditionChangeReason AND _PurgCndnChangeReasonText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_CntrlPurContrHdrCndnAmount view

I_CntrlPurContrHdrCndnAmountTP view