R_CmmdtyPrcgCndnRootTermTP

DDL: R_CMMDTYPRCGCNDNROOTTERMTP Type: view_entity TRANSACTIONAL Package: LOG_CMM_PRC_FORMULA_RAP
200 Fields 1 Data Sources 10 Associations

CPE Condition - Root Term

R_CmmdtyPrcgCndnRootTermTP is a Transactional CDS View that provides data about "CPE Condition - Root Term" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyPrcgConditionRootTerm) and exposes 200 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm. It has 10 associations to related views. Part of development package LOG_CMM_PRC_FORMULA_RAP.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyPrcgConditionRootTerm I_CmmdtyPrcgConditionRootTerm from

Associations (10)

CardinalityTargetAliasCondition
[0..1] E_CmmdtyPricingConditionTerm _ConditionTermExtension $projection.DocItmCmmdtyPrcgCndnUUID = _ConditionTermExtension.DocItmCmmdtyPrcgCndnUUID and $projection.PricingConditionTerm = _ConditionTermExtension.PricingConditionTerm
[*] R_PrcgCndnRootTermQuotationTP _CmmdtyPrcgCndnRootTrmQtanTP
[*] R_CmmdtyPrcgCndnExerTermTP _CmmdtyPrcgCndnExerTermTP
[*] R_CmmdtyPrcgCndnRootTermLogTP _CmmdtyPrcgCndnRootTermLogTP
[*] R_PrcgCndnQuotationGroupItemTP _PrcgCndnQuotationGroupItemTP
[*] R_PrcgCndnRootTrmCnvrsnInputTP _PrcgCndnRootTrmCnvrsnInputTP
[*] R_PrcgCndnRootTrmCnvrsnRsltTP _PrcgCndnRootTrmCnvrsnRsltTP
[*] R_PrcgCndnRootTrmRndngInputTP _PrcgCndnRootTrmRndngInputTP
[0..1] R_CmmdtyPrcgCndnRmndrTermTP _CmmdtyPrcgCndnRmndrTermTP
[0..1] R_CmmdtyPrcgCndnRmndrFltgTrmTP _CmmdtyPrcgCndnRmndrFltgTrmTP

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CmmdtyPricingConditionRootTerm view

