What is A_PurContrHdrCndnAmount in SAP S/4HANA?

A_PurContrHdrCndnAmount is a composite CDS view in SAP S/4HANA. Purchase Contract Header Conditions Amount It contains 46 fields.

Which tables does A_PurContrHdrCndnAmount read from?

A_PurContrHdrCndnAmount reads data from: I_PurContrHdrCndnAmount.

What VDM layer is A_PurContrHdrCndnAmount?

A_PurContrHdrCndnAmount is classified as a Composite view that combines data from multiple basic views.

A_PurContrHdrCndnAmount

DDL: A_PURCONTRHDRCNDNAMOUNT SQL: ACTRHDRCNDAMT Type: view COMPOSITE Package: ODATA_MM_PUR_CON_API

46 Fields 1 Data Sources 3 Associations

Purchase Contract Header Conditions Amount

A_PurContrHdrCndnAmount is a Composite CDS View that provides data about "Purchase Contract Header Conditions Amount" in SAP S/4HANA. It reads from 1 data source (I_PurContrHdrCndnAmount) and exposes 46 fields with key fields PurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 3 associations to related views. Part of development package ODATA_MM_PUR_CON_API.

Data Sources (1)

Source	Alias	Join Type
I_PurContrHdrCndnAmount	PurContrHdrCondition	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	A_PurContrHdrCndnValdty	_PurContrHdrCndnValdty	`$projection.PurchaseContract = _PurContrHdrCndnValdty.PurchaseContract and $projection.ConditionRecord = _PurContrHdrCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _PurContrHdrCndnValdty.ConditionValidityEndDate`
[1..1]	A_PurchaseContract_2	_PurchaseContract	`_PurchaseContract.PurchaseContract = $projection.PurchaseContract`
[0..*]	A_PurContrHdrCndnScale	_PurContrHdrCndnScale	`_PurContrHdrCndnScale.PurchaseContract = $projection.PurchaseContract and _PurContrHdrCndnScale.ConditionRecord = $projection.ConditionRecord and _PurContrHdrCndnScale.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _PurContrHdrCndnScale.ConditionSequentialNumber = $projection.ConditionSequentialNumber`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	ACTRHDRCNDAMT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
VDM.viewType	#COMPOSITE	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Purchase Contract Header Conditions Amount	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract	I_PurContrHdrCndnAmount	PurchaseContract	Purchasing Doc.
KEY	ConditionRecord	I_PurContrHdrCndnAmount	ConditionRecord	Cond.Record No.
KEY	ConditionValidityEndDate	I_PurContrHdrCndnAmount	ConditionValidityEndDate	Valid To
KEY	ConditionSequentialNumber	I_PurContrHdrCndnAmount	ConditionSequentialNumber	SequNo of Cond.
	ConditionValidityStartDate	I_PurContrHdrCndnAmount	ConditionValidityStartDate	Valid From
	ConditionType	I_PurContrHdrCndnAmount	ConditionType	Condition type
	ConditionTextID	I_PurContrHdrCndnAmount	ConditionTextID	Text number
	ConditionCalculationType	I_PurContrHdrCndnAmount	ConditionCalculationType	Calculat.Type
	ConditionRateRatioUnit	I_PurContrHdrCndnAmount	ConditionRateRatioUnit	Unit of Measure
	PurContrCndnRateRatioUntISOCd	I_PurContrHdrCndnAmount	PurContrCndnRateRatioUntISOCd
	ConditionRateRatio	I_PurContrHdrCndnAmount	ConditionRateRatio	Ratio
	ConditionCurrency	I_PurContrHdrCndnAmount	ConditionCurrency	Currency
	ConditionRateAmount	I_PurContrHdrCndnAmount	ConditionRateAmount	Condition Amount
	ConditionRateValue	I_PurContrHdrCndnAmount	ConditionRateValue	Condition Rate Value
	ConditionRateValueUnit	I_PurContrHdrCndnAmount	ConditionRateValueUnit	Unit of Condition Rate Value
	ConditionQuantity	I_PurContrHdrCndnAmount	ConditionQuantity	Pricing Unit
	ConditionQuantityUnit	I_PurContrHdrCndnAmount	ConditionQuantityUnit	Unit of Measure
	PurContrCndnQtyUnitISOCode	I_PurContrHdrCndnAmount	PurContrCndnQtyUnitISOCode
	ConditionToBaseQtyNmrtr	I_PurContrHdrCndnAmount	ConditionToBaseQtyNmrtr	Numerator
	ConditionToBaseQtyDnmntr	I_PurContrHdrCndnAmount	ConditionToBaseQtyDnmntr	Denominator
	BaseUnit	I_PurContrHdrCndnAmount	BaseUnit	Unit of Measure
	PurContrBaseUnitISOCode	I_PurContrHdrCndnAmount	PurContrBaseUnitISOCode
	ConditionLowerLimitAmount		ConditionLowerLimitAmount	Amount
	ConditionLowerLimitRatio		ConditionLowerLimitRatio	Ratio
	ConditionUpperLimitAmount		ConditionUpperLimitAmount	Amount
	ConditionUpperLimitRatio		ConditionUpperLimitRatio	Ratio
	ConditionAlternativeCurrency	I_PurContrHdrCndnAmount	ConditionAlternativeCurrency	Cndn Currency
	ConditionExclusion	I_PurContrHdrCndnAmount	ConditionExclusion	Exclusion
	ConditionIsDeleted	I_PurContrHdrCndnAmount	ConditionIsDeleted	Deletion Indic.
	AdditionalValueDays	I_PurContrHdrCndnAmount	AdditionalValueDays	Add. Value Days
	FixedValueDate	I_PurContrHdrCndnAmount	FixedValueDate	Fixed Val. Date
	PaymentTerms	I_PurContrHdrCndnAmount	PaymentTerms	Pyt Terms
	CndnMaxNumberOfSalesOrders	I_PurContrHdrCndnAmount	CndnMaxNumberOfSalesOrders	NumberOfOrders
	MinimumConditionBasisValue	I_PurContrHdrCndnAmount	MinimumConditionBasisValue	MinCondBaseVal.
	MaximumConditionBasisValue	I_PurContrHdrCndnAmount	MaximumConditionBasisValue	MaxCondBaseVal.
	MaximumConditionAmount	I_PurContrHdrCndnAmount	MaximumConditionAmount	MaxConditValue
	ConditionReleaseStatus	I_PurContrHdrCndnAmount	ConditionReleaseStatus	Release Status
	ConditionChangeReason	I_PurContrHdrCndnAmount	ConditionChangeReason	Cndn Change Reason
	PricingScaleType	I_PurContrHdrCndnAmount	PricingScaleType	Scale Type
	PricingScaleBasis	I_PurContrHdrCndnAmount	PricingScaleBasis	Scale Basis
	PricingScaleLine	I_PurContrHdrCndnAmount	PricingScaleLine	Pricing scale
	ConditionHasScales	I_PurContrHdrCndnAmount	ConditionHasScales	Scales
	PricingScaleCheckingRule	I_PurContrHdrCndnAmount	PricingScaleCheckingRule	Check Scale
	_PurContrHdrCndnValdty		_PurContrHdrCndnValdty
	_PurchaseContract		_PurchaseContract
	_PurContrHdrCndnScale		_PurContrHdrCndnScale

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 A_PurContrHdrCndnAmount.
-- 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: ACTRHDRCNDAMT

