R_SubscrpnContrItmPrElmntTP

DDL: R_SUBSCRPNCONTRITMPRELMNTTP Type: view_entity TRANSACTIONAL
36 Fields 2 Data Sources 1 Associations

Contract Item Price Element - TP

R_SubscrpnContrItmPrElmntTP is a Transactional CDS View that provides data about "Contract Item Price Element - TP" in SAP S/4HANA. It reads from 2 data sources (I_PricingElement, I_SubscriptionContract) and exposes 36 fields with key fields SubscriptionContract, SubscriptionContractItem, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PricingElement PricingElement from
I_SubscriptionContract SubscriptionContract inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SubscriptionContractTP _SubscriptionContract $projection.SubscriptionContract = _SubscriptionContract.SubscriptionContract

Annotations (8)

NameValueLevelField
EndUserText.label Contract Item Price Element - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract I_SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem
KEY PricingProcedureStep I_PricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter I_PricingElement PricingProcedureCounter Pricing Procedure Counter
ConditionApplication I_PricingElement ConditionApplication Application
ConditionType I_PricingElement ConditionType Condition type
PricingDocument I_PricingElement PricingDocument Document Condition
ConditionClass I_PricingElement ConditionClass Condition Class
ConditionIsForConfiguration I_PricingElement ConditionIsForConfiguration UsedfVarConfig
ConditionTypeName
ConditionCalculationType I_PricingElement ConditionCalculationType Calculat.Type
PriceConditionDeterminationDte I_PricingElement PriceConditionDeterminationDte Condition Pricing Date
ConditionRateAmount I_PricingElement ConditionRateAmount Condition Amount
ConditionRateRatio I_PricingElement ConditionRateRatio Ratio
ConditionBaseAmount I_PricingElement ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity I_PricingElement ConditionBaseQuantity Quantity
ConditionQuantity I_PricingElement ConditionQuantity Pricing Unit
ConditionAmount I_PricingElement ConditionAmount Condition Value
ConditionCurrency I_PricingElement ConditionCurrency Currency
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit I_PricingElement ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics Statistical
ConditionIsManuallyChanged I_PricingElement ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason I_PricingElement ConditionInactiveReason Inactive
ConditionInactiveReasonName
ConditionCalculationTypeName
_SubscriptionContractItem _SubscriptionContractItem
_SubscriptionContract _SubscriptionContract
_ConditionApplication I_PricingElement _ConditionApplication
_PricingConditionType I_PricingElement _PricingConditionType
_ConditionCurrency I_PricingElement _ConditionCurrency
_TransactionCurrency I_PricingElement _Currency
_ConditionQuantityUnit I_PricingElement _ConditionQuantityUnit
_ConditionInactiveReason I_PricingElement _ConditionInactiveReason
_ConditionCalculationType I_PricingElement _ConditionCalculationType

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_SubscrpnContrItmPrElmntTP.
-- 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_SubscrpnContrItmPrElmntTP AS
SELECT
  SubscriptionContract.SubscriptionContract AS SubscriptionContract,
  cast(PricingElement.PricingDocumentItem as crms4_number_int preserving type) AS SubscriptionContractItem,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  PricingElement.PricingDocument AS PricingDocument,
  PricingElement.ConditionClass AS ConditionClass,
  PricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  PricingElement._PricingConditionType._Text[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  PricingElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  PricingElement.ConditionRateAmount AS ConditionRateAmount,
  PricingElement.ConditionRateRatio AS ConditionRateRatio,
  PricingElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingElement.ConditionBaseQuantity AS ConditionBaseQuantity,
  PricingElement.ConditionQuantity AS ConditionQuantity,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.ConditionCurrency AS ConditionCurrency,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement._ConditionInactiveReason._Text[1: Language=$session.system_language].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  PricingElement._ConditionCalculationType._Text[1: Language=$session.system_language].ConditionCalculationTypeName AS ConditionCalculationTypeName,
  PricingElement._ConditionApplication AS _ConditionApplication,
  PricingElement._PricingConditionType AS _PricingConditionType,
  PricingElement._ConditionCurrency AS _ConditionCurrency,
  PricingElement._Currency AS _TransactionCurrency,
  PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
  PricingElement._ConditionInactiveReason AS _ConditionInactiveReason,
  PricingElement._ConditionCalculationType AS _ConditionCalculationType
FROM I_PricingElement AS PricingElement
INNER JOIN I_SubscriptionContract AS SubscriptionContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SubscriptionContractTP AS _SubscriptionContract ON SubscriptionContract = _SubscriptionContract.SubscriptionContract  -- association [1..1]
;

Learn More