I_PurContrItemCndnAmount

DDL: I_PURCONTRITEMCNDNAMOUNT SQL: IPURCTRCNDITMAMT Type: view COMPOSITE
57 Fields 3 Data Sources 2 Associations

Purchase Ctr Item Condition Amount

I_PurContrItemCndnAmount is a Composite CDS View that provides data about "Purchase Ctr Item Condition Amount" in SAP S/4HANA. It reads from 3 data sources (I_PricingConditionRecord, I_PurContrItemCndnValdty, I_PurgPrcgCndnType) and exposes 57 fields with key fields PurchaseContract, PurchaseContractItem, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_PricingConditionRecord ConditionItem from
I_PurContrItemCndnValdty I_PurContrItemCndnValdty inner
I_PurgPrcgCndnType t685a inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurContrItemCndnValdty _PurContrItemCndnValdty $projection.PurchaseContract = _PurContrItemCndnValdty.PurchaseContract and $projection.PurchaseContractItem = _PurContrItemCndnValdty.PurchaseContractItem and $projection.ConditionRecord = _PurContrItemCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _PurContrItemCndnValdty.ConditionValidityEndDate
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPURCTRCNDITMAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Ctr Item Condition Amount view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurContrItemCndnValdty PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurContrItemCndnValdty PurchaseContractItem Item
KEY ConditionRecord I_PricingConditionRecord ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_PurContrItemCndnValdty ConditionValidityEndDate Valid To
KEY ConditionSequentialNumber I_PricingConditionRecord ConditionSequentialNumber SequNo of Cond.
ConditionValidityStartDate I_PurContrItemCndnValdty ConditionValidityStartDate Valid From
Plant I_PurContrItemCndnValdty Plant Valuation Area
ConditionApplication I_PricingConditionRecord ConditionApplication Application
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
PurContrCndnRateRatioUntISOCd
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
PurContrCndnQtyUnitISOCode
ConditionToBaseQtyNmrtr I_PricingConditionRecord ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr I_PricingConditionRecord ConditionToBaseQtyDnmntr Denominator
BaseUnit I_PricingConditionRecord BaseUnit Unit of Measure
PurContrBaseUnitISOCode
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
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
PurContrCndnScQtyUnitISOCode
ConditionScaleAmount I_PricingConditionRecord ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency I_PricingConditionRecord ConditionScaleAmountCurrency Scale Currency
ConditionLowerLimitAmount I_PricingConditionRecord ConditionLowerLimitAmount Amount
ConditionLowerLimitRatio I_PricingConditionRecord ConditionLowerLimitRatio Ratio
ConditionUpperLimitAmount I_PricingConditionRecord ConditionUpperLimitAmount Amount
ConditionUpperLimitRatio I_PricingConditionRecord ConditionUpperLimitRatio Ratio
ConditionHasScales
ConditionHasUoMConversion
ConditionUnitConversionText
_PurContrItemCndnValdty _PurContrItemCndnValdty
_PurchaseContract _PurchaseContract

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_PurContrItemCndnAmount.
-- 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: IPURCTRCNDITMAMT

CREATE VIEW I_PurContrItemCndnAmount AS
SELECT
  I_PurContrItemCndnValdty.PurchaseContract AS PurchaseContract,
  I_PurContrItemCndnValdty.PurchaseContractItem AS PurchaseContractItem,
  ConditionItem.ConditionRecord AS ConditionRecord,
  I_PurContrItemCndnValdty.ConditionValidityEndDate AS ConditionValidityEndDate,
  ConditionItem.ConditionSequentialNumber AS ConditionSequentialNumber,
  I_PurContrItemCndnValdty.ConditionValidityStartDate AS ConditionValidityStartDate,
  I_PurContrItemCndnValdty.Plant AS Plant,
  ConditionItem.ConditionApplication AS ConditionApplication,
  ConditionItem.ConditionType AS ConditionType,
  ConditionItem.ConditionTextID AS ConditionTextID,
  ConditionItem.ConditionCalculationType AS ConditionCalculationType,
  ConditionItem.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  ConditionItem.ConditionRateRatio AS ConditionRateRatio,
  cast( '' as abap.unit( 3 ) ) AS PurContrCndnRateRatioUntISOCd,
  ConditionItem.ConditionCurrency AS ConditionCurrency,
  ConditionItem.ConditionRateAmount AS ConditionRateAmount,
  ConditionItem.ConditionRateValue AS ConditionRateValue,
  ConditionItem.ConditionRateValueUnit AS ConditionRateValueUnit,
  ConditionItem.ConditionQuantity AS ConditionQuantity,
  ConditionItem.ConditionQuantityUnit AS ConditionQuantityUnit,
  cast( '' as abap.char( 3 ) ) AS PurContrCndnQtyUnitISOCode,
  ConditionItem.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  ConditionItem.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  ConditionItem.BaseUnit AS BaseUnit,
  cast( '' as abap.unit( 3 ) ) AS PurContrBaseUnitISOCode,
  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.PricingScaleCheckingRule AS PricingScaleCheckingRule,
  ConditionItem.PricingScaleType AS PricingScaleType,
  ConditionItem.PricingScaleBasis AS PricingScaleBasis,
  ConditionItem.PricingScaleLine AS PricingScaleLine,
  ConditionItem.ConditionScaleQuantity AS ConditionScaleQuantity,
  ConditionItem.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  cast( '' as konms ) AS PurContrCndnScQtyUnitISOCode,
  ConditionItem.ConditionScaleAmount AS ConditionScaleAmount,
  ConditionItem.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  ConditionItem.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  ConditionItem.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  ConditionItem.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  ConditionItem.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  cast ('' as kostkz) AS ConditionHasScales,
  cast ('' as boole_d) AS ConditionHasUoMConversion,
  cast ('' as text60) AS ConditionUnitConversionText
FROM I_PricingConditionRecord AS ConditionItem
INNER JOIN I_PurgPrcgCndnType AS t685a ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurContrItemCndnValdty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurContrItemCndnValdty AS _PurContrItemCndnValdty ON PurchaseContract = _PurContrItemCndnValdty.PurchaseContract AND PurchaseContractItem = _PurContrItemCndnValdty.PurchaseContractItem AND ConditionRecord = _PurContrItemCndnValdty.ConditionRecord AND ConditionValidityEndDate = _PurContrItemCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More