R_SecurityClassConditionTP

@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MASTER
}
@EndUserText.label: 'Security Class Condition'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_SecurityClassConditionTP
  as select from I_SecurityClassCondition
  association to parent R_SecurityClassTP              as _SecurityClass on $projection.SecurityClass = _SecurityClass.SecurityClass

  composition [0..*] of R_ScrtyClCndnFormulaVariableTP as _FormulaVariable
{
  key SecurityClass,
  key FinConditionConditionType,
  key case
        when dats_is_valid(ConditionItemValidityStartDate) = 1
          then ConditionItemValidityStartDate
        else
          '99991231'
      end as ConditionItemValidityStartDate,
    
      FinancialInstrProductCategory,
      CndnItmValdtyStrtDtIsInclusive,
      FinConditionForm,

      FinCndnReferenceConditionType,
      FinCndnRefAccumulatingCndnType,

      InterestCalculationMethod,

      InterestCalculationType,

      ExponentialIntrstSettlmtFrqcy,
      IntrstCalcMethFactoryCalendar,
      InterestFirstPeriodRate, 

      InterestRefRateOptrSign,
      InterestReference,
      ConditionPercentageRate,
      FinancialConditionPaymentRate,

      DividendFactorType,
      FinCndnRateFactorRndngCategory,
      FinCndnRateFactorRndngDecimals,
      
      FinCndnFactorRoundingCategory,
      FinCndnFactorRoundingDecimals,
      FinCndnBaseFactorRndngCategory,
      FinCndnBaseFactorRndngDecimals,       
      
      FinCndnAmountRoundingCategory,
      FinCndnAmountRoundingUnit,
      RndngBaseUntAmtInCndnItmCrcy,
      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
}
where
  I_SecurityClassCondition.FinConditionSubItem = '00'