What is A_CntrlPurContrHdrCndnAmount in SAP S/4HANA?

A_CntrlPurContrHdrCndnAmount is a composite CDS view in SAP S/4HANA. Header Condition Amount It contains 42 fields.

Which tables does A_CntrlPurContrHdrCndnAmount read from?

A_CntrlPurContrHdrCndnAmount reads data from: I_CntrlPurContrHdrCndnAmount.

What VDM layer is A_CntrlPurContrHdrCndnAmount?

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

A_CntrlPurContrHdrCndnAmount

DDL: A_CNTRLPURCONTRHDRCNDNAMOUNT SQL: ACCCTRHCNDNAMT Type: view COMPOSITE Package: ODATA_MM_PUR_CCTR_API

42 Fields 1 Data Sources 3 Associations

Header Condition Amount

A_CntrlPurContrHdrCndnAmount is a Composite CDS View that provides data about "Header Condition Amount" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrHdrCndnAmount) and exposes 42 fields with key fields CentralPurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 3 associations to related views. Part of development package ODATA_MM_PUR_CCTR_API.

Data Sources (1)

Source	Alias	Join Type
I_CntrlPurContrHdrCndnAmount	CntrlPurContrHdrCondition	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	A_CntrlPurContrHdrCndnValdty	_CntrlPurContrHdrCndnValdty	`$projection.CentralPurchaseContract = _CntrlPurContrHdrCndnValdty.CentralPurchaseContract and $projection.ConditionRecord = _CntrlPurContrHdrCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _CntrlPurContrHdrCndnValdty.ConditionValidityEndDate`
[1..1]	A_CentralPurchaseContract	_CentralPurchaseContract	`_CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract`
[0..*]	A_CntrlPurContrHdrCndnScales	_CntrlPurContrHdrCndnScales	`_CntrlPurContrHdrCndnScales.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrHdrCndnScales.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrHdrCndnScales.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _CntrlPurContrHdrCndnScales.ConditionSequentialNumber = $projection.ConditionSequentialNumber`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	ACCCTRHCNDNAMT	view
AbapCatalog.compiler.compareFilter	true	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Header Condition Amount	view
VDM.viewType	#COMPOSITE	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
AbapCatalog.preserveKey	true	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (42)

Key	Field	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
	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
	ConditionQuantity	ConditionQuantity	Pricing Unit
	ConditionQuantityUnit	ConditionQuantityUnit	Unit of Measure
	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	Cndn Change Reason
	CmmdtyPricingEngineIsEnabled	CmmdtyPricingEngineIsEnabled	Enabled for CPE
	ConditionValidityStartDate	ConditionValidityStartDate	Valid From
	PricingScaleType	PricingScaleType	Scale Type
	PricingScaleBasis	PricingScaleBasis	Scale Basis
	PricingScaleCheckingRule	PricingScaleCheckingRule	Check Scale
	PricingScaleLine	PricingScaleLine	Pricing scale
	ConditionHasScales	ConditionHasScales	Scales
	_CentralPurchaseContract	_CentralPurchaseContract
	_CntrlPurContrHdrCndnValdty	_CntrlPurContrHdrCndnValdty
	_CntrlPurContrHdrCndnScales	_CntrlPurContrHdrCndnScales

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_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: ACCCTRHCNDNAMT

CREATE VIEW A_CntrlPurContrHdrCndnAmount AS
SELECT
  CentralPurchaseContract,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionSequentialNumber,
  ConditionType,
  ConditionTextID,
  ConditionCalculationType,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateRatioUnit,
  ConditionRateRatio,
  ConditionCurrency,
  ConditionRateAmount,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  ConditionChangeReason,
  CmmdtyPricingEngineIsEnabled,
  ConditionValidityStartDate,
  PricingScaleType,
  PricingScaleBasis,
  PricingScaleCheckingRule,
  PricingScaleLine,
  ConditionHasScales
FROM I_CntrlPurContrHdrCndnAmount AS CntrlPurContrHdrCondition
LEFT OUTER JOIN A_CntrlPurContrHdrCndnValdty AS _CntrlPurContrHdrCndnValdty ON CentralPurchaseContract = _CntrlPurContrHdrCndnValdty.CentralPurchaseContract AND ConditionRecord = _CntrlPurContrHdrCndnValdty.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrHdrCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_CntrlPurContrHdrCndnScales AS _CntrlPurContrHdrCndnScales ON _CntrlPurContrHdrCndnScales.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrCndnScales.ConditionRecord = ConditionRecord AND _CntrlPurContrHdrCndnScales.ConditionValidityEndDate = ConditionValidityEndDate AND _CntrlPurContrHdrCndnScales.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
;

Depth:

A_CntrlPurContrHdrCndnAmount view

I_CntrlPurContrHdrCndnAmount view