P_SecClassIntCond

Interest condition for Sec. Class | view: PSECCLASSINTCOND | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TZK01VTBFHAVZZKOPO
Column Name Description
CompanyCode FK Company Code
FinancialInstrProductCategory Product Category
FinancialInstrumentActivity Last Active Transaction Activity
SecurityClass Key part 1
ConditionLevelNumber Level number of condition item for recurring payments
SecurityAccount FK Securities Account
FinInstrConditoinType FK Condition Type (Smallest Subdivision of Condition Records)
Column Name Description
ConditionFixAmount Condition Item Currency Amount
Column Name Description
Column Name Description
ConditionItemValidityStartDate Condition Item Effective From
TermStartDate Term Start
TermEndDate Term End
Column Name Description
CalcDateIsAsEndDateInclusive Inclusive indicator for beginning and end of a period Show values
ContractType Contract Type Show values
CashFlowDirection +/- sign / reference interest rate operator Show values
Column Name Description Domain name
ConditionPercentageRate Percentage rate for condition items DECV3_7
FinancialInstrTransactionType Financial Transaction Type T_SFHAART
InterestRateInPercent Percentage rate for condition items DECV3_7
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_SECCLASSINTCOND.COMPANYCODE == T001.BUKRS
  • P_SECCLASSINTCOND.MANDT == T001.MANDT
Transaction type
  • Client
  • Product Type
  • P_SECCLASSINTCOND.MANDT == TZPA.MANDT
  • P_SECCLASSINTCOND.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Condition type
  • Client
  • ?
  • Condition Type (Smallest Subdivision of Condition Records)
  • P_SECCLASSINTCOND.MANDT == TZK01.MANDT
  • P_SECCLASSINTCOND.[column in domain "RANTYP"] == TZK01.RANTYP
  • P_SECCLASSINTCOND.FININSTRCONDITOINTYPE == TZK01.SKOART
Securities Account
  • Company Code
  • Client
  • Securities Account
  • P_SECCLASSINTCOND.COMPANYCODE == TWD01.BUKRS
  • P_SECCLASSINTCOND.MANDT == TWD01.MANDT
  • P_SECCLASSINTCOND.SECURITYACCOUNT == TWD01.RLDEPO
Transaction Currency
  • Client
  • Transaction Currency
  • P_SECCLASSINTCOND.MANDT == TCURC.MANDT
  • P_SECCLASSINTCOND.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Reference Interest Rate
  • Client
  • Reference Interest Rate
  • P_SECCLASSINTCOND.MANDT == T056R.MANDT
  • P_SECCLASSINTCOND.REFERENCEINTERESTRATE == T056R.REFERENZ