Fields (200)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm PricingConditionTerm Term Number
PrcgCndnTrmQtnPerdDetnRoutine PrcgCndnTrmQtnPerdDetnRoutine
PrcgCndnTrmQtnSrceRoutine PrcgCndnTrmQtnSrceRoutine
TrmQtnPerdDetnRefDateRoutine TrmQtnPerdDetnRefDateRoutine
TrmQtnPerdDetnDteOffsetRoutine TrmQtnPerdDetnDteOffsetRoutine
TrmQtnNrOfTmeUnitsForDteOffset TrmQtnNrOfTmeUnitsForDteOffset
TrmQtnPerdDetnTimeUnitRoutine TrmQtnPerdDetnTimeUnitRoutine
TrmQtnNrOfBfrBaseDateTmeUnits TrmQtnNrOfBfrBaseDateTmeUnits
TrmQtnNrOfAftBaseDateTmeUnits TrmQtnNrOfAftBaseDateTmeUnits
CndnTrmQtnBaseDateIsExcluded CndnTrmQtnBaseDateIsExcluded
PrcgCndnTrmQtnFxdPeriodStrtDte PrcgCndnTrmQtnFxdPeriodStrtDte
PrcgCndnTrmQtnFxdPeriodStrtTme PrcgCndnTrmQtnFxdPeriodStrtTme
PrcgCndnTrmQtnFxdPeriodEndDate PrcgCndnTrmQtnFxdPeriodEndDate
PrcgCndnTrmQtnFxdPeriodEndTime PrcgCndnTrmQtnFxdPeriodEndTime
TrmQtnPerdDetnDateListRoutine TrmQtnPerdDetnDateListRoutine
PrcgCndnTrmQtnPerdDetnCalender PrcgCndnTrmQtnPerdDetnCalender
TrmQtnPerdDetnMisgEntrRoutine TrmQtnPerdDetnMisgEntrRoutine
TrmQtnClosedMarketDaysRoutine TrmQtnClosedMarketDaysRoutine
TrmQtnMaxElementWeightingValue TrmQtnMaxElementWeightingValue
PrcgCndnTrmCrcyPerdDetnRoutine PrcgCndnTrmCrcyPerdDetnRoutine
PrcgCndnTrmExchRateSrceRoutine PrcgCndnTrmExchRateSrceRoutine
TrmCrcyPerdDetnRefDateRoutine TrmCrcyPerdDetnRefDateRoutine
TrmCrcyPerdDetnDteOffstRoutine TrmCrcyPerdDetnDteOffstRoutine
TrmExchRatesNrOfUnitsDteOffst TrmExchRatesNrOfUnitsDteOffst
TrmCrcyPerdDetnTimeUnitRoutine TrmCrcyPerdDetnTimeUnitRoutine
ExchRateNrOfBfrBaseDteTmeUnits ExchRateNrOfBfrBaseDteTmeUnits
ExchRateNrOfAftBaseDteTmeUnits ExchRateNrOfAftBaseDteTmeUnits
CndnTrmExchRatesBaseDteIsExcld CndnTrmExchRatesBaseDteIsExcld
CndnTrmExchRatesFxdPerdStrtDte CndnTrmExchRatesFxdPerdStrtDte
CndnTrmExchRatesFxdPerdStrtTme CndnTrmExchRatesFxdPerdStrtTme
CndnTrmExchRatesFxdPerdEndDate CndnTrmExchRatesFxdPerdEndDate
CndnTrmExchRatesFxdPerdEndTime CndnTrmExchRatesFxdPerdEndTime
TrmCrcyPerdDetnDateListRoutine TrmCrcyPerdDetnDateListRoutine
PrcgCndnTrmCrcyPerdDetnCal PrcgCndnTrmCrcyPerdDetnCal
TrmCrcyPerdDetnMisgEntrRoutine TrmCrcyPerdDetnMisgEntrRoutine
TrmExchRatesClsdMktDaysRoutine TrmExchRatesClsdMktDaysRoutine
TrmExchRatesMaxElmntWgtngValue TrmExchRatesMaxElmntWgtngValue
CndnTrmQtnPerdDetnIsIncomplete CndnTrmQtnPerdDetnIsIncomplete
PrcgCndnTrmQtnPerdDetnStatus PrcgCndnTrmQtnPerdDetnStatus
CndnTrmQtnPerdDetnStartDteTime CndnTrmQtnPerdDetnStartDteTime
CndnTrmQtnPerdDetnEndDateTime CndnTrmQtnPerdDetnEndDateTime
TrmQtnFoundLastEntryDateTme TrmQtnFoundLastEntryDateTme
TrmQtnPerdDetnCalcdRefDate TrmQtnPerdDetnCalcdRefDate
TrmQtnPerdDetnCalcdBaseDteTme TrmQtnPerdDetnCalcdBaseDteTme
TrmQtnPerdDetnCalcdRefDateTime TrmQtnPerdDetnCalcdRefDateTime
CndnTrmCrcyPerdDetnIsIncmplt CndnTrmCrcyPerdDetnIsIncmplt
PrcgCndnTrmCrcyPerdDetnStatus PrcgCndnTrmCrcyPerdDetnStatus
CndnTrmCrcyPerdDetnStartDteTme CndnTrmCrcyPerdDetnStartDteTme
CndnTrmCrcyPerdDetnEndDateTime CndnTrmCrcyPerdDetnEndDateTime
TrmExchRatesFndnLastEntrDteTme TrmExchRatesFndnLastEntrDteTme
TrmCrcyPerdDetnCalcdRefDate TrmCrcyPerdDetnCalcdRefDate
TrmCrcyPerdDetnCalcdBaseDteTme TrmCrcyPerdDetnCalcdBaseDteTme
TrmCrcyPerdDetnCalcdRefDteTime TrmCrcyPerdDetnCalcdRefDteTime
PrcgCndnTrmPrFixationOptnUUID PrcgCndnTrmPrFixationOptnUUID
PricingConditionTermTierUUID PricingConditionTermTierUUID
CalcdPrcgConditionTermQuantity CalcdPrcgConditionTermQuantity
CalcdPrcgCndnTermQuantityUnit CalcdPrcgCndnTermQuantityUnit
ConditionTermStatus ConditionTermStatus
BillingBlockingReason BillingBlockingReason
ConditionTermRateCurrency ConditionTermRateCurrency
ConditionTermRateQuantity ConditionTermRateQuantity
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit
PrcgCndnUsedEvalKeyDateTime PrcgCndnUsedEvalKeyDateTime
PrcgCndnCommodityCurveDate PrcgCndnCommodityCurveDate
ConditionTermRate ConditionTermRate
ConditionTermValue ConditionTermValue
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit Quotation UoM
PrcgCndnTrmUsedLimitOfCalcRule PrcgCndnTrmUsedLimitOfCalcRule
PrcgCndnQtnHasQtyUoMSubstn PrcgCndnQtnHasQtyUoMSubstn
PrcgConditionTermSurchargeRate PrcgConditionTermSurchargeRate Total Surcharge
PrcgCndnTrmSurchargeRteCrcy PrcgCndnTrmSurchargeRteCrcy AbsSurchCurr
PrcgCndnTrmSurchargeRteQty PrcgCndnTrmSurchargeRteQty AbsSurch PU
PrcgCndnTrmSurchargeRteQtyUnit PrcgCndnTrmSurchargeRteQtyUnit AbsSurchUoM
PrcgCndnSurchrgHasQtyUoMSubstn PrcgCndnSurchrgHasQtyUoMSubstn
PricingCndnTermExtensionGroup PricingCndnTermExtensionGroup
PrcgCndnBsIdnIsMnllySelected PrcgCndnBsIdnIsMnllySelected
BasisID BasisID Basis ID
CmmdtyPrcgFutureConditionType CmmdtyPrcgFutureConditionType
CmmdtyPrcgFutureTerm CmmdtyPrcgFutureTerm
CmmdtyPricingFlatGroupDateTime CmmdtyPricingFlatGroupDateTime
PrcgCndnTermRelForFormulaRslt PrcgCndnTermRelForFormulaRslt
DerivativeContractSpecCategory DerivativeContractSpecCategory
MaturityKeyDate MaturityKeyDate Maturity Key Date
PricingConditionTermKey PricingConditionTermKey Term Key
PricingConditionTermGroup PricingConditionTermGroup Term Group
PrcgCndnTermIsUsedForPrvsnPrcg PrcgCndnTermIsUsedForPrvsnPrcg
PrcgConditionProvisionalTerm PrcgConditionProvisionalTerm
PrcgConditionTermFirstFactor PrcgConditionTermFirstFactor
PrcgConditionTermSecondFactor PrcgConditionTermSecondFactor
PrcgCndnTermPercentageFactor PrcgCndnTermPercentageFactor
PricingConditionTermQuantity PricingConditionTermQuantity
PricingConditionTrmQtyUnit PricingConditionTrmQtyUnit
PrcgCndnTermCalculationType PrcgCndnTermCalculationType Calculation Type
PricingConditionTermRule PricingConditionTermRule Term Rule
PrcgCndnTrmOrignDocCategory PrcgCndnTrmOrignDocCategory
PrcgCndnTermOriginDocument PrcgCndnTermOriginDocument
PrcgCndnTermOriginDocumentItem PrcgCndnTermOriginDocumentItem
PrcgCndnTrmOrignDocItemUUID PrcgCndnTrmOrignDocItemUUID
PrcgCndnTrmOriginConditionType PrcgCndnTrmOriginConditionType
PrcgConditionTermFixedRateCrcy PrcgConditionTermFixedRateCrcy Currency Fixed Rate
PrcgConditionTermFixedRateQty PrcgConditionTermFixedRateQty PrcUnit Fixed Value
PrcgCndnTermFixedRateQtyUnit PrcgCndnTermFixedRateQtyUnit UoM for Fixed Value
PrcgCndnTermFreeDefinedValue PrcgCndnTermFreeDefinedValue
PrcgCndnTermFreeDefinedQtyUoM PrcgCndnTermFreeDefinedQtyUoM
PricingConditionQuotationKey PricingConditionQuotationKey Quot. Key Type
DerivativeContrSpecification DerivativeContrSpecification DCS ID
MarketIdentifierCode MarketIdentifierCode MIC
TimeToMaturity TimeToMaturity Time to Maturity
PriceQuotationType PriceQuotationType Price Type
CommodityCurveType CommodityCurveType
AltvDrvtvContractSpecification AltvDrvtvContractSpecification
AltvMarketIdentifierCode AltvMarketIdentifierCode
MaturitySelectionType MaturitySelectionType
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming
TrmMaturitySelRefDateRoutine TrmMaturitySelRefDateRoutine
PrcgCndnTrmMaturitySelRoutine PrcgCndnTrmMaturitySelRoutine
CndnTrmPerdDetnDteOffstRoutine CndnTrmPerdDetnDteOffstRoutine
DteOffsetRoutineTimeUnitAmount DteOffsetRoutineTimeUnitAmount
DCSPeriodType DCSPeriodType
BasisType BasisType Basis Type
PricingCndnTermQuotationGroup PricingCndnTermQuotationGroup
PrcgCndnTermQuotationRule PrcgCndnTermQuotationRule Quotation Rule
PrcgCndnTermCalculationRule PrcgCndnTermCalculationRule Calculation Rule
PrcgConditionTermSurchargeRule PrcgConditionTermSurchargeRule
PrcgCndnTrmQtnPerdDetnRule PrcgCndnTrmQtnPerdDetnRule
PrcgCndnTrmCrcyPerdDetnRule PrcgCndnTrmCrcyPerdDetnRule
PrcgCndnTrmPrFixationOptnRule PrcgCndnTrmPrFixationOptnRule
PrcgCndnTermCalculationRoutine PrcgCndnTermCalculationRoutine
PrcgCndnTrmCalcLmtRateCurrency PrcgCndnTrmCalcLmtRateCurrency
PrcgCndnTrmCalcLmtRateQuantity PrcgCndnTrmCalcLmtRateQuantity
PrcgCndnTrmCalcLmtRateQtyUnit PrcgCndnTrmCalcLmtRateQtyUnit
PrcgCndnTermSurchargeRoutine PrcgCndnTermSurchargeRoutine
PrcgCndnTrmAbsltSurchrgAmount PrcgCndnTrmAbsltSurchrgAmount
PrcgCndnTermAbsltSurchrgCrcy PrcgCndnTermAbsltSurchrgCrcy
PrcgCndnTrmAbsltSurchrgPrQty PrcgCndnTrmAbsltSurchrgPrQty
PrcgCndnTrmAbsltSurchrgQtyUnit PrcgCndnTrmAbsltSurchrgQtyUnit
PrcgCndnTrmSurchrgFirstFactor PrcgCndnTrmSurchrgFirstFactor
PrcgCndnTrmSurchrgSecondFactor PrcgCndnTrmSurchrgSecondFactor
PrcgConditionTermDescription PrcgConditionTermDescription
PrcgCndnLtstEvalKeyDateRoutine PrcgCndnLtstEvalKeyDateRoutine
PrcgCndnTermMinCmmdtyCalcRate PrcgCndnTermMinCmmdtyCalcRate
PrcgCndnTermMaxCmmdtyCalcRate PrcgCndnTermMaxCmmdtyCalcRate
PricingConditionTermFixedRate PricingConditionTermFixedRate Fixed Rate
PrcgCndnTrmRateCrtnDateTime PrcgCndnTrmRateCrtnDateTime
PrcgCndnTermRateCreatedByUser PrcgCndnTermRateCreatedByUser
PrcgCndnTrmRateChangeDateTime PrcgCndnTrmRateChangeDateTime
PrcgCndnTermRateChangedByUser PrcgCndnTermRateChangedByUser
CndnDrvtvOrdReqLeewayPrice CndnDrvtvOrdReqLeewayPrice
CndnDrvtvOrdReqLeewayPrcCrcy CndnDrvtvOrdReqLeewayPrcCrcy
TrmOptnErlstExerDateRoutine TrmOptnErlstExerDateRoutine
TrmFixationOptnErlstExerDate TrmFixationOptnErlstExerDate
TrmOptnErlstExerRefDteRoutine TrmOptnErlstExerRefDteRoutine
TrmOptnLtstExerciseDateRoutine TrmOptnLtstExerciseDateRoutine
TrmFixationOptnLtstExerDate TrmFixationOptnLtstExerDate
TrmOptnLtstExerRefDteRoutine TrmOptnLtstExerRefDteRoutine
PrcgCndnTermQtyDistrRoutine PrcgCndnTermQtyDistrRoutine
TermFixationOptionFixationQty TermFixationOptionFixationQty
TrmFixationOptnFixationQtyUnit TrmFixationOptnFixationQtyUnit
CndnTrmFixationOptnLmtRoutine CndnTrmFixationOptnLmtRoutine
CndnTermFixationOptionLimitQty CndnTermFixationOptionLimitQty
TrmFixationOptionLimitQtyUnit TrmFixationOptionLimitQtyUnit
TrmFixationOptnLmtFirstFactor TrmFixationOptnLmtFirstFactor
TrmFixationOptnLmtSecondFactor TrmFixationOptnLmtSecondFactor
CndnTrmNonFixedQtyRefPrRoutine CndnTrmNonFixedQtyRefPrRoutine
CndnTrmTierDefRefDteRoutine CndnTrmTierDefRefDteRoutine
PrcgCndnTermFixationOptnStatus PrcgCndnTermFixationOptnStatus
CndnTrmFixationOptnNonFixedQty CndnTrmFixationOptnNonFixedQty
TrmFixationOptnNonFixedQtyUnit TrmFixationOptnNonFixedQtyUnit
CndnTrmFixationOptnRsltLmtQty CndnTrmFixationOptnRsltLmtQty
TrmFixationOptnRsltLmtQtyUnit TrmFixationOptnRsltLmtQtyUnit
CndnTrmFixationOptnComment CndnTrmFixationOptnComment
PricingConditionTermTier PricingConditionTermTier
PrcgConditionTermTierStartDate PrcgConditionTermTierStartDate
PrcgConditionTermTierEndDate PrcgConditionTermTierEndDate
PrcgConditionTermTierUpperQty PrcgConditionTermTierUpperQty
PrcgConditionTermTierQtyUnit PrcgConditionTermTierQtyUnit
CmmdtyPrcgCndnTrmMttyRefDate CmmdtyPrcgCndnTrmMttyRefDate
PrcgCndnTrmMttyCalcdBaseDate PrcgCndnTrmMttyCalcdBaseDate
BasisInputHashIdentifier BasisInputHashIdentifier
PrcgCndnTrmQtnCurrencyRate PrcgCndnTrmQtnCurrencyRate
CmPrcgPrcFixationSetCompUUID CmPrcgPrcFixationSetCompUUID
PrcgCndnTrmActualQtanCurrency PrcgCndnTrmActualQtanCurrency
PrcgCndnTermHasPriceFixation PrcgCndnTermHasPriceFixation
PrcgCndnTrmQtanGroupCurrency PrcgCndnTrmQtanGroupCurrency
PrcgCndnTrmQtanGrpRateQuantity PrcgCndnTrmQtanGrpRateQuantity
PrcgCndnTrmQtanGrpRateQtyUnit PrcgCndnTrmQtanGrpRateQtyUnit
_CmmdtyPrcgConditionFormulaTP _CmmdtyPrcgConditionFormulaTP
_CmmdtyPrcgCndnRootTrmQtanTP _CmmdtyPrcgCndnRootTrmQtanTP
_CmmdtyPrcgCndnExerTermTP _CmmdtyPrcgCndnExerTermTP
_CmmdtyPrcgCndnRmndrTermTP _CmmdtyPrcgCndnRmndrTermTP
_CmmdtyPrcgCndnRmndrFltgTrmTP _CmmdtyPrcgCndnRmndrFltgTrmTP
_CmmdtyPrcgCndnRootTermLogTP _CmmdtyPrcgCndnRootTermLogTP
_PrcgCndnQuotationGroupItemTP _PrcgCndnQuotationGroupItemTP
_PrcgCndnRootTrmCnvrsnInputTP _PrcgCndnRootTrmCnvrsnInputTP
_PrcgCndnRootTrmCnvrsnRsltTP _PrcgCndnRootTrmCnvrsnRsltTP
_PrcgCndnRootTrmRndngInputTP _PrcgCndnRootTrmRndngInputTP

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_CmmdtyPrcgCndnRootTermTP.
-- 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_CmmdtyPrcgCndnRootTermTP AS
SELECT
  DocItmCmmdtyPrcgCndnUUID,
  PricingConditionTerm,
  PrcgCndnTrmQtnPerdDetnRoutine,
  PrcgCndnTrmQtnSrceRoutine,
  TrmQtnPerdDetnRefDateRoutine,
  TrmQtnPerdDetnDteOffsetRoutine,
  TrmQtnNrOfTmeUnitsForDteOffset,
  TrmQtnPerdDetnTimeUnitRoutine,
  TrmQtnNrOfBfrBaseDateTmeUnits,
  TrmQtnNrOfAftBaseDateTmeUnits,
  CndnTrmQtnBaseDateIsExcluded,
  PrcgCndnTrmQtnFxdPeriodStrtDte,
  PrcgCndnTrmQtnFxdPeriodStrtTme,
  PrcgCndnTrmQtnFxdPeriodEndDate,
  PrcgCndnTrmQtnFxdPeriodEndTime,
  TrmQtnPerdDetnDateListRoutine,
  PrcgCndnTrmQtnPerdDetnCalender,
  TrmQtnPerdDetnMisgEntrRoutine,
  TrmQtnClosedMarketDaysRoutine,
  TrmQtnMaxElementWeightingValue,
  PrcgCndnTrmCrcyPerdDetnRoutine,
  PrcgCndnTrmExchRateSrceRoutine,
  TrmCrcyPerdDetnRefDateRoutine,
  TrmCrcyPerdDetnDteOffstRoutine,
  TrmExchRatesNrOfUnitsDteOffst,
  TrmCrcyPerdDetnTimeUnitRoutine,
  ExchRateNrOfBfrBaseDteTmeUnits,
  ExchRateNrOfAftBaseDteTmeUnits,
  CndnTrmExchRatesBaseDteIsExcld,
  CndnTrmExchRatesFxdPerdStrtDte,
  CndnTrmExchRatesFxdPerdStrtTme,
  CndnTrmExchRatesFxdPerdEndDate,
  CndnTrmExchRatesFxdPerdEndTime,
  TrmCrcyPerdDetnDateListRoutine,
  PrcgCndnTrmCrcyPerdDetnCal,
  TrmCrcyPerdDetnMisgEntrRoutine,
  TrmExchRatesClsdMktDaysRoutine,
  TrmExchRatesMaxElmntWgtngValue,
  CndnTrmQtnPerdDetnIsIncomplete,
  PrcgCndnTrmQtnPerdDetnStatus,
  CndnTrmQtnPerdDetnStartDteTime,
  CndnTrmQtnPerdDetnEndDateTime,
  TrmQtnFoundLastEntryDateTme,
  TrmQtnPerdDetnCalcdRefDate,
  TrmQtnPerdDetnCalcdBaseDteTme,
  TrmQtnPerdDetnCalcdRefDateTime,
  CndnTrmCrcyPerdDetnIsIncmplt,
  PrcgCndnTrmCrcyPerdDetnStatus,
  CndnTrmCrcyPerdDetnStartDteTme,
  CndnTrmCrcyPerdDetnEndDateTime,
  TrmExchRatesFndnLastEntrDteTme,
  TrmCrcyPerdDetnCalcdRefDate,
  TrmCrcyPerdDetnCalcdBaseDteTme,
  TrmCrcyPerdDetnCalcdRefDteTime,
  PrcgCndnTrmPrFixationOptnUUID,
  PricingConditionTermTierUUID,
  CalcdPrcgConditionTermQuantity,
  CalcdPrcgCndnTermQuantityUnit,
  ConditionTermStatus,
  BillingBlockingReason,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  PrcgCndnUsedEvalKeyDateTime,
  PrcgCndnCommodityCurveDate,
  ConditionTermRate,
  ConditionTermValue,
  PrcgConditionTermQuotationRate,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  PrcgCndnTrmUsedLimitOfCalcRule,
  PrcgCndnQtnHasQtyUoMSubstn,
  PrcgConditionTermSurchargeRate,
  PrcgCndnTrmSurchargeRteCrcy,
  PrcgCndnTrmSurchargeRteQty,
  PrcgCndnTrmSurchargeRteQtyUnit,
  PrcgCndnSurchrgHasQtyUoMSubstn,
  PricingCndnTermExtensionGroup,
  PrcgCndnBsIdnIsMnllySelected,
  BasisID,
  CmmdtyPrcgFutureConditionType,
  CmmdtyPrcgFutureTerm,
  CmmdtyPricingFlatGroupDateTime,
  PrcgCndnTermRelForFormulaRslt,
  DerivativeContractSpecCategory,
  MaturityKeyDate,
  PricingConditionTermKey,
  PricingConditionTermGroup,
  PrcgCndnTermIsUsedForPrvsnPrcg,
  PrcgConditionProvisionalTerm,
  PrcgConditionTermFirstFactor,
  PrcgConditionTermSecondFactor,
  PrcgCndnTermPercentageFactor,
  PricingConditionTermQuantity,
  PricingConditionTrmQtyUnit,
  PrcgCndnTermCalculationType,
  PricingConditionTermRule,
  PrcgCndnTrmOrignDocCategory,
  PrcgCndnTermOriginDocument,
  PrcgCndnTermOriginDocumentItem,
  PrcgCndnTrmOrignDocItemUUID,
  PrcgCndnTrmOriginConditionType,
  PrcgConditionTermFixedRateCrcy,
  PrcgConditionTermFixedRateQty,
  PrcgCndnTermFixedRateQtyUnit,
  PrcgCndnTermFreeDefinedValue,
  PrcgCndnTermFreeDefinedQtyUoM,
  PricingConditionQuotationKey,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  TimeToMaturity,
  PriceQuotationType,
  CommodityCurveType,
  AltvDrvtvContractSpecification,
  AltvMarketIdentifierCode,
  MaturitySelectionType,
  CmmdtyForwardIndexTiming,
  TrmMaturitySelRefDateRoutine,
  PrcgCndnTrmMaturitySelRoutine,
  CndnTrmPerdDetnDteOffstRoutine,
  DteOffsetRoutineTimeUnitAmount,
  DCSPeriodType,
  BasisType,
  PricingCndnTermQuotationGroup,
  PrcgCndnTermQuotationRule,
  PrcgCndnTermCalculationRule,
  PrcgConditionTermSurchargeRule,
  PrcgCndnTrmQtnPerdDetnRule,
  PrcgCndnTrmCrcyPerdDetnRule,
  PrcgCndnTrmPrFixationOptnRule,
  PrcgCndnTermCalculationRoutine,
  PrcgCndnTrmCalcLmtRateCurrency,
  PrcgCndnTrmCalcLmtRateQuantity,
  PrcgCndnTrmCalcLmtRateQtyUnit,
  PrcgCndnTermSurchargeRoutine,
  PrcgCndnTrmAbsltSurchrgAmount,
  PrcgCndnTermAbsltSurchrgCrcy,
  PrcgCndnTrmAbsltSurchrgPrQty,
  PrcgCndnTrmAbsltSurchrgQtyUnit,
  PrcgCndnTrmSurchrgFirstFactor,
  PrcgCndnTrmSurchrgSecondFactor,
  PrcgConditionTermDescription,
  PrcgCndnLtstEvalKeyDateRoutine,
  PrcgCndnTermMinCmmdtyCalcRate,
  PrcgCndnTermMaxCmmdtyCalcRate,
  PricingConditionTermFixedRate,
  PrcgCndnTrmRateCrtnDateTime,
  PrcgCndnTermRateCreatedByUser,
  PrcgCndnTrmRateChangeDateTime,
  PrcgCndnTermRateChangedByUser,
  CndnDrvtvOrdReqLeewayPrice,
  CndnDrvtvOrdReqLeewayPrcCrcy,
  TrmOptnErlstExerDateRoutine,
  TrmFixationOptnErlstExerDate,
  TrmOptnErlstExerRefDteRoutine,
  TrmOptnLtstExerciseDateRoutine,
  TrmFixationOptnLtstExerDate,
  TrmOptnLtstExerRefDteRoutine,
  PrcgCndnTermQtyDistrRoutine,
  TermFixationOptionFixationQty,
  TrmFixationOptnFixationQtyUnit,
  CndnTrmFixationOptnLmtRoutine,
  CndnTermFixationOptionLimitQty,
  TrmFixationOptionLimitQtyUnit,
  TrmFixationOptnLmtFirstFactor,
  TrmFixationOptnLmtSecondFactor,
  CndnTrmNonFixedQtyRefPrRoutine,
  CndnTrmTierDefRefDteRoutine,
  PrcgCndnTermFixationOptnStatus,
  CndnTrmFixationOptnNonFixedQty,
  TrmFixationOptnNonFixedQtyUnit,
  CndnTrmFixationOptnRsltLmtQty,
  TrmFixationOptnRsltLmtQtyUnit,
  CndnTrmFixationOptnComment,
  PricingConditionTermTier,
  PrcgConditionTermTierStartDate,
  PrcgConditionTermTierEndDate,
  PrcgConditionTermTierUpperQty,
  PrcgConditionTermTierQtyUnit,
  CmmdtyPrcgCndnTrmMttyRefDate,
  PrcgCndnTrmMttyCalcdBaseDate,
  BasisInputHashIdentifier,
  PrcgCndnTrmQtnCurrencyRate,
  CmPrcgPrcFixationSetCompUUID,
  PrcgCndnTrmActualQtanCurrency,
  PrcgCndnTermHasPriceFixation,
  PrcgCndnTrmQtanGroupCurrency,
  PrcgCndnTrmQtanGrpRateQuantity,
  PrcgCndnTrmQtanGrpRateQtyUnit
