P_Ftr_Vtbfha

vtbfha table | view: PFTRVTBFHA | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: VTBFHA
Column Name Description
bukrs FK Company Code
rfha Financial Transaction
Column Name Description
Column Name Description
Column Name Description
dcrdat Entered On
tcrtim Entry Time
dupdat Changed On
tuptim Time Changed
dblfz Term Start
delfz Term End
clearing_date Planned Clearing Date
clear_date_act Actual Clearing Date
Column Name Description
rantyp Contract Type Show values
saktiv Active Status of Transaction or Activity Show values
amtinput Indicator Field for Traded Amount in FX Transactions Show values
jlimit Limit Indicator Show values
skuend Unit of Period of Notice Show values
sinclbe Calculation Period: Start Inclusive vs. End Inclusive Show values
snpvcal NPV Calculation Show values
srndng Rounding of Amount from Generated Flows Show values
sfrgzust Transaction Release: Release Status Show values
clearing_option Central Clearing Option (TREA) Show values
clearing_status Clearing Status (TREA) Show values
scondition Indicates Whether Financial Trans. Is Based on a Condition Show values
risk_mitigating Risk Mitigation Indicator Show values
fima_calculation Cash Flow Calculation Show values
Column Name Description Domain name
cruser Entered By SYCHAR12
upuser Last Changed By SYCHAR12
rgatt Class T_RGATT
rfhazunr Number Status of Activity T_RFHAZU
rfhazul Last Active Transaction Activity T_RFHAZU
kontrh Business Partner Number BU_PARTNER
srolext 3-Byte field CHAR3
rgarant Guarantor of Financial Transaction BU_PARTNER
akuend Period of Notice T_AKUEND
zuonr Finance Project T_TFPROJ
vrfha Reference Transaction (Rollover/Premature Settlement) T_RFHA
zuond Assignment TEXT18
refer Internal Reference CHAR16
merkm Characteristics CHAR25
ranl Security Class ID Number WP_RANL
fund Fund BP_GEBER
grant_nbr Grant GM_GRANT_NBR
timestamp_deal UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ext_account External Account TPM_EXT_ACCOUNT
trustee Trustee Number BU_PARTNER
Master Data Relations Join Conditions
Processing Category
  • Product Category
  • Processing Category
  • Transaction Category
  • P_FTR_VTBFHA.SANLF == AT05.SANLF
  • P_FTR_VTBFHA.ABWTYP == AT05.ABWTYP
  • P_FTR_VTBFHA.SFGTYP == AT05.SFGTYP
Company code
  • Company Code
  • Client
  • P_FTR_VTBFHA.BUKRS == T001.BUKRS
  • P_FTR_VTBFHA.MANDT == T001.MANDT
Company Code of Facility
  • Company Code of Facility
  • Client
  • P_FTR_VTBFHA.FACILITYBUKRS == T001.BUKRS
  • P_FTR_VTBFHA.MANDT == T001.MANDT
Transaction Number of Facility
  • Transaction Number of Facility
  • Company Code of Facility
  • Client
  • P_FTR_VTBFHA.FACILITYNR == VTBFHA.RFHA
  • P_FTR_VTBFHA.FACILITYBUKRS == VTBFHA.BUKRS
  • P_FTR_VTBFHA.MANDT == VTBFHA.MANDT
Futures Account for Listed Options and Futures
  • Futures Account for Listed Options and Futures
  • Company Code
  • Client
General Valuation Class
  • General Valuation Class
  • Client
General Valuation Class
  • Client
  • General Valuation Class
Securities Account
  • Securities Account
  • Company Code
  • Client
  • P_FTR_VTBFHA.RLDEPO == TWD01.RLDEPO
  • P_FTR_VTBFHA.BUKRS == TWD01.BUKRS
  • P_FTR_VTBFHA.MANDT == TWD01.MANDT
Master Agreement
  • Master Agreement
  • Client
  • P_FTR_VTBFHA.RMAID == VTBMA.RMAID
  • P_FTR_VTBFHA.MANDT == VTBMA.MANDT
Portfolio
  • Company Code
  • Portfolio
  • Client
  • P_FTR_VTBFHA.BUKRS == TWPOB.BUKRS
  • P_FTR_VTBFHA.RPORTB == TWPOB.RPORTB
  • P_FTR_VTBFHA.MANDT == TWPOB.MANDT
Portfolio
  • Portfolio
  • Company Code
  • Client
  • P_FTR_VTBFHA.RPORTB2 == TWPOB.RPORTB
  • P_FTR_VTBFHA.BUKRS == TWPOB.BUKRS
  • P_FTR_VTBFHA.MANDT == TWPOB.MANDT
Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • Company Code
  • Client
  • Contract Type
  • Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • P_FTR_VTBFHA.BUKRS == T037S.BUKRS
  • P_FTR_VTBFHA.MANDT == T037S.MANDT
  • P_FTR_VTBFHA.RANTYP == T037S.RANTYP
  • P_FTR_VTBFHA.RREFKONT == T037S.RREFKONT
Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • Company Code
  • Client
  • Contract Type
  • Obsolete: Accnt Assignment Ref. in Fin. Assets Management
  • P_FTR_VTBFHA.BUKRS == T037S.BUKRS
  • P_FTR_VTBFHA.MANDT == T037S.MANDT
  • P_FTR_VTBFHA.RANTYP == T037S.RANTYP
  • P_FTR_VTBFHA.RREFKONT2 == T037S.RREFKONT
Product Category P_FTR_VTBFHA.SANLF == TZAF.SANLF
Transaction Category
  • Product Category
  • Transaction Category
  • P_FTR_VTBFHA.SANLF == AT01.SANLFOR
  • P_FTR_VTBFHA.SFGTYP == AT01.SFGTYP
Financial Transaction Type
  • Product Type
  • Client
  • Financial Transaction Type
  • P_FTR_VTBFHA.SGSART == AT10.SGSART
  • P_FTR_VTBFHA.MANDT == AT10.MANDT
  • P_FTR_VTBFHA.SFHAART == AT10.SFHAART
Transaction type
  • Product Type
  • Client
  • P_FTR_VTBFHA.SGSART == TZPA.GSART
  • P_FTR_VTBFHA.MANDT == TZPA.MANDT
Factory calendar P_FTR_VTBFHA.SKALID == TFACD.IDENT
Factory calendar P_FTR_VTBFHA.SKALID2 == TFACD.IDENT
Authorization Group
  • Authorization Group
  • Client
  • P_FTR_VTBFHA.TBEGRU == TRBRG.TBEGRU
  • P_FTR_VTBFHA.MANDT == TRBRG.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_FTR_VTBFHA.WGSCHFT == TCURC.WAERS
  • P_FTR_VTBFHA.MANDT == TCURC.MANDT