I_FinTransCurrentActivity

Financial Transaction Current Activity | view: IFTRCURRENTACT | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TLCT_ACTIVITYVTBFHAZUT001TKA02VTBFHA
Column Name Description
CompanyCode FK Company Code
FinancialTransaction FK Financial Transaction
FinancialInstrumentActivity Transaction Activity
Column Name Description
Column Name Description
Column Name Description
TermEndDate Term End
FinTransNoticeDate OTC Notice Date
FinTransActyConclusionDate Contract Conclusion Date
FinTransActyConclusionTime Time of Contract Conclusion
FinTransRolloverDate Term Start
FinTransExerciseDate Term End
FinTransOrderValidityEndDate Limit Date
FinTransFixingDate Fixing Date
FinTransConfirmationDate Confirmation Date
FinTransCntrconfDate Counterconfirmation Date
Column Name Description
TermEndDateIsInclusive End of Term Inclusive Indicator Show values
FinTransConfirmationStatus Confirmation Status Show values
FinTransCntrconfStatus Counterconfirmation Show values
EffectiveInterestMethod Effective Interest Method (Financial Mathematics) Show values
Column Name Description Domain name
FinancialInstrContactPerson Contact Person TEXT19
FinInstrExternalReference External Reference FTI_CHAR16LOW
FinTransConfirmedByUser Confirmation Executed By (User Responsible)
FinTransCntrconfCreatedByUser Counterconfirmation Executed by (User Responsible)
ExchangeRate Rate of Foreign Exchange Transaction TB_KKURS
SpotExchangeRate Spot Rate TB_KKURS
SwapExchangeRate Swap Rate T_SWKURS
EffectiveInterestRate Effective Interest Rate DECV3_7
LetterOfCredit Letter of Credit Number FTR_LC_NUMBER
TreasuryApplicant Applicant BU_PARTNER
TreasuryBeneficiary Beneficiary BU_PARTNER
TreasuryAdvisingBank Advising Bank BU_PARTNER
TreasuryIssuingBank Issuing Bank BU_PARTNER
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_FINTRANSCURRENTACTIVITY.COMPANYCODE == T001.BUKRS
  • I_FINTRANSCURRENTACTIVITY.MANDT == T001.MANDT
Transaction Activity Category
  • ?
  • ?
  • Transaction Activity Category
  • I_FINTRANSCURRENTACTIVITY.[column in domain "TB_SFGTYP"] == AT02.SFGTYP
  • I_FINTRANSCURRENTACTIVITY.[column in domain "TB_SANLF"] == AT02.SANLFOR
  • I_FINTRANSCURRENTACTIVITY.FINANCIALINSTRACTIVITYCATEGORY == AT02.SFGZUSTT
Financial Transaction
  • Financial Transaction
  • Company Code
  • Client
  • I_FINTRANSCURRENTACTIVITY.FINANCIALTRANSACTION == VTBFHA.RFHA
  • I_FINTRANSCURRENTACTIVITY.COMPANYCODE == VTBFHA.BUKRS
  • I_FINTRANSCURRENTACTIVITY.MANDT == VTBFHA.MANDT
Time Zone of Contract Date and Time
  • Client
  • Time Zone of Contract Date and Time
  • I_FINTRANSCURRENTACTIVITY.MANDT == TTZZ.CLIENT
  • I_FINTRANSCURRENTACTIVITY.FINTRANSACTYCONCLUSIONTIMEZONE == TTZZ.TZONE
Following Currency
  • Leading Currency
  • Client
  • Following Currency
  • I_FINTRANSCURRENTACTIVITY.LEADINGCURRENCY == TCURL.LWAERS
  • I_FINTRANSCURRENTACTIVITY.MANDT == TCURL.MANDT
  • I_FINTRANSCURRENTACTIVITY.FOLLOWINGCURRENCY == TCURL.FWAERS
Fixing Reference ID
  • Fixing Reference ID
  • Client
  • I_FINTRANSCURRENTACTIVITY.FOREIGNEXCHANGEFIXINGREFERENCE == FTRT_FIX_DEF.FIX_ID
  • I_FINTRANSCURRENTACTIVITY.MANDT == FTRT_FIX_DEF.MANDT
Leading Currency
  • Leading Currency
  • Client
  • I_FINTRANSCURRENTACTIVITY.LEADINGCURRENCY == TCURC.WAERS
  • I_FINTRANSCURRENTACTIVITY.MANDT == TCURC.MANDT
Reason for Reversal
  • Reason for Reversal
  • Client
  • I_FINTRANSCURRENTACTIVITY.TREASURYREVERSALREASON == TZST.SSTOGRD
  • I_FINTRANSCURRENTACTIVITY.MANDT == TZST.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Trader / Back office clerk
  • Trader
  • Company Code
  • Client
  • I_FINTRANSCURRENTACTIVITY.TRADER == TZDEA.RDEALER
  • I_FINTRANSCURRENTACTIVITY.COMPANYCODE == TZDEA.BUKRS
  • I_FINTRANSCURRENTACTIVITY.MANDT == TZDEA.MANDT