FROM I_CmmdtyPrcgConditionRootTerm
LEFT OUTER JOIN E_CmmdtyPricingConditionTerm AS _ConditionTermExtension ON DocItmCmmdtyPrcgCndnUUID = _ConditionTermExtension.DocItmCmmdtyPrcgCndnUUID AND PricingConditionTerm = _ConditionTermExtension.PricingConditionTerm  -- association [0..1]
LEFT OUTER JOIN R_PrcgCndnRootTermQuotationTP AS _CmmdtyPrcgCndnRootTrmQtanTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_CmmdtyPrcgCndnExerTermTP AS _CmmdtyPrcgCndnExerTermTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_CmmdtyPrcgCndnRootTermLogTP AS _CmmdtyPrcgCndnRootTermLogTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PrcgCndnQuotationGroupItemTP AS _PrcgCndnQuotationGroupItemTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PrcgCndnRootTrmCnvrsnInputTP AS _PrcgCndnRootTrmCnvrsnInputTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PrcgCndnRootTrmCnvrsnRsltTP AS _PrcgCndnRootTrmCnvrsnRsltTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PrcgCndnRootTrmRndngInputTP AS _PrcgCndnRootTrmRndngInputTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_CmmdtyPrcgCndnRmndrTermTP AS _CmmdtyPrcgCndnRmndrTermTP ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_CmmdtyPrcgCndnRmndrFltgTrmTP AS _CmmdtyPrcgCndnRmndrFltgTrmTP ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More