R_CndnRmndrFltgTermQuotationTP

DDL: R_CNDNRMNDRFLTGTERMQUOTATIONTP Type: view_entity TRANSACTIONAL
24 Fields 1 Data Sources 1 Associations

CPE Cndn Rmndr Fltg Trm Quotation - TP

R_CndnRmndrFltgTermQuotationTP is a Transactional CDS View that provides data about "CPE Cndn Rmndr Fltg Trm Quotation - TP" in SAP S/4HANA. It reads from 1 data source (I_CndnRmndrFltgTermQuotation) and exposes 24 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgCndnTermQuotationDateTime. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CndnRmndrFltgTermQuotation I_CndnRmndrFltgTermQuotation from

Associations (1)

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

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CPE Cndn Rmndr Fltg Trm Quotation - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm PricingConditionTerm Term Number
KEY PrcgCndnTermQuotationDateTime PrcgCndnTermQuotationDateTime Quotation Time Stamp
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
_CmmdtyPrcgCndnRmndrFltgTrmTP _CmmdtyPrcgCndnRmndrFltgTrmTP
_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_CndnRmndrFltgTermQuotationTP.
-- 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_CndnRmndrFltgTermQuotationTP AS
SELECT
  DocItmCmmdtyPrcgCndnUUID,
  PricingConditionTerm,
  PrcgCndnTermQuotationDateTime,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  PrcgCndnTermQuotationStatus,
  PrcgCndnTrmQtanInTrmCrcyRate,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  PricingConditionExchangeRate,
  MaturityKeyDate,
  PrcgCndnTrmQtanSubstnDateTime,
  PrcgCndnTrmQtanIsNonTradingDay,
  PrcgCndnTermQuotationIsMissing,
  PrcgCndnTrmQtanIsSubstituted,
  PrcgCndnTrmQuotationIsIgnored,
  CommodityCurveReadingDate,
  PrcgCndnTermQtanRoundedRate,
  PrcgCndnTrmQtanDelivStartDate,
  PrcgCndnTrmQtanDeliveryEndDate
FROM I_CndnRmndrFltgTermQuotation
LEFT OUTER JOIN R_CmmdtyPrcgConditionFormulaTP AS _CmmdtyPrcgConditionFormulaTP ON DocItmCmmdtyPrcgCndnUUID = _CmmdtyPrcgConditionFormulaTP.DocItmCmmdtyPrcgCndnUUID  -- association [1..1]
;

Learn More