I_CntrlPurContrHdrCndnAmountTP

DDL: I_CNTRLPURCONTRHDRCNDNAMOUNTTP SQL: ICCTRHCNDNAMTTP Type: view TRANSACTIONAL
47 Fields 1 Data Sources 4 Associations

Central Purchase Contract Hdr Condition

I_CntrlPurContrHdrCndnAmountTP is a Transactional CDS View that provides data about "Central Purchase Contract Hdr Condition" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrHdrCndnAmount) and exposes 47 fields with key fields CentralPurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrHdrCndnAmount CntrlPurContrHdrCondition from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CntrlPurContrHdrCndnValdtyTP _CntrlPurContrHdrCndnValdtyTP $projection.CentralPurchaseContract = _CntrlPurContrHdrCndnValdtyTP.CentralPurchaseContract and $projection.ConditionRecord = _CntrlPurContrHdrCndnValdtyTP.ConditionRecord and $projection.ConditionValidityEndDate = _CntrlPurContrHdrCndnValdtyTP.ConditionValidityEndDate
[0..1] I_Currency _DocumentCurrency $projection.ConditionCurrency = _DocumentCurrency.Currency
[1..1] I_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[0..*] I_CntrlPurContrHdrCndnScalesTP _CntrlPurContrHdrCndnScalesTP _CntrlPurContrHdrCndnScalesTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrHdrCndnScalesTP.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrHdrCndnScalesTP.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _CntrlPurContrHdrCndnScalesTP.ConditionSequentialNumber = $projection.ConditionSequentialNumber

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRHCNDNAMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Purchase Contract Hdr Condition view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence CCTRHDRCNDTP_D view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract I_CntrlPurContrHdrCndnAmount CentralPurchaseContract Purchasing Doc.
KEY ConditionRecord I_CntrlPurContrHdrCndnAmount ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_CntrlPurContrHdrCndnAmount ConditionValidityEndDate Valid To
KEY ConditionSequentialNumber I_CntrlPurContrHdrCndnAmount ConditionSequentialNumber SequNo of Cond.
ConditionValidityStartDate I_CntrlPurContrHdrCndnAmount ConditionValidityStartDate Valid From
ConditionType I_CntrlPurContrHdrCndnAmount ConditionType Condition type
ConditionTextID I_CntrlPurContrHdrCndnAmount ConditionTextID Text number
ConditionCalculationType I_CntrlPurContrHdrCndnAmount ConditionCalculationType Calculat.Type
ConditionRateValue I_CntrlPurContrHdrCndnAmount ConditionRateValue Condition Rate Value
ConditionRateValueUnit I_CntrlPurContrHdrCndnAmount ConditionRateValueUnit Unit of Condition Rate Value
ConditionRateRatioUnit I_CntrlPurContrHdrCndnAmount ConditionRateRatioUnit Unit of Measure
ConditionRateRatio I_CntrlPurContrHdrCndnAmount ConditionRateRatio Ratio
ConditionCurrency I_CntrlPurContrHdrCndnAmount ConditionCurrency Currency
ConditionRateAmount I_CntrlPurContrHdrCndnAmount ConditionRateAmount Condition Amount
ConditionQuantity I_CntrlPurContrHdrCndnAmount ConditionQuantity Pricing Unit
ConditionQuantityUnit I_CntrlPurContrHdrCndnAmount ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr I_CntrlPurContrHdrCndnAmount ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr I_CntrlPurContrHdrCndnAmount ConditionToBaseQtyDnmntr Denominator
BaseUnit I_CntrlPurContrHdrCndnAmount BaseUnit Unit of Measure
ConditionLowerLimit I_CntrlPurContrHdrCndnAmount ConditionLowerLimit Lower limit
ConditionUpperLimit I_CntrlPurContrHdrCndnAmount ConditionUpperLimit Upper limit
ConditionAlternativeCurrency I_CntrlPurContrHdrCndnAmount ConditionAlternativeCurrency Cndn Currency
ConditionExclusion I_CntrlPurContrHdrCndnAmount ConditionExclusion Exclusion
ConditionIsDeleted I_CntrlPurContrHdrCndnAmount ConditionIsDeleted Deletion Indic.
AdditionalValueDays I_CntrlPurContrHdrCndnAmount AdditionalValueDays Add. Value Days
FixedValueDate I_CntrlPurContrHdrCndnAmount FixedValueDate Fixed Val. Date
PaymentTerms I_CntrlPurContrHdrCndnAmount PaymentTerms Pyt Terms
CndnMaxNumberOfSalesOrders I_CntrlPurContrHdrCndnAmount CndnMaxNumberOfSalesOrders NumberOfOrders
MinimumConditionBasisValue I_CntrlPurContrHdrCndnAmount MinimumConditionBasisValue MinCondBaseVal.
MaximumConditionBasisValue I_CntrlPurContrHdrCndnAmount MaximumConditionBasisValue MaxCondBaseVal.
MaximumConditionAmount I_CntrlPurContrHdrCndnAmount MaximumConditionAmount MaxConditValue
ConditionReleaseStatus I_CntrlPurContrHdrCndnAmount ConditionReleaseStatus Release Status
ConditionChangeReason I_CntrlPurContrHdrCndnAmount ConditionChangeReason Cndn Change Reason
CmmdtyPricingEngineIsEnabled I_CntrlPurContrHdrCndnAmount CmmdtyPricingEngineIsEnabled Enabled for CPE
PricingScaleType I_CntrlPurContrHdrCndnAmount PricingScaleType Scale Type
PricingScaleBasis I_CntrlPurContrHdrCndnAmount PricingScaleBasis Scale Basis
PricingScaleLine I_CntrlPurContrHdrCndnAmount PricingScaleLine Pricing scale
ConditionScaleQuantity I_CntrlPurContrHdrCndnAmount ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit I_CntrlPurContrHdrCndnAmount ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount I_CntrlPurContrHdrCndnAmount ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency I_CntrlPurContrHdrCndnAmount ConditionScaleAmountCurrency Scale Currency
ConditionHasScales I_CntrlPurContrHdrCndnAmount ConditionHasScales Scales
PricingScaleCheckingRule I_CntrlPurContrHdrCndnAmount PricingScaleCheckingRule Check Scale
_CntrlPurContrHdrCndnValdtyTP _CntrlPurContrHdrCndnValdtyTP
_DocumentCurrency _DocumentCurrency
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CntrlPurContrHdrCndnScalesTP _CntrlPurContrHdrCndnScalesTP

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 I_CntrlPurContrHdrCndnAmountTP.
-- 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: ICCTRHCNDNAMTTP