CREATE VIEW A_PurContrHdrCndnAmount AS
SELECT
  PurContrHdrCondition.PurchaseContract AS PurchaseContract,
  PurContrHdrCondition.ConditionRecord AS ConditionRecord,
  PurContrHdrCondition.ConditionValidityEndDate AS ConditionValidityEndDate,
  PurContrHdrCondition.ConditionSequentialNumber AS ConditionSequentialNumber,
  PurContrHdrCondition.ConditionValidityStartDate AS ConditionValidityStartDate,
  PurContrHdrCondition.ConditionType AS ConditionType,
  PurContrHdrCondition.ConditionTextID AS ConditionTextID,
  PurContrHdrCondition.ConditionCalculationType AS ConditionCalculationType,
  PurContrHdrCondition.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PurContrHdrCondition.PurContrCndnRateRatioUntISOCd AS PurContrCndnRateRatioUntISOCd,
  PurContrHdrCondition.ConditionRateRatio AS ConditionRateRatio,
  PurContrHdrCondition.ConditionCurrency AS ConditionCurrency,
  PurContrHdrCondition.ConditionRateAmount AS ConditionRateAmount,
  PurContrHdrCondition.ConditionRateValue AS ConditionRateValue,
  PurContrHdrCondition.ConditionRateValueUnit AS ConditionRateValueUnit,
  PurContrHdrCondition.ConditionQuantity AS ConditionQuantity,
  PurContrHdrCondition.ConditionQuantityUnit AS ConditionQuantityUnit,
  PurContrHdrCondition.PurContrCndnQtyUnitISOCode AS PurContrCndnQtyUnitISOCode,
  PurContrHdrCondition.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  PurContrHdrCondition.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  PurContrHdrCondition.BaseUnit AS BaseUnit,
  PurContrHdrCondition.PurContrBaseUnitISOCode AS PurContrBaseUnitISOCode,
  ConditionLowerLimitAmount,
  ConditionLowerLimitRatio,
  ConditionUpperLimitAmount,
  ConditionUpperLimitRatio,
  PurContrHdrCondition.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  PurContrHdrCondition.ConditionExclusion AS ConditionExclusion,
  PurContrHdrCondition.ConditionIsDeleted AS ConditionIsDeleted,
  PurContrHdrCondition.AdditionalValueDays AS AdditionalValueDays,
  PurContrHdrCondition.FixedValueDate AS FixedValueDate,
  PurContrHdrCondition.PaymentTerms AS PaymentTerms,
  PurContrHdrCondition.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  PurContrHdrCondition.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  PurContrHdrCondition.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  PurContrHdrCondition.MaximumConditionAmount AS MaximumConditionAmount,
  PurContrHdrCondition.ConditionReleaseStatus AS ConditionReleaseStatus,
  PurContrHdrCondition.ConditionChangeReason AS ConditionChangeReason,
  PurContrHdrCondition.PricingScaleType AS PricingScaleType,
  PurContrHdrCondition.PricingScaleBasis AS PricingScaleBasis,
  PurContrHdrCondition.PricingScaleLine AS PricingScaleLine,
  PurContrHdrCondition.ConditionHasScales AS ConditionHasScales,
  PurContrHdrCondition.PricingScaleCheckingRule AS PricingScaleCheckingRule
FROM I_PurContrHdrCndnAmount AS PurContrHdrCondition
LEFT OUTER JOIN A_PurContrHdrCndnValdty AS _PurContrHdrCndnValdty ON PurchaseContract = _PurContrHdrCndnValdty.PurchaseContract AND ConditionRecord = _PurContrHdrCndnValdty.ConditionRecord AND ConditionValidityEndDate = _PurContrHdrCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN A_PurchaseContract_2 AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_PurContrHdrCndnScale AS _PurContrHdrCndnScale ON _PurContrHdrCndnScale.PurchaseContract = PurchaseContract AND _PurContrHdrCndnScale.ConditionRecord = ConditionRecord AND _PurContrHdrCndnScale.ConditionValidityEndDate = ConditionValidityEndDate AND _PurContrHdrCndnScale.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
;

Depth:

A_PurContrHdrCndnAmount view

I_PurContrHdrCndnAmount view