C_SubscrpnContrItmPrElmntTP

DDL: C_SUBSCRPNCONTRITMPRELMNTTP Type: view_entity CONSUMPTION
39 Fields 1 Data Sources

Contract Item Price Element - TP

C_SubscrpnContrItmPrElmntTP is a Consumption CDS View that provides data about "Contract Item Price Element - TP" in SAP S/4HANA. It reads from 1 data source (R_SubscrpnContrItmPrElmntTP) and exposes 39 fields with key fields SubscriptionContract, SubscriptionContractItem, PricingProcedureStep, PricingProcedureCounter.

Data Sources (1)

SourceAliasJoin Type
R_SubscrpnContrItmPrElmntTP R_SubscrpnContrItmPrElmntTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Contract Item Price Element - TP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.query.implementedBy ABAP:CL_CRMS4_SOM_CONTR_LC_QUERY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
ConditionTypeName ConditionTypeName Name
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionCalculationTypeName ConditionCalculationTypeName
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionRateRatio ConditionRateRatio Ratio
ConditionBaseAmount ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity ConditionBaseQuantity Quantity
ConditionQuantity ConditionQuantity Pricing Unit
ConditionAmount ConditionAmount Condition Value
ConditionCurrency ConditionCurrency Currency
TransactionCurrency TransactionCurrency Transaction Currency
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics ConditionIsForStatistics Statistical
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason ConditionInactiveReason Inactive
ConditionInactiveReasonName ConditionInactiveReasonName Inactive
ConditionRateValueIsAmount ConditionRateValueIsAmount TRUE
ConditionRateValueIsRatio ConditionRateValueIsRatio TRUE
ConditionBaseValueIsAmount ConditionBaseValueIsAmount
ConditionBaseValueIsQuantity ConditionBaseValueIsQuantity
char1
string
string
string
string
_ConditionApplication _ConditionApplication
_PricingConditionType _PricingConditionType
_ConditionCurrency _ConditionCurrency
_TransactionCurrency _TransactionCurrency
_ConditionQuantityUnit _ConditionQuantityUnit
_ConditionInactiveReason _ConditionInactiveReason
_ConditionCalculationType _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 C_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 C_SubscrpnContrItmPrElmntTP AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  ConditionTypeName,
  ConditionCalculationType,
  ConditionCalculationTypeName,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionQuantity,
  ConditionAmount,
  ConditionCurrency,
  TransactionCurrency,
  ConditionQuantityUnit,
  ConditionRateRatioUnit,
  ConditionIsForStatistics,
  ConditionIsManuallyChanged,
  ConditionInactiveReason,
  ConditionInactiveReasonName,
  ConditionRateValueIsAmount,
  ConditionRateValueIsRatio,
  ConditionBaseValueIsAmount,
  ConditionBaseValueIsQuantity,
  virtual SubscrpnContrPrElmntSts : abap.char(1) AS char1,
  virtual SubscrpnContrPrElmntStsTxt : abap.string AS string
FROM R_SubscrpnContrItmPrElmntTP
;

Learn More