What is C_PurContrHdrCndnAmountTP in SAP S/4HANA?

C_PurContrHdrCndnAmountTP is a consumption CDS view in SAP S/4HANA. Contract Header Condition Amount It contains 54 fields.

Which tables does C_PurContrHdrCndnAmountTP read from?

C_PurContrHdrCndnAmountTP reads data from: I_PurContrHdrCndnAmountTP.

What VDM layer is C_PurContrHdrCndnAmountTP?

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

C_PurContrHdrCndnAmountTP

DDL: C_PURCONTRHDRCNDNAMOUNTTP SQL: CPCTRHCNDNAMT Type: view CONSUMPTION Package: ODATA_MM_OA_MAINTAIN

54 Fields 1 Data Sources 7 Associations

Contract Header Condition Amount

C_PurContrHdrCndnAmountTP is a Consumption CDS View that provides data about "Contract Header Condition Amount" in SAP S/4HANA. It reads from 1 data source (I_PurContrHdrCndnAmountTP) and exposes 54 fields with key fields PurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 7 associations to related views. Part of development package ODATA_MM_OA_MAINTAIN.

Data Sources (1)

Source	Alias	Join Type
I_PurContrHdrCndnAmountTP	I_PurContrHdrCndnAmountTP	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..1]	C_PurContrHdrCndnValdtyTP	_PurContrHdrCndnValdtyTP	`$projection.PurchaseContract = _PurContrHdrCndnValdtyTP.PurchaseContract and $projection.ConditionRecord = _PurContrHdrCndnValdtyTP.ConditionRecord and $projection.ConditionValidityEndDate = _PurContrHdrCndnValdtyTP.ConditionValidityEndDate`
[1..1]	C_ContractMaintain	_PurchaseContractTP	`_PurchaseContractTP.PurchaseContract = $projection.PurchaseContract`
[0..*]	C_PurContrHdrCndnScaleTP	_PurContrHdrCndnScaleTP	`_PurContrHdrCndnScaleTP.PurchaseContract = $projection.PurchaseContract and _PurContrHdrCndnScaleTP.ConditionRecord = $projection.ConditionRecord and _PurContrHdrCndnScaleTP.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _PurContrHdrCndnScaleTP.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	CPCTRHCNDNAMT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Contract Header Condition Amount	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	#L	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 (54)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract		PurchaseContract	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
	ConditionLowerLimitAmount		ConditionLowerLimitAmount	Lower Limit
	ConditionLowerLimitRatio		ConditionLowerLimitRatio	Lower Limit Ratio
	ConditionUpperLimitAmount		ConditionUpperLimitAmount	Upper Limit
	ConditionUpperLimitRatio		ConditionUpperLimitRatio	Upper Limit Ratio
	_PurchaseContractTP		_PurchaseContractTP
	_DocumentCurrency		_DocumentCurrency
	_PurContrHdrCndnValdtyTP		_PurContrHdrCndnValdtyTP
	_PurContrHdrCndnScaleTP		_PurContrHdrCndnScaleTP
	_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_PurContrHdrCndnAmountTP.
-- 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: CPCTRHCNDNAMT

CREATE VIEW C_PurContrHdrCndnAmountTP AS
SELECT
  PurchaseContract,
  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,
  ConditionLowerLimitAmount,
  ConditionLowerLimitRatio,
  ConditionUpperLimitAmount,
  ConditionUpperLimitRatio
FROM I_PurContrHdrCndnAmountTP
LEFT OUTER JOIN C_PurContrHdrCndnValdtyTP AS _PurContrHdrCndnValdtyTP ON PurchaseContract = _PurContrHdrCndnValdtyTP.PurchaseContract AND ConditionRecord = _PurContrHdrCndnValdtyTP.ConditionRecord AND ConditionValidityEndDate = _PurContrHdrCndnValdtyTP.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractTP ON _PurchaseContractTP.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurContrHdrCndnScaleTP AS _PurContrHdrCndnScaleTP ON _PurContrHdrCndnScaleTP.PurchaseContract = PurchaseContract AND _PurContrHdrCndnScaleTP.ConditionRecord = ConditionRecord AND _PurContrHdrCndnScaleTP.ConditionValidityEndDate = ConditionValidityEndDate AND _PurContrHdrCndnScaleTP.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_PurContrHdrCndnAmountTP view

I_PurContrHdrCndnAmountTP view