VTBFHAZU

Transaction Activity | #transactional | Component: Transaction Manager
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RFHA FK Financial Transaction
RFHAZU Transaction Activity
Column Name Description
💲 Transaction Currency (VTBFHA.WGSCHFT):
NOM_UP_LIMIT Upper limit amount in payment currency
NOM_LOW_LIMIT Lower limit amount in payment currency
Column Name Description
Column Name Description
DCRDAT Entered On
TCRTIM Entry Time
DUPDAT Changed On
TUPTIM Time Changed
DVTRAB Contract Conclusion Date
TVTRAB Time of Contract Conclusion
DBLFZ Term Start
DELFZ Term End
DFIX Fixing Date
DZSTND Last activity transition date (e.g. for rollover)
DZNSSTD Payment date for deferred interest
LIMITDAT Limit Date
DEXDAT Confirmation Date
DREDAT Counterconfirmation Date
DORDER Order Date
DANST Reservation Date
TANST Order Time of Day
NOTICE_DATE OTC Notice Date
FORWARD_DATE Forward Date
PEFFZ_WORST_DT Yield to Worst End Date
Column Name Description
SAKTIV Active Status of Transaction or Activity Show values
SINCLE End of Term Inclusive Indicator Show values
SZNSPRO Interest Handling with Rollover Show values
RKONDGR Direction of Transaction Show values
SCONFIRM Confirmation Status Show values
SRECONFIRM Counterconfirmation Show values
SSPESEN Expenses Key Show values
SEFFMETH Effective Interest Method (Financial Mathematics) Show values
SNOTDELIVERED Security not delivered Show values
Column Name Description Domain name
CRUSER Entered By SYCHAR12
UPUSER Last Changed By SYCHAR12
ROFHAZU Previous Activity T_RFHAZU
RFHAZUX Previous activity, which is supplemented by current activity T_RFHAZU
GSPPART Contact Person TEXT19
XAKT File Number CHAR32
NORDEXT External Reference FTI_CHAR16LOW
KKURS Rate of Foreign Exchange Transaction TB_KKURS
KKASSA Spot Rate TB_KKURS
KSWAP Swap Rate T_SWKURS
KWLIQUI Liquidity Effect for Rollover T_SWKURS
UEXNAM Confirmation Executed By (User Responsible) USNAM
URENAM Counterconfirmation Executed by (User Responsible) USNAM
BUPRCLIM Limit Price for Unit Quotation VVPKTKUR
SRUNITLIM Currency Unit of the Rate VVSRUNIT
BPPRCLIM Limit Price for Percentage Quotation VVPKTKUR
JVERK6B Flag for Sale from Article 6b - Position CHAR1
PEFFZINS Effective Interest Rate DECV3_7
PEFFZINS_GIVEN Given Effective Interest Rate DECV3_7
PEFFZCALL Effective Interest Rate - Termination of Issuer DECV3_7
BPPRC_SPOT2 Spot Rate at Maturity in Percentage VVPKTKUR
BPPRC_SPOT1 Current Spot Rate in Percentage VVPKTKUR
BPPRC_MARG Margin Rate in Percentage DEC15_5DB4
COC_RATE Interest Rate for Cost of Carryforward TPM_TRR_AMOUNT
PEFFZ_WORST Yield to Worst DECV3_7
Master Data Relations Join Conditions
Company code
  • VTBFHAZU.MANDT == T001.MANDT
  • VTBFHAZU.BUKRS == T001.BUKRS
Fixing Reference ID
Limit Type
  • VTBFHAZU.MANDT == ATOR.MANDT
  • VTBFHAZU.LIMITART == ATOR.LIMITART
Reference Currency for Limit
  • VTBFHAZU.MANDT == TCURC.MANDT
  • VTBFHAZU.LIWAERS == TCURC.WAERS
vtbfhazu VTBFHAZU.MANDT == T000.MANDT
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • VTBFHAZU.BUKRS == VTBFHA.BUKRS
  • VTBFHAZU.MANDT == VTBFHA.MANDT
  • VTBFHAZU.RFHA == VTBFHA.RFHA
Rounding Rule
Reservation Reason
  • VTBFHAZU.MANDT == TW14.MANDT
  • VTBFHAZU.SANST == TW14.SANST
Transaction Activity Category
  • Transaction Activity Category
  • ?
  • ?
  • VTBFHAZU.SFGZUSTT == AT02.SFGZUSTT
  • VTBFHAZU.[column in domain "TB_SANLF"] == AT02.SANLFOR
  • VTBFHAZU.[column in domain "TB_SFGTYP"] == AT02.SFGTYP
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • Product Type
  • VTBFHAZU.SFHAART == AT10.SFHAART
  • VTBFHAZU.MANDT == AT10.MANDT
  • VTBFHAZU.SGSART == AT10.SGSART
Latest function used in editing activity VTBFHAZU.SFUNKTL == AT60.SFUNKTION
Transition Function from Directly Preceding Activity VTBFHAZU.SFUNKTV == AT60.SFUNKTION
Product type
  • Product Type
  • Client
  • VTBFHAZU.SGSART == TZPA.GSART
  • VTBFHAZU.MANDT == TZPA.MANDT
Reason for Reversal
  • VTBFHAZU.MANDT == TZST.MANDT
  • VTBFHAZU.SSTOGRD == TZST.SSTOGRD
Following Currency
  • Following Currency
  • Client
  • Leading Currency
  • VTBFHAZU.WFWAERS == TCURL.FWAERS
  • VTBFHAZU.MANDT == TCURL.MANDT
  • VTBFHAZU.WLWAERS == TCURL.LWAERS
Leading Currency
  • VTBFHAZU.MANDT == TCURC.MANDT
  • VTBFHAZU.WLWAERS == TCURC.WAERS
Time Zone of Contract Date and Time
  • VTBFHAZU.MANDT == TTZZ.CLIENT
  • VTBFHAZU.ZVTRAB == TTZZ.TZONE
Other Relations | to Master Data Relations ↑ Join Conditions
Trader / Back office clerk
  • Company Code
  • Trader
  • Client
  • VTBFHAZU.BUKRS == TZDEA.BUKRS
  • VTBFHAZU.RDEALER == TZDEA.RDEALER
  • VTBFHAZU.MANDT == TZDEA.MANDT