I_CmmdtyPricingTermInputData

@AbapCatalog.sqlViewName: 'ITERMINPUTDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'CPE Term Changed Input for General Data'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'PricingConditionTermInputUUID'
define view I_CmmdtyPricingTermInputData
  as select from cped_terminput                                              as terminput
    inner join   P_CmmdtyPricingTermInputData( p_sapclient: $session.client) as terminput_rates on terminput.terminput_guid = terminput_rates.PrcgConditionTermInputUUID
  association [0..*] to I_CmmdtyPricingQuotationRule as _CmmdtyPricingQuotationRule   on  $projection.PrcgCndnTermQuotationRule = _CmmdtyPricingQuotationRule.PrcgCndnTermQuotationRule
  association [0..1] to I_CommodityPricingRoutine    as _PrcgCndnTermCalculationType  on  _PrcgCndnTermCalculationType.OriginSystem              = '          '
                                                                                      and _PrcgCndnTermCalculationType.PricingConditionModule    = 'FE'
                                                                                      and _PrcgCndnTermCalculationType.PricingConditionSubModule = '05'
                                                                                      and _PrcgCndnTermCalculationType.PricingConditionRoutine   = $projection.PrcgCndnTermCalculationType
  association [0..*] to I_CmmdtyPricingTermRule      as _PricingConditionTermRule     on  $projection.PricingConditionTermRule = _PricingConditionTermRule.PricingConditionTermRule
  association [0..1] to I_Currency                   as _PrcgCndnTermFixedRateCrcy    on  $projection.PrcgConditionTermFixedRateCrcy = _PrcgCndnTermFixedRateCrcy.Currency
  association [0..1] to I_UnitOfMeasure              as _PrcgCndnTermFixedRateQtyUnit on  $projection.PrcgCndnTermFixedRateQtyUnit = _PrcgCndnTermFixedRateQtyUnit.UnitOfMeasure
  association [0..1] to I_DerivativeContrSpec        as _DerivativeContrSpecification on  $projection.DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification
  association [0..1] to I_MarketIdentCode            as _MarketIdentifierCode         on  $projection.MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode
  association [0..1] to I_TimeToMaturity             as _TimeToMaturity               on  $projection.TimeToMaturity = _TimeToMaturity.TimeToMaturity
  association [0..1] to I_PriceQuotationType         as _QuotationPriceType           on  $projection.QuotationPriceType = _QuotationPriceType.PriceQuotationType
{

  key terminput_guid as PricingConditionTermInputUUID,
      termtype       as PrcgCndnTermCalculationType,
      termrule       as PricingConditionTermRule,
      //  refdoccat,

      //  refdoc,

      //  refitem,

      //  refguid,

      //  refcond,

      //  fixtermrate,

      @ObjectModel.foreignKey.association: '_PrcgCndnTermFixedRateCrcy'
      @Semantics.currencyCode: true
      terminput_rates.PrcgConditionTermFixedRateCrcy,
      terminput_rates.PrcgConditionTermFixedRateQty,
      @ObjectModel.foreignKey.association: '_PrcgCndnTermFixedRateQtyUnit'
      @Semantics.unitOfMeasure: true
      terminput_rates.PrcgCndnTermFixedRateQtyUnit,
      //  userval1,

      //  useruom1,

      //  quotkey,

      @ObjectModel.foreignKey.association: '_DerivativeContrSpecification'
      dcsid          as DerivativeContrSpecification,
      @ObjectModel.foreignKey.association: '_MarketIdentifierCode'
      mic            as MarketIdentifierCode,
      @ObjectModel.foreignKey.association: '_TimeToMaturity'
      tenor          as TimeToMaturity,
      @ObjectModel.foreignKey.association: '_QuotationPriceType'
      pricetype      as QuotationPriceType,
      //  forecast_routine,

      //  curve_type,

      //  curve_dcsid,

      //  curve_mic,

      //  dcs_selection_type,

      //  timing,

      //  keydate_refdate_rout,

      //  keydate_selection_rout,

      //  keydate_offset_rout,

      //  keydate_offset_units,

      //  dcs_period_type,

      //  basis_type,

      //  quotgroup,

      quotationrule  as PrcgCndnTermQuotationRule,
      keydate        as MaturityKeyDate,
      calcrule       as PrcgCndnTermCalculationRule,
      //  surchargerule,

      //  perdetrule_q,

      //  perdetrule_c,

      //  pricefixrule,

      //  perdtin_guid_q,

      //  perdtin_guid_c,

      //  calcrout,

      //  calcmin,

      //  calcmax,

      //  calcmmcurr,

      //  calcmmprun,

      //  calcmmuom,

      //  surchargerout,

      //  surchargeabs,

      //  surchargeabs_df34,

      //  surchargecurr,

      //  surchargeprun,

      //  surchargeuom,

      //  surchargefactor1,

      //  surchargefactor2,

      //  termtext,

      //  forecast_date_routine,

      //  calcmin_df34,

      //  calcmax_df34,

      terminput_rates.PricingConditionTermFixedRate,
      //  rate_created_at,

      //  rate_created_by,

      //  rate_changed_at,

      //  rate_changed_by,

      //  psmguid,

      //  psmethod,

      //  psmstatus,

      //  commoditysubaccount,

      //  number_of_lots,

      //  fillpacketuuid,

      //  psm_simulation_error,

      //  exprtninstruction,

      //  prcgexecinstrn,

      //  lmtprc,

      //  lmtprccurrency,

      //  stopprice,

      //  stoppricecrcy,

      //  stoplmtprc,

      //  stoplmtprccurrency,

      //  fxdprc,

      //  fxdprccrcy,

      //  leewayprc,

      //  leewayprccrcy,

      //  leewayrngeprc,

      //  leewayrngeprccrcy,

      //  expirationdate,

      //  lmtspreadprc,

      //  lmtspreadprccrcy,

      //  fxdspreadprc,

      //  fxdspreadprccrcy,

      //  ticks,

      //  cmmdtyordreqcntrptybroker,

      //  cmmdtyordreqcntrptyrefacct,

      //  savetermrate_df34,

      //  savetermcurr

      _CmmdtyPricingQuotationRule,
      _PrcgCndnTermCalculationType,
      _PricingConditionTermRule,
      _PrcgCndnTermFixedRateCrcy,
      _PrcgCndnTermFixedRateQtyUnit,
      _DerivativeContrSpecification,
      _MarketIdentifierCode,
      _TimeToMaturity,
      _QuotationPriceType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CPED_TERMINPUT"
],
"ASSOCIATED":
[
"I_CMMDTYPRICINGQUOTATIONRULE",
"I_CMMDTYPRICINGTERMRULE",
"I_COMMODITYPRICINGROUTINE",
"I_CURRENCY",
"I_DERIVATIVECONTRSPEC",
"I_MARKETIDENTCODE",
"I_PRICEQUOTATIONTYPE",
"I_TIMETOMATURITY",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/