I_FinTransIntrstRateInstr

Fin Transaction Interest Rate Instrment | view: IFINTRANIRIF | TRAN | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: T001, TKA02, VTBFHA
Column Name Description
CompanyCode FK Company Code
FinancialTransaction Financial Transaction
Column Name Description
Column Name Description
Column Name Description
FinTransCreationDate Entered On
FinTransCreationTime Entry Time
LastChangeDate Last Change Date
FinInstrumentLastChangedTime Time Changed
TermStartDate Term Start
TermEndDate Term End
Column Name Description
TreasuryContractType Contract Type Show values
TermStartDateIsInclusive Truth Value: True/False Show values
FinTransNoticePeriodUnit Unit of Period of Notice Show values
FinancialInstrumentStatus Active Status of Transaction or Activity Show values
FinTransReleaseStatus Transaction Release: Release Status Show values
FinTransIsRiskMitigating Risk Mitigation Indicator Show values
Column Name Description Domain name
CreatedByUser Entered By SYCHAR12
LastChangedByUser Last Changed By User XUBNAME
FinTransNoticePeriod Period of Notice T_AKUEND
Counterparty Counterparty number BU_PARTNER
FinancialInstrumentGuarantor Guarantor of Financial Transaction BU_PARTNER
TreasuryFinanceProject Finance Project T_TFPROJ
FinancialInstrumentAssignment Free Assignment of Financial Transaction TEXT18
FinancialInstrumentReference Financial Instrument Free Internal Reference CHAR16
FinancialInstrCharacteristic Financial Instrument Free Characteristic CHAR25
FinInstrLastActiveActivity Financial Instrument Last Active Activity T_RFHAZU
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_FINTRANSINTRSTRATEINSTR.BUSINESSAREA == TGSB.GSBER
  • I_FINTRANSINTRSTRATEINSTR.MANDT == TGSB.MANDT
Company code
  • Client
  • Company Code
  • I_FINTRANSINTRSTRATEINSTR.MANDT == T001.MANDT
  • I_FINTRANSINTRSTRATEINSTR.COMPANYCODE == T001.BUKRS
Cost Center
  • Cost Center
  • Client
  • ?
  • ?
  • I_FINTRANSINTRSTRATEINSTR.COSTCENTER == CSKS.KOSTL
  • I_FINTRANSINTRSTRATEINSTR.MANDT == CSKS.MANDT
  • I_FINTRANSINTRSTRATEINSTR.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_FINTRANSINTRSTRATEINSTR.[column in domain "DATBI"] == CSKS.DATBI
Financial Instrument Product Category I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Financial Instrument Transaction Type
  • Product Type
  • Client
  • I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
  • I_FINTRANSINTRSTRATEINSTR.MANDT == AT10.MANDT
Transaction type
  • Product Type
  • Client
  • I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
  • I_FINTRANSINTRSTRATEINSTR.MANDT == TZPA.MANDT
Transaction Category
  • Transaction Category
  • Financial Instrument Product Category
  • I_FINTRANSINTRSTRATEINSTR.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
  • I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == AT01.SANLFOR
Factory calendar I_FINTRANSINTRSTRATEINSTR.FINTRANSFACTORYCALENDAR1 == TFACD.IDENT
Factory calendar I_FINTRANSINTRSTRATEINSTR.FINTRANSFACTORYCALENDAR2 == TFACD.IDENT
Processing Category
  • Processing Category
  • Transaction Category
  • Financial Instrument Product Category
  • I_FINTRANSINTRSTRATEINSTR.FINTRANSPROCESSINGCATEGORY == AT05.ABWTYP
  • I_FINTRANSINTRSTRATEINSTR.FININSTRTRANSACTIONCATEGORY == AT05.SFGTYP
  • I_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == AT05.SANLF
Hedging Classification
  • Hedging Classification
  • Client
  • I_FINTRANSINTRSTRATEINSTR.HEDGINGCLASSIFICATION == TOEC_CLASS.HEDGING_CLASSIFICATION
  • I_FINTRANSINTRSTRATEINSTR.MANDT == TOEC_CLASS.CLIENT
Portfolio
  • Client
  • Company Code
  • Portfolio
  • I_FINTRANSINTRSTRATEINSTR.MANDT == TWPOB.MANDT
  • I_FINTRANSINTRSTRATEINSTR.COMPANYCODE == TWPOB.BUKRS
  • I_FINTRANSINTRSTRATEINSTR.PORTFOLIO == TWPOB.RPORTB
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • I_FINTRANSINTRSTRATEINSTR.PROFITCENTER == CEPC.PRCTR
  • I_FINTRANSINTRSTRATEINSTR.MANDT == CEPC.MANDT
  • I_FINTRANSINTRSTRATEINSTR.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_FINTRANSINTRSTRATEINSTR.[column in domain "DATBI"] == CEPC.DATBI
Transaction Currency
  • Client
  • Transaction Currency
  • I_FINTRANSINTRSTRATEINSTR.MANDT == TCURC.MANDT
  • I_FINTRANSINTRSTRATEINSTR.TRANSACTIONCURRENCY == TCURC.WAERS
Transaction Number of Facility
  • Transaction Number of Facility
  • Client
  • Company Code of Facility
  • I_FINTRANSINTRSTRATEINSTR.TREASURYFACILITY == VTBFHA.RFHA
  • I_FINTRANSINTRSTRATEINSTR.MANDT == VTBFHA.MANDT
  • I_FINTRANSINTRSTRATEINSTR.TREASURYFACILITYCOMPANYCODE == VTBFHA.BUKRS
Company Code of Facility
  • Client
  • Company Code of Facility
  • I_FINTRANSINTRSTRATEINSTR.MANDT == T001.MANDT
  • I_FINTRANSINTRSTRATEINSTR.TREASURYFACILITYCOMPANYCODE == T001.BUKRS
General Valuation Class
  • General Valuation Class
  • Client