What is C_PurContrItmCndnAmountTP in SAP S/4HANA?

C_PurContrItmCndnAmountTP is a consumption CDS view in SAP S/4HANA. Purchase contract item condition amount It contains 60 fields.

Which tables does C_PurContrItmCndnAmountTP read from?

C_PurContrItmCndnAmountTP reads data from: I_PurContrItmCndnAmountTP_2.

What VDM layer is C_PurContrItmCndnAmountTP?

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

C_PurContrItmCndnAmountTP

DDL: C_PURCONTRITMCNDNAMOUNTTP SQL: CCTRICNDNAMTTP Type: view CONSUMPTION

60 Fields 1 Data Sources 8 Associations

Purchase contract item condition amount

C_PurContrItmCndnAmountTP is a Consumption CDS View that provides data about "Purchase contract item condition amount" in SAP S/4HANA. It reads from 1 data source (I_PurContrItmCndnAmountTP_2) and exposes 60 fields with key fields PurchaseContract, PurchaseContractItem, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 8 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurContrItmCndnAmountTP_2	I_PurContrItmCndnAmountTP_2	from

Associations (8)

Cardinality	Target	Alias	Condition
[1..1]	C_PurContrItmCndnValdtyTP	_PurContrItmCndnValdtyTP	`$projection.PurchaseContract = _PurContrItmCndnValdtyTP.PurchaseContract and $projection.PurchaseContractItem = _PurContrItmCndnValdtyTP.PurchaseContractItem and $projection.ConditionRecord = _PurContrItmCndnValdtyTP.ConditionRecord and $projection.ConditionValidityEndDate = _PurContrItmCndnValdtyTP.ConditionValidityEndDate`
[1..1]	C_ContractMaintain	_PurchaseContractTP	`_PurchaseContractTP.PurchaseContract = $projection.PurchaseContract`
[0..*]	C_PurContrItmCndnScalesTP	_PurContrItmCndnScalesTP	`_PurContrItmCndnScalesTP.PurchaseContract = $projection.PurchaseContract and _PurContrItmCndnScalesTP.PurchaseContractItem = $projection.PurchaseContractItem and _PurContrItmCndnScalesTP.ConditionRecord = $projection.ConditionRecord and _PurContrItmCndnScalesTP.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _PurContrItmCndnScalesTP.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]	C_MM_PlantValueHelp	_PlantValueHelp	`_PlantValueHelp.Plant = $projection.Plant and _PlantValueHelp.PurchasingOrganization = $projection.PurchasingOrganization`
[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	CCTRICNDNAMTTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Purchase contract item 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 (60)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract		PurchaseContract	Purchasing Doc.
KEY	PurchaseContractItem		PurchaseContractItem	Item
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
	ConditionCurrency		ConditionCurrency	Currency
	ConditionRateAmount		ConditionRateAmount	Condition Amount
	ConditionRateValue		ConditionRateValue	Condition Rate Value
	ConditionRateValueUnit		ConditionRateValueUnit	Unit of Condition Rate Value
	ConditionRateRatioUnit		ConditionRateRatioUnit	Unit of Measure
	ConditionRateRatio		ConditionRateRatio	Ratio
	ConditionRateValueIsAmount		ConditionRateValueIsAmount	TRUE
	ConditionRateValueIsRatio		ConditionRateValueIsRatio	TRUE
	ConditionCalculationType		ConditionCalculationType	Calculat.Type
	ConditionQuantity		ConditionQuantity	Pricing Unit
	ConditionQuantityUnit		ConditionQuantityUnit	Unit of Measure
	ConditionToBaseQtyNmrtr		ConditionToBaseQtyNmrtr	Quantity in Base Unit of Measure
	ConditionToBaseQtyDnmntr		ConditionToBaseQtyDnmntr	Quantity in Pricing Unit
	BaseUnit		BaseUnit	Base Unit of Measure
	ConditionUnitConversionText		ConditionUnitConversionText	Conversion Ratio
	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
	ConditionValidityStartDate		ConditionValidityStartDate	Valid From
	Plant		Plant	Valuation Area
	PlantName	_PlantValueHelp	PlantName	Plant Name
	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
	ConditionHasUoMConversion		ConditionHasUoMConversion	Unit Conversion
	ConditionLowerLimitAmount		ConditionLowerLimitAmount	Lower Limit
	ConditionLowerLimitRatio		ConditionLowerLimitRatio	Lower Limit Ratio
	ConditionUpperLimitAmount		ConditionUpperLimitAmount	Upper Limit
	ConditionUpperLimitRatio		ConditionUpperLimitRatio	Upper Limit Ratio
	PurchasingOrganization	I_PurContrItmCndnAmountTP_2	PurchasingOrganization	Purchasing Organization
	_PurchaseContractTP		_PurchaseContractTP
	_DocumentCurrency		_DocumentCurrency
	_PurContrItmCndnValdtyTP		_PurContrItmCndnValdtyTP
	_PurContrItmCndnScalesTP		_PurContrItmCndnScalesTP
	_ConditionText		_ConditionText
	_PlantValueHelp		_PlantValueHelp

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_PurContrItmCndnAmountTP.
-- 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: CCTRICNDNAMTTP

CREATE VIEW C_PurContrItmCndnAmountTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionSequentialNumber,
  ConditionType,
  _ConditionText.ConditionText AS ConditionText,
  ConditionTextID,
  ConditionCurrency,
  ConditionRateAmount,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateRatioUnit,
  ConditionRateRatio,
  ConditionRateValueIsAmount,
  ConditionRateValueIsRatio,
  ConditionCalculationType,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionUnitConversionText,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  ConditionChangeReason,
  _PurgCndnChangeReasonText.ConditionChangeReasonText AS ConditionChangeReasonText,
  ConditionValidityStartDate,
  Plant,
  _PlantValueHelp.PlantName AS PlantName,
  PricingScaleType,
  PricingScaleBasis,
  _PricingScaleBasisText.PricingScaleBasisName AS PricingScaleBasisName,
  PricingScaleCheckingRule,
  _PrcgScaleCheckingRuleText.PricingScaleCheckingRuleName AS PricingScaleCheckingRuleName,
  PricingScaleLine,
  ConditionHasScales,
  ConditionHasUoMConversion,
  ConditionLowerLimitAmount,
  ConditionLowerLimitRatio,
  ConditionUpperLimitAmount,
  ConditionUpperLimitRatio,
  I_PurContrItmCndnAmountTP_2.PurchasingOrganization AS PurchasingOrganization
FROM I_PurContrItmCndnAmountTP_2
LEFT OUTER JOIN C_PurContrItmCndnValdtyTP AS _PurContrItmCndnValdtyTP ON PurchaseContract = _PurContrItmCndnValdtyTP.PurchaseContract AND PurchaseContractItem = _PurContrItmCndnValdtyTP.PurchaseContractItem AND ConditionRecord = _PurContrItmCndnValdtyTP.ConditionRecord AND ConditionValidityEndDate = _PurContrItmCndnValdtyTP.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractTP ON _PurchaseContractTP.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurContrItmCndnScalesTP AS _PurContrItmCndnScalesTP ON _PurContrItmCndnScalesTP.PurchaseContract = PurchaseContract AND _PurContrItmCndnScalesTP.PurchaseContractItem = PurchaseContractItem AND _PurContrItmCndnScalesTP.ConditionRecord = ConditionRecord AND _PurContrItmCndnScalesTP.ConditionValidityEndDate = ConditionValidityEndDate AND _PurContrItmCndnScalesTP.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 C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant AND _PlantValueHelp.PurchasingOrganization = PurchasingOrganization  -- 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_PurContrItmCndnAmountTP view

I_PurContrItmCndnAmountTP_2 view