R_PPS_PurContrHdrCndnAmtTP

DDL: R_PPS_PURCONTRHDRCNDNAMTTP Type: view_entity TRANSACTIONAL
50 Fields 1 Data Sources 3 Associations

TP for Pc Cndn Amt for Hdr Pricing

R_PPS_PurContrHdrCndnAmtTP is a Transactional CDS View that provides data about "TP for Pc Cndn Amt for Hdr Pricing" in SAP S/4HANA. It reads from 1 data source (I_PurContrHdrCndnAmount) and exposes 50 fields with key fields PurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumberShort. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurContrHdrCndnAmount PurContrHdrCondition from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _DocumentCurrency $projection.ConditionCurrency = _DocumentCurrency.Currency
[1..1] R_PPS_PurchaseContractTP _PurchaseContractTP _PurchaseContractTP.PurchaseContract = $projection.PurchaseContract
[0..1] I_PurConditionText _ConditionText $projection.ConditionType = _ConditionText.ConditionType and _ConditionText.ConditionApplication = 'M' and _ConditionText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label TP for Pc Cndn Amt for Hdr Pricing view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (50)

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

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_PurContrHdrCndnAmtTP.
-- 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_PurContrHdrCndnAmtTP AS
SELECT
  PurContrHdrCondition.PurchaseContract AS PurchaseContract,
  PurContrHdrCondition.ConditionRecord AS ConditionRecord,
  PurContrHdrCondition.ConditionValidityEndDate AS ConditionValidityEndDate,
  PurContrHdrCondition.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  PurContrHdrCondition.ConditionValidityStartDate AS ConditionValidityStartDate,
  PurContrHdrCondition.ConditionType AS ConditionType,
  PurContrHdrCondition.ConditionTextID AS ConditionTextID,
  PurContrHdrCondition.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PurContrHdrCondition.ConditionRateRatio AS ConditionRateRatio,
  PurContrHdrCondition.ConditionCurrency AS ConditionCurrency,
  PurContrHdrCondition.ConditionRateAmount AS ConditionRateAmount,
  PurContrHdrCondition.ConditionRateValue AS ConditionRateValue,
  PurContrHdrCondition.ConditionRateValueUnit AS ConditionRateValueUnit,
  PurContrHdrCondition.ConditionQuantityUnit AS ConditionQuantityUnit,
  PurContrHdrCondition.ConditionQuantity AS ConditionQuantity,
  PurContrHdrCondition.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  PurContrHdrCondition.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  PurContrHdrCondition.BaseUnit AS BaseUnit,
  PurContrHdrCondition.ConditionLowerLimit AS ConditionLowerLimit,
  PurContrHdrCondition.ConditionUpperLimit AS ConditionUpperLimit,
  PurContrHdrCondition.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  PurContrHdrCondition.ConditionExclusion AS ConditionExclusion,
  PurContrHdrCondition.ConditionIsDeleted AS ConditionIsDeleted,
  PurContrHdrCondition.AdditionalValueDays AS AdditionalValueDays,
  PurContrHdrCondition.FixedValueDate AS FixedValueDate,
  PurContrHdrCondition.PaymentTerms AS PaymentTerms,
  PurContrHdrCondition.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  PurContrHdrCondition.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  PurContrHdrCondition.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  PurContrHdrCondition.MaximumConditionAmount AS MaximumConditionAmount,
  PurContrHdrCondition.ConditionReleaseStatus AS ConditionReleaseStatus,
  PurContrHdrCondition.ConditionChangeReason AS ConditionChangeReason,
  PurContrHdrCondition.CmmdtyPricingEngineIsEnabled AS CmmdtyPricingEngineIsEnabled,
  _ConditionText.ConditionText AS ConditionText,
  PurContrHdrCondition.PricingScaleType AS PricingScaleType,
  PurContrHdrCondition.PricingScaleLine AS PricingScaleLine,
  PurContrHdrCondition.ConditionScaleQuantity AS ConditionScaleQuantity,
  PurContrHdrCondition.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  PurContrHdrCondition.ConditionScaleAmount AS ConditionScaleAmount,
  PurContrHdrCondition.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  PurContrHdrCondition.ConditionHasScales AS ConditionHasScales,
  PurContrHdrCondition.PricingScaleCheckingRule AS PricingScaleCheckingRule,
  PurContrHdrCondition.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  PurContrHdrCondition.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  PurContrHdrCondition.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  PurContrHdrCondition.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  _PurchaseContractTP.LastChangeDateTime AS LastChangeDateTime
FROM I_PurContrHdrCndnAmount AS PurContrHdrCondition
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON ConditionCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurchaseContractTP AS _PurchaseContractTP ON _PurchaseContractTP.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON ConditionType = _ConditionText.ConditionType AND _ConditionText.ConditionApplication = 'M' AND _ConditionText.Language = $session.system_language  -- association [0..1]
;

Learn More