I_SECURITYCLASSCONDITION

CDS View

Security Class Condition

I_SECURITYCLASSCONDITION is a CDS View in S/4HANA. Security Class Condition. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_SecurityClassConditionTP view_entity from TRANSACTIONAL Security Class Condition
R_SecurityClassConditionTP_2 view_entity from TRANSACTIONAL Security Class Condition 
@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
}

Learn More