I_FinancialTransaction

Financial Transaction | view: IFINTRAN | ATTR | 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
FinTransCentralClearingDate Planned Clearing Date
FinTransCntrlClrgActualDate Actual Clearing Date
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
FinTransCentralClearingOption Central Clearing Option (TREA) Show values
FinTransCentralClearingStatus Clearing Status (TREA) 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
SecurityClass Security Class WP_RANL
SecurityClassIntlScrtyIdnNmbr Security ID Number (ISIN) RANL_ISIN
ClassificationOfFinInstr CFI Code CHAR6
CentralClearingAccount External Account TPM_EXT_ACCOUNT
FinInstrLastActiveActivity Financial Instrument Last Active Activity T_RFHAZU
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_FINANCIALTRANSACTION.MANDT == TGSB.MANDT
  • I_FINANCIALTRANSACTION.BUSINESSAREA == TGSB.GSBER
Company code
  • Company Code
  • Client
  • I_FINANCIALTRANSACTION.COMPANYCODE == T001.BUKRS
  • I_FINANCIALTRANSACTION.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_FINANCIALTRANSACTION.CONTROLLINGAREA == TKA01.KOKRS
  • I_FINANCIALTRANSACTION.MANDT == TKA01.MANDT
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • I_FINANCIALTRANSACTION.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_FINANCIALTRANSACTION.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINANCIALTRANSACTION.MANDT == CSKS.MANDT
  • I_FINANCIALTRANSACTION.COSTCENTER == CSKS.KOSTL
Financial Instrument Product Category I_FINANCIALTRANSACTION.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Client
  • Product Type
  • Financial Instrument Transaction Type
  • I_FINANCIALTRANSACTION.MANDT == AT10.MANDT
  • I_FINANCIALTRANSACTION.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
  • I_FINANCIALTRANSACTION.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
Transaction type
  • Client
  • Product Type
  • I_FINANCIALTRANSACTION.MANDT == TZPA.MANDT
  • I_FINANCIALTRANSACTION.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Transaction Category
  • Financial Instrument Product Category
  • Transaction Category
  • I_FINANCIALTRANSACTION.FINANCIALINSTRPRODUCTCATEGORY == AT01.SANLFOR
  • I_FINANCIALTRANSACTION.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
Factory calendar I_FINANCIALTRANSACTION.FINTRANSFACTORYCALENDAR1 == TFACD.IDENT
Factory calendar I_FINANCIALTRANSACTION.FINTRANSFACTORYCALENDAR2 == TFACD.IDENT
Processing Category
  • Financial Instrument Product Category
  • Processing Category
  • Transaction Category
  • I_FINANCIALTRANSACTION.FINANCIALINSTRPRODUCTCATEGORY == AT05.SANLF
  • I_FINANCIALTRANSACTION.FINTRANSPROCESSINGCATEGORY == AT05.ABWTYP
  • I_FINANCIALTRANSACTION.FININSTRTRANSACTIONCATEGORY == AT05.SFGTYP
Futures Account for Listed Options and Futures
  • Company Code
  • Client
  • Futures Account for Listed Options and Futures
Hedging Classification
  • Client
  • Hedging Classification
  • I_FINANCIALTRANSACTION.MANDT == TOEC_CLASS.CLIENT
  • I_FINANCIALTRANSACTION.HEDGINGCLASSIFICATION == TOEC_CLASS.HEDGING_CLASSIFICATION
Portfolio
  • Company Code
  • Client
  • Portfolio
  • I_FINANCIALTRANSACTION.COMPANYCODE == TWPOB.BUKRS
  • I_FINANCIALTRANSACTION.MANDT == TWPOB.MANDT
  • I_FINANCIALTRANSACTION.PORTFOLIO == TWPOB.RPORTB
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • I_FINANCIALTRANSACTION.PROFITCENTER == CEPC.PRCTR
  • I_FINANCIALTRANSACTION.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_FINANCIALTRANSACTION.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINANCIALTRANSACTION.MANDT == CEPC.MANDT
Security Account
  • Company Code
  • Client
  • Security Account
  • I_FINANCIALTRANSACTION.COMPANYCODE == TWD01.BUKRS
  • I_FINANCIALTRANSACTION.MANDT == TWD01.MANDT
  • I_FINANCIALTRANSACTION.SECURITYACCOUNT == TWD01.RLDEPO
Transaction Currency
  • Transaction Currency
  • Client
  • I_FINANCIALTRANSACTION.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_FINANCIALTRANSACTION.MANDT == TCURC.MANDT
Transaction Number of Facility
  • Transaction Number of Facility
  • Client
  • Company Code of Facility
  • I_FINANCIALTRANSACTION.TREASURYFACILITY == VTBFHA.RFHA
  • I_FINANCIALTRANSACTION.MANDT == VTBFHA.MANDT
  • I_FINANCIALTRANSACTION.TREASURYFACILITYCOMPANYCODE == VTBFHA.BUKRS
Company Code of Facility
  • Client
  • Company Code of Facility
  • I_FINANCIALTRANSACTION.MANDT == T001.MANDT
  • I_FINANCIALTRANSACTION.TREASURYFACILITYCOMPANYCODE == T001.BUKRS
General Valuation Class
  • General Valuation Class
  • Client