I_FINTRANSINTERESTCONDITION

@AbapCatalog.sqlViewName: 'IFININTRSTCNDN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Interest Condition'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
define view I_FinTransInterestCondition
  as select from I_FinTransCondition
{

      //exposed fields

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_FinTrans'
  key FinancialTransaction,
      @ObjectModel.foreignKey.association: '_Activity'
  key FinancialInstrumentActivity,
      @ObjectModel.foreignKey.association: '_Direction'
  key FinancialTransactionDirection,
  key FinConditionItem,
  key ConditionItemValidityStartDate,
      
      _FinTrans.FinancialInstrProductCategory,
      @ObjectModel.foreignKey.association: '_ContractType'
      TreasuryContractType,
      @ObjectModel.foreignKey.association: '_ConditionCategory'
      FinConditionConditionCategory,
      @ObjectModel.foreignKey.association: '_ConditionType'
      FinConditionConditionType,
      FinInstrConditionLogicGroup,
      
      // Amount 

      InterestCalculationMethod,
      IntrstCalcMethFactoryCalendar,
      InterestCalculationType,
      ExponentialIntrstSettlmtFrqcy,
      @ObjectModel.foreignKey.association: '_InterestCategory'
      FinConditionInterestCategory,
      
      // Amount - Rate

      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      FinConditionFixedAmount as FinancialConditionItemAmount,
      @ObjectModel.foreignKey.association: '_ConditionItemCurrency'
      @Semantics.currencyCode: true
      FinConditionFixedAmountCrcy as FinancialConditionItemCurrency,
      ConditionPercentageRate,
      FinancialConditionPaymentRate,
      @ObjectModel.foreignKey.association: '_ReferenceInterestRate'
      InterestReference,
      InterestMarkupMarkdownValue,
      InterestFirstPeriodRate,
      FinConditionFormulaReference,
     
      // Dates

      @ObjectModel.foreignKey.association: '_Calendar1'
      FinConditionFactoryCalendar1,
      @ObjectModel.foreignKey.association: '_Calendar2'
      FinConditionFactoryCalendar2,
      @ObjectModel.foreignKey.association: '_Calendar3'
      FinConditionFactoryCalendar3,
      @ObjectModel.foreignKey.association: '_Calendar4'
      FinConditionFactoryCalendar4,
      @ObjectModel.foreignKey.association: '_Calendar5'
      FinConditionFactoryCalendar5,
      FinCndnFirstPeriodCalcMethod,
      FinCndnLastPeriodCalcMethod,
      
      // Dates/Calculation Date

      FinCndnCalcDteUpdateRule,
      FinCndnCalcDteFrequency,
      FinCndnCalcDteFrqcyUnit,
      CalculationDate,
      CalcDateIsAsEndDateInclusive,
      CalcDteIsRegularWithVarblDte,
      CalcDateIsAsEndDateMonthEnd,
      FinCndnCalcDteWrkgDayShft,
      FinCndnCalcDteShftDrctn,
      FinCndnCalcDteShftNrOfDays,
      InterestCalculationDateRef,
      
      // Dates/Due Date

      FinCndnDueDteUpdateRule,
      FinCndnDueDteFrequency,
      FinCndnDueDteFrqcyUnit,
      DueDate,
      DueDteIsRegularWithVarblDte,
      DueDateIsAsEndDateInclusive,
      DueDateIsAsEndDateMonthEnd,
      FinCndnDueDteWrkgDayShft,
      FinCndnDueDteShftDrctn,
      FinCndnDueDteShftNrOfDays,
      InterestDueDateReference,
      FinCndnDueDteShiftToTermEnd,
      
      // Dates/Payment Date

      FinCndnPaytDateWrkgDayShft,
      
      // Average Interest Rate

      AverageIntrstRateWeightingCat,
      AverageIntrstRateRndngCategory,
      AverageIntrstRateRndngDecimals,
      AverageInterestRateSpreadValue,
      AvgIntrstRateHasUsedUpperLimit,
      AverageInterestUpperLimitRate,
      AvgIntrstRateHasUsedLowerLimit,
      AverageInterestLowerLimitRate,
      AverageIntrstRateResetCalcEvt,
      
      // Rounding Factors

      FinCndnRateFactorRndngCategory,
      FinCndnRateFactorRndngDecimals,
      FinCndnFactorRoundingCategory,
      FinCndnFactorRoundingDecimals,
      FinCndnBaseFactorRndngCategory,
      FinCndnBaseFactorRndngDecimals,
      
      // Roud Amount

      FinCndnAmountRoundingCategory,
      FinCndnAmountRoundingUnit,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      RndngBaseUntAmtInCndnItmCrcy,
      
      // Calculation Base

      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      FinConditionIntrstBaseAmount as FinCndnCalcBaseAmt,
      FinCndnCalcBaseReference,
      FinCndnProcessingSequenceValue,
      
      // Currency Related

      FinCndnAmountTimeUnit,
      FinCndnItmHasUsedLowerLimitAmt,
      @Semantics.amount.currencyCode: 'FinCndnLimitAmountCurrency'
      FinCndnItemLowerLimitAmount,
      FinCndnItmHasUsedUpperLimitAmt,
      @Semantics.amount.currencyCode: 'FinCndnLimitAmountCurrency'
      FinCndnItemUpperLimitAmount,
      FinCndnLimitAmountCurrency,
      
      
      // Related Accumulated Flow Group

      FinCndnCrsRefcdAccmlnCndnGrp,

      //exposed dimensions, containing for example text fields

      _CompanyCode,
      _FinTrans,
      _Activity,
      _Direction,
      _ContractType,
      _ConditionCategory,
      _ConditionType,
      _InterestCategory,
      _ReferenceInterestRate,
      _FixCurrency as _ConditionItemCurrency,
      _Calendar1,
      _Calendar2,
      _Calendar3,
      _Calendar4,
      _Calendar5,
      _SingleDate,
      _FormulaVariable,
      _Scale

}
where
      ( FinConditionConditionCategory = '20' or FinConditionConditionCategory = '15' )