P_FinTransIntrstRateInstr

Fin Transaction Interest Rate Instrment | view: PFINTRANIRI | 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
  • P_FINTRANSINTRSTRATEINSTR.BUSINESSAREA == TGSB.GSBER
  • P_FINTRANSINTRSTRATEINSTR.MANDT == TGSB.MANDT
Company code
  • Client
  • Company Code
  • P_FINTRANSINTRSTRATEINSTR.MANDT == T001.MANDT
  • P_FINTRANSINTRSTRATEINSTR.COMPANYCODE == T001.BUKRS
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • P_FINTRANSINTRSTRATEINSTR.MANDT == CSKS.MANDT
  • P_FINTRANSINTRSTRATEINSTR.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_FINTRANSINTRSTRATEINSTR.[column in domain "DATBI"] == CSKS.DATBI
  • P_FINTRANSINTRSTRATEINSTR.COSTCENTER == CSKS.KOSTL
Financial Instrument Product Category P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Client
  • Financial Instrument Transaction Type
  • Product Type
  • P_FINTRANSINTRSTRATEINSTR.MANDT == AT10.MANDT
  • P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
Transaction type
  • Client
  • Product Type
  • P_FINTRANSINTRSTRATEINSTR.MANDT == TZPA.MANDT
  • P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Transaction Category
  • Financial Instrument Product Category
  • Transaction Category
  • P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == AT01.SANLFOR
  • P_FINTRANSINTRSTRATEINSTR.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
Factory calendar P_FINTRANSINTRSTRATEINSTR.FINTRANSFACTORYCALENDAR1 == TFACD.IDENT
Factory calendar P_FINTRANSINTRSTRATEINSTR.FINTRANSFACTORYCALENDAR2 == TFACD.IDENT
Processing Category
  • Processing Category
  • Financial Instrument Product Category
  • Transaction Category
  • P_FINTRANSINTRSTRATEINSTR.FINTRANSPROCESSINGCATEGORY == AT05.ABWTYP
  • P_FINTRANSINTRSTRATEINSTR.FINANCIALINSTRPRODUCTCATEGORY == AT05.SANLF
  • P_FINTRANSINTRSTRATEINSTR.FININSTRTRANSACTIONCATEGORY == AT05.SFGTYP
Hedging Classification
  • Hedging Classification
  • Client
  • P_FINTRANSINTRSTRATEINSTR.HEDGINGCLASSIFICATION == TOEC_CLASS.HEDGING_CLASSIFICATION
  • P_FINTRANSINTRSTRATEINSTR.MANDT == TOEC_CLASS.CLIENT
Portfolio
  • Client
  • Company Code
  • Portfolio
  • P_FINTRANSINTRSTRATEINSTR.MANDT == TWPOB.MANDT
  • P_FINTRANSINTRSTRATEINSTR.COMPANYCODE == TWPOB.BUKRS
  • P_FINTRANSINTRSTRATEINSTR.PORTFOLIO == TWPOB.RPORTB
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • P_FINTRANSINTRSTRATEINSTR.MANDT == CEPC.MANDT
  • P_FINTRANSINTRSTRATEINSTR.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_FINTRANSINTRSTRATEINSTR.[column in domain "DATBI"] == CEPC.DATBI
  • P_FINTRANSINTRSTRATEINSTR.PROFITCENTER == CEPC.PRCTR
Transaction Currency
  • Transaction Currency
  • Client
  • P_FINTRANSINTRSTRATEINSTR.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FINTRANSINTRSTRATEINSTR.MANDT == TCURC.MANDT
Transaction Number of Facility
  • Company Code of Facility
  • Transaction Number of Facility
  • Client
  • P_FINTRANSINTRSTRATEINSTR.TREASURYFACILITYCOMPANYCODE == VTBFHA.BUKRS
  • P_FINTRANSINTRSTRATEINSTR.TREASURYFACILITY == VTBFHA.RFHA
  • P_FINTRANSINTRSTRATEINSTR.MANDT == VTBFHA.MANDT
Company Code of Facility
  • Company Code of Facility
  • Client
  • P_FINTRANSINTRSTRATEINSTR.TREASURYFACILITYCOMPANYCODE == T001.BUKRS
  • P_FINTRANSINTRSTRATEINSTR.MANDT == T001.MANDT
General Valuation Class
  • General Valuation Class
  • Client