SAP Table VTBFHA
Transaction
VTBFHA (Transaction) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VTBFHA to other SAP tables.
VTBFHA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
RFHA
Financial Transaction
|
TB_RFHA |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
CRUSER
Entered by
|
TB_CRUSER |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
DCRDAT
Entered On
|
TB_DCRDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
TCRTIM
Entry Time
|
TB_TCRTIM |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||||||
|
UPUSER
Last Changed by
|
TB_UPUSER |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||||||||
|
DUPDAT
Changed on
|
TB_DUPDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
TUPTIM
Time changed
|
TB_TUPTIM |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||||||||||
|
RANTYP
Contract Type
|
RANTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SANLF
Product Category
|
SANLF | TZAF |
NUMC
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SFGTYP
Transaction Category
|
TB_SFGTYP | AT01 |
NUMC
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SGSART
Product Type
|
VVSART | TZPA |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SFHAART
Financial Transaction Type
|
TB_SFHAART | AT10 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
RGATT
Class
|
TI_RGATT |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
RMAID
Master Agreement
|
TB_RMAID | VTBMA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
RFHAZUNR
Number status of activity
|
TB_RFHAZUN |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||||||||||
|
RFHAZUL
Last Active Transaction Activity
|
TB_RFHAZUL |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||||||||||
|
SAKTIV
Active Status of Transaction or Activity
|
TB_SAKTIV |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
KONTRH
Business Partner Number
|
TB_KUNNR_NEW |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
SROLEXT
3-Byte field
|
CHAR3 |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||||||
|
RGARANT
Guarantor of Financial Transaction
|
TB_RGARANT_NEW |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
RREFKONT
Obsolete: Accnt Assignment Ref. in Fin. Assets Management
|
RREFKONT_OBSOLETE | T037S |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||||||||
|
RREFKONT2
Obsolete: Accnt Assignment Ref. in Fin. Assets Management
|
RREFKONT_OBSOLETE | T037S |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||||||||
|
RPORTB
Portfolio
|
RPORTB | TWPOB |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
WGSCHFT
Currency of transaction
|
TB_WGSCHFT | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||||||||
|
WGSCHFT1
Currency of Outgoing Side
|
TB_WGSCHF1 |
CUKY
|
5 | 0 | ||||||||||||||||||||||||||||||||||
|
WGSCHFT2
Currency of Incoming Side
|
TB_WGSCHF2 |
CUKY
|
5 | 0 | ||||||||||||||||||||||||||||||||||
|
AMTINPUT
Note field for traded amount forex transactions
|
TB_AMTIN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
DBLFZ
Term Start
|
TB_DBLFZ |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
SKALID
Factory calendar
|
SKALID | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
SKALID2
Factory calendar
|
SKALID | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||||||||
|
JLIMIT
Limit indicator
|
TB_JLIMIT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
AKUEND
Period of Notice
|
TB_AKUEND |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
SKUEND
Unit of Period of Notice
|
TB_SKUEND |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||||||||||||||||||||||||
|
RLDEPO
Securities Account
|
VRLDEPO | TWD01 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
ZUONR
Finance Project
|
TB_TFPROJ |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
DELFZ
Term End
|
TB_DELFZ |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
ABWTYP
Processing Category
|
TB_ABWTYP | AT05 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||||||||
|
TBEGRU
Authorization Group
|
TBEGRU | TRBRG |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
VRFHA
Reference transaction (Rollover/premature settlement)
|
TB_VORFHA |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
SINCLBE
Calculation Period: Start Inclusive vs. End Inclusive
|
TB_SINCLBE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SNPVCAL
NPV Calculation
|
TB_SNPVCAL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SRNDNG
Rounding of Amount from Generated Flows
|
TB_SRNDNG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
ZUOND
Assignment
|
TB_ZUOND |
CHAR
|
18 | 0 | ||||||||||||||||||||||||||||||||||
|
REFER
Internal Reference
|
TB_REFER |
CHAR
|
16 | 0 | ||||||||||||||||||||||||||||||||||
|
MERKM
Characteristics
|
TB_MERKM |
CHAR
|
25 | 0 | ||||||||||||||||||||||||||||||||||
|
SFRGZUST
Transaction Release: Release Status
|
TB_FRGZUST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
RANL
Security ID Number
|
VVRANLW |
CHAR
|
13 | 0 | ||||||||||||||||||||||||||||||||||
|
RCOMVALCL
General Valuation Class
|
TPM_COM_VAL_CLASS | TRGC_COM_VALCL |
NUMC
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
FACILITYNR
Transaction Number of Facility
|
TB_FACILITYNR | VTBFHA |
CHAR
|
13 | 0 | |||||||||||||||||||||||||||||||||
|
FACILITYBUKRS
Company Code of Facility
|
TB_FACILITYBUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
POSACC
Futures Account for Listed Options and Futures
|
TPM_POS_ACCOUNT_FUT | TRFT_POS_ACCOUNT |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
RCOMVALCL2
General Valuation Class
|
TPM_COM_VAL_CLASS | TRGC_COM_VALCL |
NUMC
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
FUND
Fund
|
FM_FUND |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||||||||||||||||||||||
|
TIMESTAMP_DEAL
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||||||||||||||||||||||
|
COMMODITY_ID
Commodity ID
|
TRCO_COMM_ID | TRCOT_CTY_MASTER |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||||||
|
RPORTB2
Portfolio
|
RPORTB | TWPOB |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
COMMODITY_ID1
Commodity ID
|
TRCO_COMM_ID | TRCOT_CTY_MASTER |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||||||
|
COMMODITY_ID2
Commodity ID
|
TRCO_COMM_ID | TRCOT_CTY_MASTER |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||||||||
|
CLEARING_OPTION
Central Clearing Option (TREA)
|
TPM_TREA_CLEARING_OPT |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
CLEARING_STATUS
Clearing Status (TREA)
|
TPM_TREA_CLEARING_STATUS |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
CLEARING_DATE
Planned Clearing Date
|
TPM_TREA_CLEARING_DATE |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
EXT_ACCOUNT
External Account
|
TPM_EXT_ACCOUNT |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
CLEAR_DATE_ACT
Actual Clearing Date
|
TPM_TREA_CLEARING_DATE_ACT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||||||||
|
SCONDITION
Indicates Whether Financial Trans. Is Based on a Condition
|
FTR_CONDITION_USED |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
RISK_MITIGATING
Risk Mitigation Indicator
|
FTR_THRESHOLD_RISK_MITIGATING |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
EBELN
Purchasing Document Number
|
EBELN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
VBELN
Sales Document
|
VBELN_VA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||||||||
|
EBELP
Item Number of Purchasing Document
|
EBELP |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||||||||||
|
VBELP
Sales document item
|
VBELP |
NUMC
|
6 | 0 | ||||||||||||||||||||||||||||||||||
VTBFHA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VTBFHA | ABWTYP | VTBFHA | SANLF |
AT05
Processing Categories
|
SANLF |
| VTBFHA | ABWTYP | VTBFHA | SFGTYP |
AT05
Processing Categories
|
SFGTYP |
| VTBFHA | ABWTYP | VTBFHA | ABWTYP |
AT05
Processing Categories
|
ABWTYP |
| VTBFHA | BUKRS | VTBFHA | MANDT |
T001
Company Codes
|
MANDT |
| VTBFHA | BUKRS | VTBFHA | BUKRS |
T001
Company Codes
|
BUKRS |
| VTBFHA | COMMODITY_ID | VTBFHA | MANDT |
TRCOT_CTY_MASTER
Commodity master data
|
MANDT |
| VTBFHA | COMMODITY_ID | VTBFHA | COMMODITY_ID |
TRCOT_CTY_MASTER
Commodity master data
|
COMMODITY_ID |
| VTBFHA | COMMODITY_ID1 | VTBFHA | COMMODITY_ID1 |
TRCOT_CTY_MASTER
Commodity master data
|
COMMODITY_ID |
| VTBFHA | COMMODITY_ID1 | VTBFHA | MANDT |
TRCOT_CTY_MASTER
Commodity master data
|
MANDT |
| VTBFHA | COMMODITY_ID2 | VTBFHA | MANDT |
TRCOT_CTY_MASTER
Commodity master data
|
MANDT |
| VTBFHA | COMMODITY_ID2 | VTBFHA | COMMODITY_ID2 |
TRCOT_CTY_MASTER
Commodity master data
|
COMMODITY_ID |
| VTBFHA | FACILITYBUKRS | VTBFHA | MANDT |
T001
Company Codes
|
MANDT |
| VTBFHA | FACILITYBUKRS | VTBFHA | FACILITYBUKRS |
T001
Company Codes
|
BUKRS |
| VTBFHA | FACILITYNR | VTBFHA | MANDT |
VTBFHA
Transaction
|
MANDT |
| VTBFHA | FACILITYNR | VTBFHA | FACILITYBUKRS |
VTBFHA
Transaction
|
BUKRS |
| VTBFHA | FACILITYNR | VTBFHA | FACILITYNR |
VTBFHA
Transaction
|
RFHA |
| VTBFHA | MANDT | VTBFHA | MANDT |
T000
Clients
|
MANDT |
| VTBFHA | OBJNR | VTBFHA | MANDT |
ONR00
General Object Number
|
MANDT |
| VTBFHA | OBJNR | VTBFHA | OBJNR |
ONR00
General Object Number
|
OBJNR |
| VTBFHA | POSACC | VTBFHA | MANDT |
TRFT_POS_ACCOUNT
Treasury: Futures Account Master Data
|
MANDT |
| VTBFHA | POSACC | VTBFHA | BUKRS |
TRFT_POS_ACCOUNT
Treasury: Futures Account Master Data
|
COMPANY_CODE |
| VTBFHA | POSACC | VTBFHA | POSACC |
TRFT_POS_ACCOUNT
Treasury: Futures Account Master Data
|
POS_ACCOUNT |
| VTBFHA | RCOMVALCL | VTBFHA | MANDT |
TRGC_COM_VALCL
General valuation class
|
MANDT |
| VTBFHA | RCOMVALCL | VTBFHA | RCOMVALCL |
TRGC_COM_VALCL
General valuation class
|
COM_VAL_CLASS |
| VTBFHA | RCOMVALCL2 | VTBFHA | MANDT |
TRGC_COM_VALCL
General valuation class
|
MANDT |
| VTBFHA | RCOMVALCL2 | VTBFHA | RCOMVALCL2 |
TRGC_COM_VALCL
General valuation class
|
COM_VAL_CLASS |
| VTBFHA | RLDEPO | VTBFHA | BUKRS |
TWD01
Treasury: Securities Account Master Data
|
BUKRS |
| VTBFHA | RLDEPO | VTBFHA | RLDEPO |
TWD01
Treasury: Securities Account Master Data
|
RLDEPO |
| VTBFHA | RLDEPO | VTBFHA | MANDT |
TWD01
Treasury: Securities Account Master Data
|
MANDT |
| VTBFHA | RMAID | VTBFHA | MANDT |
VTBMA
Master Agreement
|
MANDT |
| VTBFHA | RMAID | VTBFHA | RMAID |
VTBMA
Master Agreement
|
RMAID |
| VTBFHA | RPORTB | VTBFHA | MANDT |
TWPOB
Portfolio position
|
MANDT |
| VTBFHA | RPORTB | VTBFHA | BUKRS |
TWPOB
Portfolio position
|
BUKRS |
| VTBFHA | RPORTB | VTBFHA | RPORTB |
TWPOB
Portfolio position
|
RPORTB |
| VTBFHA | RPORTB2 | VTBFHA | MANDT |
TWPOB
Portfolio position
|
MANDT |
| VTBFHA | RPORTB2 | VTBFHA | BUKRS |
TWPOB
Portfolio position
|
BUKRS |
| VTBFHA | RPORTB2 | VTBFHA | RPORTB2 |
TWPOB
Portfolio position
|
RPORTB |
| VTBFHA | RREFKONT | VTBFHA | BUKRS |
T037S
Account Assignment References acc. to Transaction Type
|
BUKRS |
| VTBFHA | RREFKONT | VTBFHA | RANTYP |
T037S
Account Assignment References acc. to Transaction Type
|
RANTYP |
| VTBFHA | RREFKONT | VTBFHA | RREFKONT |
T037S
Account Assignment References acc. to Transaction Type
|
RREFKONT |
| VTBFHA | RREFKONT | VTBFHA | MANDT |
T037S
Account Assignment References acc. to Transaction Type
|
MANDT |
| VTBFHA | RREFKONT2 | VTBFHA | RREFKONT2 |
T037S
Account Assignment References acc. to Transaction Type
|
RREFKONT |
| VTBFHA | RREFKONT2 | VTBFHA | MANDT |
T037S
Account Assignment References acc. to Transaction Type
|
MANDT |
| VTBFHA | RREFKONT2 | VTBFHA | BUKRS |
T037S
Account Assignment References acc. to Transaction Type
|
BUKRS |
| VTBFHA | RREFKONT2 | VTBFHA | RANTYP |
T037S
Account Assignment References acc. to Transaction Type
|
RANTYP |
| VTBFHA | SANLF | VTBFHA | SANLF |
TZAF
Product categories
|
SANLF |
| VTBFHA | SFGTYP | VTBFHA | SANLF |
AT01
Transaction Category
|
SANLFOR |
| VTBFHA | SFGTYP | VTBFHA | SFGTYP |
AT01
Transaction Category
|
SFGTYP |
| VTBFHA | SFHAART | VTBFHA | SGSART |
AT10
Transaction Types
|
SGSART |
| VTBFHA | SFHAART | VTBFHA | SFHAART |
AT10
Transaction Types
|
SFHAART |
| VTBFHA | SFHAART | VTBFHA | MANDT |
AT10
Transaction Types
|
MANDT |
| VTBFHA | SGSART | VTBFHA | MANDT |
TZPA
Financial Assets Management Product Types
|
MANDT |
| VTBFHA | SGSART | VTBFHA | SGSART |
TZPA
Financial Assets Management Product Types
|
GSART |
| VTBFHA | SKALID | VTBFHA | SKALID |
TFACD
Factory calendar definition
|
IDENT |
| VTBFHA | SKALID2 | VTBFHA | SKALID2 |
TFACD
Factory calendar definition
|
IDENT |
| VTBFHA | TBEGRU | VTBFHA | MANDT |
TRBRG
Authorization Group for Treasury Transactions
|
MANDT |
| VTBFHA | TBEGRU | VTBFHA | TBEGRU |
TRBRG
Authorization Group for Treasury Transactions
|
TBEGRU |
| VTBFHA | WGSCHFT | VTBFHA | MANDT |
TCURC
Currency Codes
|
MANDT |
| VTBFHA | WGSCHFT | VTBFHA | WGSCHFT |
TCURC
Currency Codes
|
WAERS |