I_CntrlPurContrItmCndnAmount

DDL: I_CNTRLPURCONTRITMCNDNAMOUNT SQL: ICCTRCNDAMT Type: view COMPOSITE
47 Fields 3 Data Sources 2 Associations

Central Purchase Contract Item Condition

I_CntrlPurContrItmCndnAmount is a Composite CDS View that provides data about "Central Purchase Contract Item Condition" in SAP S/4HANA. It reads from 3 data sources (I_PricingConditionRecord, I_CntrlPurContrItmCndnValdty, I_PurgPrcgCndnType) and exposes 47 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_PricingConditionRecord ConditionItem from
I_CntrlPurContrItmCndnValdty I_CntrlPurContrItmCndnValdty inner
I_PurgPrcgCndnType t685a inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty $projection.ConditionRecord = _CntrlPurContrItmCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _CntrlPurContrItmCndnValdty.ConditionValidityEndDate
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRCNDAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Purchase Contract Item Condition view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (47)

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

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

CREATE VIEW I_CntrlPurContrItmCndnAmount AS
SELECT
  I_CntrlPurContrItmCndnValdty.CentralPurchaseContract AS CentralPurchaseContract,
  I_CntrlPurContrItmCndnValdty.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  ConditionItem.ConditionRecord AS ConditionRecord,
  I_CntrlPurContrItmCndnValdty.ConditionValidityEndDate AS ConditionValidityEndDate,
  ConditionItem.ConditionSequentialNumber AS ConditionSequentialNumber,
  I_CntrlPurContrItmCndnValdty.ConditionValidityStartDate AS ConditionValidityStartDate,
  I_CntrlPurContrItmCndnValdty.ProcmtHubPlantUniqueID AS ProcmtHubPlantUniqueID,
  ConditionItem.ConditionType AS ConditionType,
  ConditionItem.ConditionTextID AS ConditionTextID,
  ConditionItem.ConditionCalculationType AS ConditionCalculationType,
  ConditionItem.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  ConditionItem.ConditionRateRatio AS ConditionRateRatio,
  ConditionItem.ConditionCurrency AS ConditionCurrency,
  ConditionItem.ConditionRateAmount AS ConditionRateAmount,
  ConditionItem.ConditionRateValue AS ConditionRateValue,
  ConditionItem.ConditionRateValueUnit AS ConditionRateValueUnit,
  ConditionItem.ConditionQuantity AS ConditionQuantity,
  ConditionItem.ConditionQuantityUnit AS ConditionQuantityUnit,
  ConditionItem.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  ConditionItem.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  ConditionItem.BaseUnit AS BaseUnit,
  ConditionItem.ConditionLowerLimit AS ConditionLowerLimit,
  ConditionItem.ConditionUpperLimit AS ConditionUpperLimit,
  ConditionItem.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  ConditionItem.ConditionExclusion AS ConditionExclusion,
  ConditionItem.ConditionIsDeleted AS ConditionIsDeleted,
  ConditionItem.AdditionalValueDays AS AdditionalValueDays,
  ConditionItem.FixedValueDate AS FixedValueDate,
  ConditionItem.PaymentTerms AS PaymentTerms,
  ConditionItem.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  ConditionItem.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  ConditionItem.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  ConditionItem.MaximumConditionAmount AS MaximumConditionAmount,
  ConditionItem.ConditionReleaseStatus AS ConditionReleaseStatus,
  ConditionItem.ConditionChangeReason AS ConditionChangeReason,
  t685a.CmmdtyPricingEngineIsEnabled AS CmmdtyPricingEngineIsEnabled,
  t685a.PricingScaleCheckingRule AS PricingScaleCheckingRule,
  ConditionItem.PricingScaleType AS PricingScaleType,
  ConditionItem.PricingScaleBasis AS PricingScaleBasis,
  ConditionItem.PricingScaleLine AS PricingScaleLine,
  ConditionItem.ConditionScaleQuantity AS ConditionScaleQuantity,
  ConditionItem.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  ConditionItem.ConditionScaleAmount AS ConditionScaleAmount,
  ConditionItem.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  cast ('' as kostkz) AS ConditionHasScales
FROM I_PricingConditionRecord AS ConditionItem
INNER JOIN I_PurgPrcgCndnType AS t685a ON /* join condition not captured in parsed metadata */
INNER JOIN I_CntrlPurContrItmCndnValdty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CntrlPurContrItmCndnValdty AS _CntrlPurContrItmCndnValdty ON ConditionRecord = _CntrlPurContrItmCndnValdty.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrItmCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
;

Learn More