I_SecurityClassCondition

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Security Class Condition'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE
define view entity I_SecurityClassCondition
  as select from I_SecurityClassConditionItem


  association [0..*] to I_ScrtyClCndnFormulaVariable as _FormulaVariable on  $projection.SecurityClass                  = _FormulaVariable.SecurityClass
                                                                         and $projection.FinConditionConditionType      = _FormulaVariable.FinConditionConditionType
                                                                         and $projection.ConditionItemValidityStartDate = _FormulaVariable.ConditionItemValidityStartDate
                                                                         and $projection.FinConditionSubItem            = _FormulaVariable.FinConditionSubItem

  association [1..1] to I_SecurityClass              as _SecurityClass   on  $projection.SecurityClass = _SecurityClass.SecurityClass

{
  key SecurityClass,
  key FinConditionConditionType,
  key ConditionItemValidityStartDate,
  key FinConditionSubItem,
      FinancialInstrProductCategory,
      CndnItmValdtyStrtDtIsInclusive,
      FinConditionForm,

      FinCndnReferenceConditionType,
      FinCndnRefAccumulatingCndnType,

      InterestCalculationMethod,

      InterestCalculationType,

      ExponentialIntrstSettlmtFrqcy,
      IntrstCalcMethFactoryCalendar,
      InterestFirstPeriodRate,

      InterestRefRateOptrSign,

      case
        when FinConditionFormulaReference is initial
          then InterestReference
        else ''
      end as InterestReference,

      case
        when FinConditionFormulaReference is initial
          then ConditionPercentageRate
        else 0
      end as ConditionPercentageRate,

      FinancialConditionPaymentRate,

      DividendFactorType,
      FinCndnRateFactorRndngCategory,
      FinCndnRateFactorRndngDecimals,

      FinCndnFactorRoundingCategory,
      FinCndnFactorRoundingDecimals,
      FinCndnBaseFactorRndngCategory,
      FinCndnBaseFactorRndngDecimals,

      FinCndnAmountRoundingCategory,
      FinCndnAmountRoundingUnit,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      RndngBaseUntAmtInCndnItmCrcy,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      FinConditionIntrstBaseAmount,
      FinCndnCalcBaseReference,
      FinancialConditionItemAmount,
      FinancialConditionItemCurrency,

      FinCndnAmountTimeUnit,

      //FinConditionExchangeRate,

      ScrtyClCndnDrctExchRate,
      ScrtyClCndnIndrctExchRate,
      FinConditionFactoryCalendar1,
      FinConditionFactoryCalendar2,
      FinConditionFactoryCalendar3,
      FinConditionFactoryCalendar4,
      FinConditionFactoryCalendar5,

      //Average Interest Rate

      AverageIntrstRateWeightingCat,
      AverageIntrstRateRndngCategory,
      AverageIntrstRateRndngDecimals,
      AverageInterestRateSpreadValue,
      AvgIntrstRateHasUsedUpperLimit,
      AverageInterestUpperLimitRate,
      AvgIntrstRateHasUsedLowerLimit,
      AverageInterestLowerLimitRate,
      AverageIntrstRateResetCalcEvt,

      //Update Rule

      FinCndnUpdateRuleEntryType,
      FinCndnUpdateRuleFirstDate,
      FinCndnUpdateRuleDateFrequency,
      FinCndnUpdateRuleDateFrqcyUnit,
      UpdateRuleDateIsMonthEnd,
      FinCndnUpdtRuleDateWrkgDayShft,

      //Calculation Date

      FinCndnCalcDteUpdateRule,
      CalculationDate,
      FinCndnCalcDteFrequency,
      FinCndnCalcDteFrqcyUnit,
      CalcDateIsAsEndDateInclusive,
      CalcDateIsAsEndDateMonthEnd,
      FinCndnCalcDteWrkgDayShft,
      FinCndnCalcDteShftDrctn,
      ScrtyClCndnCalcDteShftNrOfDays,
      CalcDteIsRegularWithVarblDte,
      InterestCalculationDateRef,

      //Due Date

      FinCndnDueDteUpdateRule,
      DueDate,
      FinCndnDueDteFrequency,
      FinCndnDueDteFrqcyUnit,
      DueDateIsAsEndDateInclusive,
      DueDateIsAsEndDateMonthEnd,
      FinCndnDueDteWrkgDayShft,
      FinCndnDueDteShftDrctn,
      ScrtyClCndnDueDteShftNrOfDays,
      DueDteIsRegularWithVarblDte,
      InterestDueDateReference,

      //Payment Date

      FinCndnPaytDateWrkgDayShft,

      //Other Calculation Date

      FinCndnDueDteShiftToTermEnd,
      FinCndnDuDteIsFinMathCalcReltd,
      FinCndnRpaytSettlmt,
      FinCndnFirstPeriodCalcMethod,
      FinCndnLastPeriodCalcMethod,

      //Interest Rate Adjustment Date

      InterestRateAdjustmentDateRule,
      InterestRateAdjustmentDate,
      IntrstRateAdjmtDateIsMonthEnd,
      InterestRateAdjustmentFrqcy,
      InterestRateAdjmtFrqcyUnit,
      IntrstRateAdjmtDateWrkgDayShft,
      FinCndnAdjmtDteShftDrctn,
      ScrtyClIntrstRateAdjmtShftDays,

      //Interest Rate Fixing Date

      InterestRateFixingDateRule,
      InterestRateFixingDate,
      IntrstRateFixingDateIsMonthEnd,
      InterestRateFixingFrqcy,
      InterestRateFixingFrqcyUnit,
      FinCndnFixingDteShftDrctn,
      ScrtyClIntrstRateFixShftDays,
      FinCndnRateFixingLockoutPeriod,
      IntrstRateFixDteShftIsModifd,
      InterestRateFixingDateRef,

      _FormulaVariable,
      _SecurityClass
}