I_CmmdtyPricingConditionTerm

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 I_CmmdtyPricingConditionTerm.
-- 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 I_CmmdtyPricingConditionTerm AS
SELECT
  docitemcond_guid AS DocItmCmmdtyPrcgCndnUUID,
  termno AS PricingConditionTerm,
  docitem_guid AS DocItemCommodityPricingUUID,
  cond_type AS ConditionType,
  forminput_guid AS PrcgConditionFormulaInputUUID,
  terminput_guid AS PricingConditionTermInputUUID,
  termconvin_guid AS PrcgCndnTrmConversionInputUUID,
  termroundin_guid AS PrcgCndnTermRoundingInputUUID,
  perdtin_guid_q AS CndnTrmQtnPerdDetnInputUUID,
  perioddetrout_q AS PrcgCndnTrmQtnPerdDetnRoutine,
  sourcerout_q AS PrcgCndnTrmQtnSrceRoutine,
  refdaterout_q AS TrmQtnPerdDetnRefDateRoutine,
  dateoffsetrout_q AS TrmQtnPerdDetnDteOffsetRoutine,
  offsetunits_q AS TrmQtnNrOfTmeUnitsForDteOffset,
  timeuomrout_q AS TrmQtnPerdDetnTimeUnitRoutine,
  timeunitsbef_q AS TrmQtnNrOfBfrBaseDateTmeUnits,
  timeunitsaft_q AS TrmQtnNrOfAftBaseDateTmeUnits,
  excl_basedate_q AS CndnTrmQtnBaseDateIsExcluded,
  datefrom_q AS PrcgCndnTrmQtnFxdPeriodStrtDte,
  timefrom_q AS PrcgCndnTrmQtnFxdPeriodStrtTme,
  dateto_q AS PrcgCndnTrmQtnFxdPeriodEndDate,
  timeto_q AS PrcgCndnTrmQtnFxdPeriodEndTime,
  datelistrout_q AS TrmQtnPerdDetnDateListRoutine,
  perdetcalid_q AS PrcgCndnTrmQtnPerdDetnCalender,
  missentryrout_q AS TrmQtnPerdDetnMisgEntrRoutine,
  closeddaysrout_q AS TrmQtnClosedMarketDaysRoutine,
  maxweighting_q AS TrmQtnMaxElementWeightingValue,
  perdtin_guid_c AS CndnTrmCrcyPerdDetnInputUUID,
  perioddetrout_c AS PrcgCndnTrmCrcyPerdDetnRoutine,
  sourcerout_c AS PrcgCndnTrmExchRateSrceRoutine,
  refdaterout_c AS TrmCrcyPerdDetnRefDateRoutine,
  dateoffsetrout_c AS TrmCrcyPerdDetnDteOffstRoutine,
  offsetunits_c AS TrmExchRatesNrOfUnitsDteOffst,
  timeuomrout_c AS TrmCrcyPerdDetnTimeUnitRoutine,
  timeunitsbef_c AS ExchRateNrOfBfrBaseDteTmeUnits,
  timeunitsaft_c AS ExchRateNrOfAftBaseDteTmeUnits,
  excl_basedate_c AS CndnTrmExchRatesBaseDteIsExcld,
  datefrom_c AS CndnTrmExchRatesFxdPerdStrtDte,
  timefrom_c AS CndnTrmExchRatesFxdPerdStrtTme,
  dateto_c AS CndnTrmExchRatesFxdPerdEndDate,
  timeto_c AS CndnTrmExchRatesFxdPerdEndTime,
  datelistrout_c AS TrmCrcyPerdDetnDateListRoutine,
  perdetcalid_c AS PrcgCndnTrmCrcyPerdDetnCal,
  missentryrout_c AS TrmCrcyPerdDetnMisgEntrRoutine,
  closeddaysrout_c AS TrmExchRatesClsdMktDaysRoutine,
  maxweighting_c AS TrmExchRatesMaxElmntWgtngValue,
  termconvout_guid AS PrcgCndnTermConversionRsltUUID,
  perdtout_guid_q AS CndnTrmQtanPerdDetnResultUUID,
  incomplete_q AS CndnTrmQtnPerdDetnIsIncomplete,
  periodstatus_q AS PrcgCndnTrmQtnPerdDetnStatus,
  cast( firsttimestamp_q as cpet_firsttimestamp_cds preserving type ) AS CndnTrmQtnPerdDetnStartDteTime,
  cast( lasttimestamp_q as cpet_lasttimestamp_cds preserving type ) AS CndnTrmQtnPerdDetnEndDateTime,
  cast( lastfounddate_q as cpet_lastfoundtimestamp_cds preserving type ) AS TrmQtnFoundLastEntryDateTme,
  refdate_q AS TrmQtnPerdDetnCalcdRefDate,
  cast( basedate_q as cpet_basetimestamp_cds preserving type ) AS TrmQtnPerdDetnCalcdBaseDteTme,
  cast( reftimestamp_q as cpet_reftimestamp_cds preserving type ) AS TrmQtnPerdDetnCalcdRefDateTime,
  perdtout_guid_c AS CndnTrmCrcyPerdDetnResultUUID,
  incomplete_c AS CndnTrmCrcyPerdDetnIsIncmplt,
  periodstatus_c AS PrcgCndnTrmCrcyPerdDetnStatus,
  cast( firsttimestamp_c as cpet_firsttimestamp_cds preserving type ) AS CndnTrmCrcyPerdDetnStartDteTme,
  cast( lasttimestamp_c as cpet_lasttimestamp_cds preserving type ) AS CndnTrmCrcyPerdDetnEndDateTime,
  cast( lastfounddate_c as cpet_lastfoundtimestamp_cds preserving type ) AS TrmExchRatesFndnLastEntrDteTme,
  refdate_c AS TrmCrcyPerdDetnCalcdRefDate,
  cast( basedate_c as cpet_basetimestamp_cds preserving type ) AS TrmCrcyPerdDetnCalcdBaseDteTme,
  cast( reftimestamp_c as cpet_reftimestamp_cds preserving type ) AS TrmCrcyPerdDetnCalcdRefDteTime,
  ref_guid_prcfix AS PrcgCndnTrmPrFixationOptnUUID,
  ref_guid_tier AS PricingConditionTermTierUUID,
  usedquan AS CalcdPrcgConditionTermQuantity,
  useduom AS CalcdPrcgCndnTermQuantityUnit,
  termstatus AS ConditionTermStatus,
  billing_block AS BillingBlockingReason,
  termcurr AS ConditionTermRateCurrency,
  termprun AS ConditionTermRateQuantity,
  termuom AS ConditionTermRateQuantityUnit,
  cast( forecast_datetime as cpet_used_eval_key_date_cds preserving type ) AS PrcgCndnUsedEvalKeyDateTime,
  curve_date AS PrcgCndnCommodityCurveDate,
  termrate_df34 AS ConditionTermRate,
  termval_df34 AS ConditionTermValue,
  quotation_df34 AS PrcgConditionTermQuotationRate,
  quotcurr AS PrcgCndnTrmQtanRateCurrency,
  quotprun AS PrcgCndnTrmQtanRateQuantity,
  quotuom AS PrcgCndnTrmQtanRateQtyUnit,
  quotkey_grp AS PrcgCndnQtanGroupQuotationKey,
  calc_limitused AS PrcgCndnTrmUsedLimitOfCalcRule,
  quot_uomsubst AS PrcgCndnQtnHasQtyUoMSubstn,
  surchargerate_df34 AS PrcgConditionTermSurchargeRate,
  surchratecurr AS PrcgCndnTrmSurchargeRteCrcy,
  surchrateprun AS PrcgCndnTrmSurchargeRteQty,
  surchrateuom AS PrcgCndnTrmSurchargeRteQtyUnit,
  surch_uomsubst AS PrcgCndnSurchrgHasQtyUoMSubstn,
  extension_group AS PricingCndnTermExtensionGroup,
  extension_usage AS ConditionTermExtensionUsage,
  is_basis_id_manual AS PrcgCndnBsIdnIsMnllySelected,
  basis_id AS BasisID,
  fut_kschl AS CmmdtyPrcgFutureConditionType,
  fut_termno AS CmmdtyPrcgFutureTerm,
  flat_grp_timestamp AS CmmdtyPricingFlatGroupDateTime,
  formres_rel AS PrcgCndnTermRelForFormulaRslt,
  cast (dcs_type as cds_dcs_category) AS DerivativeContractSpecCategory,
  keydate AS MaturityKeyDate,
  termid AS PricingConditionTermKey,
  termgroup AS PricingConditionTermGroup,
  provis AS PrcgCndnTermIsUsedForPrvsnPrcg,
  provtermno AS PrcgConditionProvisionalTerm,
  factor1 AS PrcgConditionTermFirstFactor,
  factor2 AS PrcgConditionTermSecondFactor,
  percentage AS PrcgCndnTermPercentageFactor,
  termcommquan AS PricingConditionTermQuantity,
  termcommuom AS PricingConditionTrmQtyUnit,
  termtype AS PrcgCndnTermCalculationType,
  termrule AS PricingConditionTermRule,
  refdoccat AS PrcgCndnTrmOrignDocCategory,
  refdoc AS PrcgCndnTermOriginDocument,
  refitem AS PrcgCndnTermOriginDocumentItem,
  refguid AS PrcgCndnTrmOrignDocItemUUID,
  refcond AS PrcgCndnTrmOriginConditionType,
  fixtermcurr AS PrcgConditionTermFixedRateCrcy,
  fixtermprun AS PrcgConditionTermFixedRateQty,
  fixtermuom AS PrcgCndnTermFixedRateQtyUnit,
  userval1 AS PrcgCndnTermFreeDefinedValue,
  useruom1 AS PrcgCndnTermFreeDefinedQtyUoM,
  quotkey AS PricingConditionQuotationKey,
  dcsid AS DerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  tenor AS TimeToMaturity,
  pricetype AS PriceQuotationType,
  curve_type AS CommodityCurveType,
  curve_dcsid AS AltvDrvtvContractSpecification,
  curve_mic AS AltvMarketIdentifierCode,
  dcs_selection_type AS MaturitySelectionType,
  timing AS CmmdtyForwardIndexTiming,
  keydate_refdate_rout AS TrmMaturitySelRefDateRoutine,
  keydate_selection_rout AS PrcgCndnTrmMaturitySelRoutine,
  keydate_offset_rout AS CndnTrmPerdDetnDteOffstRoutine,
  keydate_offset_units AS DteOffsetRoutineTimeUnitAmount,
  dcs_period_type AS DCSPeriodType,
  basis_type AS BasisType,
  quotgroup AS PricingCndnTermQuotationGroup,
  quotationrule AS PrcgCndnTermQuotationRule,
  calcrule AS PrcgCndnTermCalculationRule,
  surchargerule AS PrcgConditionTermSurchargeRule,
  perdetrule_q AS PrcgCndnTrmQtnPerdDetnRule,
  perdetrule_c AS PrcgCndnTrmCrcyPerdDetnRule,
  pricefixrule AS PrcgCndnTrmPrFixationOptnRule,
  calcrout AS PrcgCndnTermCalculationRoutine,
  calcmmcurr AS PrcgCndnTrmCalcLmtRateCurrency,
  calcmmprun AS PrcgCndnTrmCalcLmtRateQuantity,
  calcmmuom AS PrcgCndnTrmCalcLmtRateQtyUnit,
  surchargerout AS PrcgCndnTermSurchargeRoutine,
  surchargeabs_df34 AS PrcgCndnTrmAbsltSurchrgAmount,
  surchargecurr AS PrcgCndnTermAbsltSurchrgCrcy,
  surchargeprun AS PrcgCndnTrmAbsltSurchrgPrQty,
  surchargeuom AS PrcgCndnTrmAbsltSurchrgQtyUnit,
  surchargefactor1 AS PrcgCndnTrmSurchrgFirstFactor,
  surchargefactor2 AS PrcgCndnTrmSurchrgSecondFactor,
  termtext AS PrcgConditionTermDescription,
  forecast_date_routine AS PrcgCndnLtstEvalKeyDateRoutine,
  calcmin_df34 AS PrcgCndnTermMinCmmdtyCalcRate,
  calcmax_df34 AS PrcgCndnTermMaxCmmdtyCalcRate,
  fixtermrate_df34 AS PricingConditionTermFixedRate,
  cast( rate_created_at as cpet_created_at_cds preserving type ) AS PrcgCndnTrmRateCrtnDateTime,
  rate_created_by AS PrcgCndnTermRateCreatedByUser,
  cast( rate_changed_at as cpet_changed_at_cds preserving type ) AS PrcgCndnTrmRateChangeDateTime,
  rate_changed_by AS PrcgCndnTermRateChangedByUser,
  psmguid AS PrcgCndnTrmPrSettingMethodUUID,
  psmethod AS PrcgCndnTermPriceSettingMethod,
  psmstatus AS PrcgCndnTrmPrSttgMethodStatus,
  commoditysubaccount AS PrcgCndnTermCmmdtySubAccount,
  number_of_lots AS PrcgConditionTermNumberOfLots,
  fillpacketuuid AS PrcgCndnDrvtvOrdFillPacketUUID,
  psm_simulation_error AS PrcgCndnTrmPrSttgMethHasError,
  exprtninstruction AS PrcgCndnDrvtvOrdReqExpryInstrn,
  prcgexecinstrn AS PrcgCndnOrdReqPrcgExecInstrn,
  lmtprc AS PrcgCndnDrvtvOrdReqLimitPrice,
  lmtprccurrency AS PrcgCndnDrvtvOrdReqLmtPrcCrcy,
  stopprice AS PrcgCndnDrvtvOrdReqStopPrice,
  stoppricecrcy AS PrcgCndnDrvtvOrdReqStopPrcCrcy,
  stoplmtprc AS CndnDrvtvOrdReqStopLimitPrice,
  stoplmtprccurrency AS CndnDrvtvOrdReqStopLmtPrcCrcy,
  fxdprc AS CndnDrvtvOrdReqReqdFxdPrice,
  fxdprccrcy AS CndnDrvtvOrdReqReqdFxdPrcCrcy,
  leewayprc AS DrvtvOrdReqReqdLeewayPrice,
  leewayprccrcy AS DrvtvOrdReqReqdLeewayPriceCrcy,
  leewayrngeprc AS CndnDrvtvOrdReqLeewayPrice,
  leewayrngeprccrcy AS CndnDrvtvOrdReqLeewayPrcCrcy,
  expirationdate AS PrcgCndnDrvtvOrdReqExprtnDate,
  lmtspreadprc AS CndnDrvtvOrdReqLmtSpreadVal,
  lmtspreadprccrcy AS CndnDrvtvOrdReqLmtSpreadPrCrcy,
  fxdspreadprc AS DrvtvOrdReqReqdFxdSpreadPrice,
  fxdspreadprccrcy AS DrvtvOrdReqReqdFxdSpreadPrCrcy,
  ticks AS CndnNrOfDrvtvOrderRequestTicks,
  cmmdtyordreqcntrptybroker AS PrcgCndnTrmCtptyBrokerName,
  cmmdtyordreqcntrptyrefacct AS PrcgCndnTrmRefBrokerAccount,
  savetermrate_df34 AS PrcgCndnTermSavedFixedRate,
  savetermcurr AS PrcgCndnTermSavedFixedRateCrcy,
  exer_date_early_rout AS TrmOptnErlstExerDateRoutine,
  exer_date_earliest AS TrmFixationOptnErlstExerDate,
  exer_date_earliest_ref_date_rt AS TrmOptnErlstExerRefDteRoutine,
  exer_date_latest_rout AS TrmOptnLtstExerciseDateRoutine,
  exer_date_latest AS TrmFixationOptnLtstExerDate,
  exer_date_latest_ref_date_rt AS TrmOptnLtstExerRefDteRoutine,
  quantity_distr_rout AS PrcgCndnTermQtyDistrRoutine,
  quantity_ref AS TermFixationOptionFixationQty,
  quantity_ref_uom AS TrmFixationOptnFixationQtyUnit,
  limit_rout AS CndnTrmFixationOptnLmtRoutine,
  limit_quantity AS CndnTermFixationOptionLimitQty,
  limit_quantity_uom AS TrmFixationOptionLimitQtyUnit,
  limit_factor_1 AS TrmFixationOptnLmtFirstFactor,
  limit_factor_2 AS TrmFixationOptnLmtSecondFactor,
  price_ref_rout AS CndnTrmNonFixedQtyRefPrRoutine,
  tier_ref_date_rout AS CndnTrmTierDefRefDteRoutine,
  prc_fixation_status AS PrcgCndnTermFixationOptnStatus,
  non_fixed_quantity AS CndnTrmFixationOptnNonFixedQty,
  non_fixed_qty_uom AS TrmFixationOptnNonFixedQtyUnit,
  limit_quantity_out AS CndnTrmFixationOptnRsltLmtQty,
  limit_quantity_uom_out AS TrmFixationOptnRsltLmtQtyUnit,
  option_comment_short AS CndnTrmFixationOptnComment,
  tierno AS PricingConditionTermTier,
  date_from AS PrcgConditionTermTierStartDate,
  date_to AS PrcgConditionTermTierEndDate,
  qty_to AS PrcgConditionTermTierUpperQty,
  uom AS PrcgConditionTermTierQtyUnit,
  pricefixationexists AS PrcgCndnTermHasPriceFixation,
  maturity_reference_date AS CmmdtyPrcgCndnTrmMttyRefDate,
  maturity_calculated_base_date AS PrcgCndnTrmMttyCalcdBaseDate,
  basis_id_input_hash AS BasisInputHashIdentifier,
  termrate_in_quotcurr AS PrcgCndnTrmQtnCurrencyRate,
  prcfixsetcomp_guid AS CmPrcgPrcFixationSetCompUUID,
  term_actual_quot_curr AS PrcgCndnTrmActualQtanCurrency,
  prcfixratemaintained AS CmmdtyPrcFixedRateIsMaintained,
  quotation_group_currency AS PrcgCndnTrmQtanGroupCurrency,
  quotation_group_price_unit AS PrcgCndnTrmQtanGrpRateQuantity,
  quotation_group_uom AS PrcgCndnTrmQtanGrpRateQtyUnit,
  spreadrequest AS PricingConditionTermHasSpread,
  originalmaturitykeydate AS PrcgCndnTermOriglMttyKeyDate
FROM cpe_term
LEFT OUTER JOIN E_CmmdtyPricingConditionTerm AS _ConditionTermExtension ON DocItmCmmdtyPrcgCndnUUID = _ConditionTermExtension.DocItmCmmdtyPrcgCndnUUID AND PricingConditionTerm = _ConditionTermExtension.PricingConditionTerm  -- association [0..1]
;