R_PrcgCndnExerTermQuotationTP

DDL: R_PRCGCNDNEXERTERMQUOTATIONTP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 1 Associations

CPE Condition Exer Term Quotation - TP

R_PrcgCndnExerTermQuotationTP is a Transactional CDS View that provides data about "CPE Condition Exer Term Quotation - TP" in SAP S/4HANA. It reads from 1 data source (I_PricingCndnExerTermQuotation) and exposes 25 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgCndnTermQuotationDateTime. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PricingCndnExerTermQuotation I_PricingCndnExerTermQuotation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_CmmdtyPrcgConditionFormulaTP _CmmdtyPrcgConditionFormulaTP $projection.DocItmCmmdtyPrcgCndnUUID = _CmmdtyPrcgConditionFormulaTP.DocItmCmmdtyPrcgCndnUUID

Annotations (8)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CPE Condition Exer Term Quotation - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CmmdtyPrcgCndnExerTrmQuotation view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm PricingConditionTerm Term Number
KEY PrcgCndnTermQuotationDateTime PrcgCndnTermQuotationDateTime Quotation Time Stamp
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit Quotation UoM
PrcgCndnTermQuotationStatus PrcgCndnTermQuotationStatus
PrcgCndnTrmQtanInTrmCrcyRate PrcgCndnTrmQtanInTrmCrcyRate
ConditionTermRateCurrency ConditionTermRateCurrency
ConditionTermRateQuantity ConditionTermRateQuantity
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit
PricingConditionExchangeRate PricingConditionExchangeRate Conv.:Ex.Rate
MaturityKeyDate MaturityKeyDate Maturity Key Date
PrcgCndnTrmQtanSubstnDateTime PrcgCndnTrmQtanSubstnDateTime Subst Time Stamp
PrcgCndnTrmQtanIsNonTradingDay PrcgCndnTrmQtanIsNonTradingDay Non-Trading Day
PrcgCndnTermQuotationIsMissing PrcgCndnTermQuotationIsMissing Quotation Missing
PrcgCndnTrmQtanIsSubstituted PrcgCndnTrmQtanIsSubstituted Substitute Qtn
PrcgCndnTrmQuotationIsIgnored PrcgCndnTrmQuotationIsIgnored Quotation Ignored
CommodityCurveReadingDate CommodityCurveReadingDate
PrcgCndnTermQtanRoundedRate PrcgCndnTermQtanRoundedRate
PrcgCndnTrmQtanDelivStartDate PrcgCndnTrmQtanDelivStartDate
PrcgCndnTrmQtanDeliveryEndDate PrcgCndnTrmQtanDeliveryEndDate
_CmmdtyPrcgCndnExerTermTP _CmmdtyPrcgCndnExerTermTP
_CmmdtyPrcgConditionFormulaTP _CmmdtyPrcgConditionFormulaTP

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_PrcgCndnExerTermQuotationTP.
-- 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_PrcgCndnExerTermQuotationTP AS
SELECT
  DocItmCmmdtyPrcgCndnUUID,
  PricingConditionTerm,
  PrcgCndnTermQuotationDateTime,
  PrcgConditionTermQuotationRate,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  PrcgCndnTermQuotationStatus,
  PrcgCndnTrmQtanInTrmCrcyRate,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  PricingConditionExchangeRate,
  MaturityKeyDate,
  PrcgCndnTrmQtanSubstnDateTime,
  PrcgCndnTrmQtanIsNonTradingDay,
  PrcgCndnTermQuotationIsMissing,
  PrcgCndnTrmQtanIsSubstituted,
  PrcgCndnTrmQuotationIsIgnored,
  CommodityCurveReadingDate,
  PrcgCndnTermQtanRoundedRate,
  PrcgCndnTrmQtanDelivStartDate,
  PrcgCndnTrmQtanDeliveryEndDate
FROM I_PricingCndnExerTermQuotation
LEFT OUTER JOIN R_CmmdtyPrcgConditionFormulaTP AS _CmmdtyPrcgConditionFormulaTP ON DocItmCmmdtyPrcgCndnUUID = _CmmdtyPrcgConditionFormulaTP.DocItmCmmdtyPrcgCndnUUID  -- association [1..1]
;

Learn More