CREATE VIEW I_CntrlPurContrHdrCndnAmountTP AS
SELECT
  CntrlPurContrHdrCondition.CentralPurchaseContract AS CentralPurchaseContract,
  CntrlPurContrHdrCondition.ConditionRecord AS ConditionRecord,
  CntrlPurContrHdrCondition.ConditionValidityEndDate AS ConditionValidityEndDate,
  CntrlPurContrHdrCondition.ConditionSequentialNumber AS ConditionSequentialNumber,
  CntrlPurContrHdrCondition.ConditionValidityStartDate AS ConditionValidityStartDate,
  CntrlPurContrHdrCondition.ConditionType AS ConditionType,
  CntrlPurContrHdrCondition.ConditionTextID AS ConditionTextID,
  CntrlPurContrHdrCondition.ConditionCalculationType AS ConditionCalculationType,
  CntrlPurContrHdrCondition.ConditionRateValue AS ConditionRateValue,
  CntrlPurContrHdrCondition.ConditionRateValueUnit AS ConditionRateValueUnit,
  CntrlPurContrHdrCondition.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  CntrlPurContrHdrCondition.ConditionRateRatio AS ConditionRateRatio,
  CntrlPurContrHdrCondition.ConditionCurrency AS ConditionCurrency,
  CntrlPurContrHdrCondition.ConditionRateAmount AS ConditionRateAmount,
  CntrlPurContrHdrCondition.ConditionQuantity AS ConditionQuantity,
  CntrlPurContrHdrCondition.ConditionQuantityUnit AS ConditionQuantityUnit,
  CntrlPurContrHdrCondition.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  CntrlPurContrHdrCondition.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  CntrlPurContrHdrCondition.BaseUnit AS BaseUnit,
  CntrlPurContrHdrCondition.ConditionLowerLimit AS ConditionLowerLimit,
  CntrlPurContrHdrCondition.ConditionUpperLimit AS ConditionUpperLimit,
  CntrlPurContrHdrCondition.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  CntrlPurContrHdrCondition.ConditionExclusion AS ConditionExclusion,
  CntrlPurContrHdrCondition.ConditionIsDeleted AS ConditionIsDeleted,
  CntrlPurContrHdrCondition.AdditionalValueDays AS AdditionalValueDays,
  CntrlPurContrHdrCondition.FixedValueDate AS FixedValueDate,
  CntrlPurContrHdrCondition.PaymentTerms AS PaymentTerms,
  CntrlPurContrHdrCondition.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  CntrlPurContrHdrCondition.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  CntrlPurContrHdrCondition.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  CntrlPurContrHdrCondition.MaximumConditionAmount AS MaximumConditionAmount,
  CntrlPurContrHdrCondition.ConditionReleaseStatus AS ConditionReleaseStatus,
  CntrlPurContrHdrCondition.ConditionChangeReason AS ConditionChangeReason,
  CntrlPurContrHdrCondition.CmmdtyPricingEngineIsEnabled AS CmmdtyPricingEngineIsEnabled,
  CntrlPurContrHdrCondition.PricingScaleType AS PricingScaleType,
  CntrlPurContrHdrCondition.PricingScaleBasis AS PricingScaleBasis,
  CntrlPurContrHdrCondition.PricingScaleLine AS PricingScaleLine,
  CntrlPurContrHdrCondition.ConditionScaleQuantity AS ConditionScaleQuantity,
  CntrlPurContrHdrCondition.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  CntrlPurContrHdrCondition.ConditionScaleAmount AS ConditionScaleAmount,
  CntrlPurContrHdrCondition.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  CntrlPurContrHdrCondition.ConditionHasScales AS ConditionHasScales,
  CntrlPurContrHdrCondition.PricingScaleCheckingRule AS PricingScaleCheckingRule
FROM I_CntrlPurContrHdrCndnAmount AS CntrlPurContrHdrCondition
LEFT OUTER JOIN I_CntrlPurContrHdrCndnValdtyTP AS _CntrlPurContrHdrCndnValdtyTP ON CentralPurchaseContract = _CntrlPurContrHdrCndnValdtyTP.CentralPurchaseContract AND ConditionRecord = _CntrlPurContrHdrCndnValdtyTP.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrHdrCndnValdtyTP.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON ConditionCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrHdrCndnScalesTP AS _CntrlPurContrHdrCndnScalesTP ON _CntrlPurContrHdrCndnScalesTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrCndnScalesTP.ConditionRecord = ConditionRecord AND _CntrlPurContrHdrCndnScalesTP.ConditionValidityEndDate = ConditionValidityEndDate AND _CntrlPurContrHdrCndnScalesTP.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
;

Learn More