R_PPS_PurContrItmCndnAmountTP

DDL: R_PPS_PURCONTRITMCNDNAMOUNTTP Type: view_entity TRANSACTIONAL
55 Fields 1 Data Sources 6 Associations

Item Condition Amount - TP

R_PPS_PurContrItmCndnAmountTP is a Transactional CDS View that provides data about "Item Condition Amount - TP" in SAP S/4HANA. It reads from 1 data source (I_PurContrItemCndnAmount) and exposes 55 fields with key fields PurchaseContract, PurchaseContractItem, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumberShort. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurContrItemCndnAmount I_PurContrItemCndnAmount from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_PurConditionText _ConditionText $projection.ConditionType = _ConditionText.ConditionType and _ConditionText.ConditionApplication = 'M' and _ConditionText.Language = $session.system_language
[0..1] I_PurgCndnChangeReasonText _PurgCndnChangeReasonText $projection.ConditionChangeReason = _PurgCndnChangeReasonText.ConditionChangeReason and _PurgCndnChangeReasonText.Language = $session.system_language
[0..1] I_CurrencyStdVH _DocumentCurrency $projection.ConditionCurrency = _DocumentCurrency.Currency
[0..1] I_Plant _Plant _Plant.Plant = $projection.Plant
[0..1] I_PricingScaleBasisText _PricingScaleBasisText _PricingScaleBasisText.PricingScaleBasis = $projection.PricingScaleBasisShort and _PricingScaleBasisText.Language = $session.system_language
[0..*] R_PPS_PurContrItmCndnScaleTP _PurContrItmCndnScale

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Item Condition Amount - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ConditionRecord ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate ConditionValidityEndDate Valid To
KEY ConditionSequentialNumberShort ConditionSequentialNumber SequNo of Cond.
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
Plant Plant Valuation Area
ConditionTextID ConditionTextID Text number
ConditionCalculationTypeShort ConditionCalculationType Calculat.Type
ConditionRateValue ConditionRateValue Condition Rate Value
ConditionRateValueUnit ConditionRateValueUnit Unit of Condition Rate Value
ConditionQuantity ConditionQuantity Pricing Unit
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionRateRatio ConditionRateRatio Ratio
ConditionCurrency ConditionCurrency Currency
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
BaseUnit BaseUnit Unit of Measure
ConditionLowerLimit ConditionLowerLimit Lower limit
ConditionUpperLimit ConditionUpperLimit Upper limit
ConditionLowerLimitAmount ConditionLowerLimitAmount Amount
ConditionLowerLimitRatio ConditionLowerLimitRatio Ratio
ConditionUpperLimitAmount ConditionUpperLimitAmount Amount
ConditionUpperLimitRatio ConditionUpperLimitRatio Ratio
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
PricingScaleType PricingScaleType Scale Type
PricingScaleBasisShort PricingScaleBasis Scale Basis
PricingScaleBasisName _PricingScaleBasisText PricingScaleBasisName
PricingScaleLine PricingScaleLine Pricing scale
ConditionHasScales ConditionHasScales Scales
PricingScaleCheckingRule PricingScaleCheckingRule Check Scale
ConditionChangeReason ConditionChangeReason Cndn Change Reason
MinimumConditionBasisValue MinimumConditionBasisValue MinCondBaseVal.
MaximumConditionBasisValue MaximumConditionBasisValue MaxCondBaseVal.
MaximumConditionAmount MaximumConditionAmount MaxConditValue
ConditionReleaseStatus ConditionReleaseStatus Release Status
PurchasingOrganization _PurchaseContract PurchasingOrganization Purchasing Organization
LastChangeDateTime _PurchaseContract LastChangeDateTime Timestamp
ConditionChangeReasonText _PurgCndnChangeReasonText ConditionChangeReasonText Description
_PurchaseContract _PurchaseContract
_PurContrItmCndnScale _PurContrItmCndnScale
_PurContrItmCndnValdty _PurContrItmCndnValdty
_ConditionText _ConditionText
_Plant _Plant
_DocumentCurrency _DocumentCurrency

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 R_PPS_PurContrItmCndnAmountTP.
-- 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.

CREATE VIEW R_PPS_PurContrItmCndnAmountTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionSequentialNumber AS ConditionSequentialNumberShort,
  ConditionValidityStartDate,
  ConditionApplication,
  ConditionType,
  Plant,
  ConditionTextID,
  ConditionCalculationType AS ConditionCalculationTypeShort,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionQuantity,
  ConditionRateRatioUnit,
  ConditionRateRatio,
  ConditionCurrency,
  ConditionRateAmount,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionLowerLimitAmount,
  ConditionLowerLimitRatio,
  ConditionUpperLimitAmount,
  ConditionUpperLimitRatio,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  PricingScaleType,
  PricingScaleBasis AS PricingScaleBasisShort,
  _PricingScaleBasisText.PricingScaleBasisName AS PricingScaleBasisName,
  PricingScaleLine,
  ConditionHasScales,
  PricingScaleCheckingRule,
  ConditionChangeReason,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  _PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract.LastChangeDateTime AS LastChangeDateTime,
  _PurgCndnChangeReasonText.ConditionChangeReasonText AS ConditionChangeReasonText
FROM I_PurContrItemCndnAmount
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON ConditionType = _ConditionText.ConditionType AND _ConditionText.ConditionApplication = 'M' AND _ConditionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgCndnChangeReasonText AS _PurgCndnChangeReasonText ON ConditionChangeReason = _PurgCndnChangeReasonText.ConditionChangeReason AND _PurgCndnChangeReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyStdVH AS _DocumentCurrency ON ConditionCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PricingScaleBasisText AS _PricingScaleBasisText ON _PricingScaleBasisText.PricingScaleBasis = PricingScaleBasisShort AND _PricingScaleBasisText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurContrItmCndnScaleTP AS _PurContrItmCndnScale ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More