A_CntrlPurContrItmCndnAmount

DDL: A_CNTRLPURCONTRITMCNDNAMOUNT SQL: ACCCTRICNDNAMT Type: view COMPOSITE Package: ODATA_MM_PUR_CCTR_API
44 Fields 1 Data Sources 3 Associations

Item Condition Amount

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

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrItmCndnAmount CntrlPurContrItemCondition from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty $projection.CentralPurchaseContract = _CntrlPurContrItmCndnValdty.CentralPurchaseContract and $projection.CentralPurchaseContractItem = _CntrlPurContrItmCndnValdty.CentralPurchaseContractItem and $projection.ConditionRecord = _CntrlPurContrItmCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _CntrlPurContrItmCndnValdty.ConditionValidityEndDate
[1..1] A_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract
[0..*] A_CntrlPurContrItmCndnScales _CntrlPurContrItmCndnScales _CntrlPurContrItmCndnScales.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrItmCndnScales.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrItmCndnScales.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrItmCndnScales.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _CntrlPurContrItmCndnScales.ConditionSequentialNumber = $projection.ConditionSequentialNumber

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ACCCTRICNDNAMT view
AbapCatalog.compiler.compareFilter true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Item 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 (44)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
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
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
PricingScaleType PricingScaleType Scale Type
PricingScaleBasis PricingScaleBasis Scale Basis
PricingScaleCheckingRule PricingScaleCheckingRule Check Scale
PricingScaleLine PricingScaleLine Pricing scale
ConditionHasScales ConditionHasScales Scales
_CentralPurchaseContract _CentralPurchaseContract
_CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty
_CntrlPurContrItmCndnScales _CntrlPurContrItmCndnScales

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_CntrlPurContrItmCndnAmount.
-- 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: ACCCTRICNDNAMT

CREATE VIEW A_CntrlPurContrItmCndnAmount AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  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,
  ProcmtHubPlantUniqueID,
  PricingScaleType,
  PricingScaleBasis,
  PricingScaleCheckingRule,
  PricingScaleLine,
  ConditionHasScales
FROM I_CntrlPurContrItmCndnAmount AS CntrlPurContrItemCondition
LEFT OUTER JOIN A_CntrlPurContrItmCndnValdty AS _CntrlPurContrItmCndnValdty ON CentralPurchaseContract = _CntrlPurContrItmCndnValdty.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrItmCndnValdty.CentralPurchaseContractItem AND ConditionRecord = _CntrlPurContrItmCndnValdty.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrItmCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_CntrlPurContrItmCndnScales AS _CntrlPurContrItmCndnScales ON _CntrlPurContrItmCndnScales.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItmCndnScales.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmCndnScales.ConditionRecord = ConditionRecord AND _CntrlPurContrItmCndnScales.ConditionValidityEndDate = ConditionValidityEndDate AND _CntrlPurContrItmCndnScales.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
;

Learn More