1. Home
  2. Resources
  3. SAP Tables
  4. VTBFHA - Transaction

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
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
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
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
0 Active
1 Concluded
2 Replaced
3 Reversed
4 Offer
5 Simulation
6 Old Transaction - No Editing Possible
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
1 Sale amount was traded
2 Purchase amount was traded
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
X Yes
NULL No
AKUEND Period of Notice TB_AKUEND NUMC 2 0
SKUEND Unit of Period of Notice TB_SKUEND NUMC 1 0
0 Days
1 Months
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
NULL Start inclusive
X End inclusive
SNPVCAL NPV Calculation TB_SNPVCAL CHAR 1 0
NULL Yield
X Discount
SRNDNG Rounding of Amount from Generated Flows TB_SRNDNG CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
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
NULL Release Not Checked
1 Release Not Required
2 Release Required
3 Release Granted
4 Release Rejected
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
0 Not Relevant
1 Central Clearing Optional
2 Central Clearing Mandatory
3 Central Clearing Already Occurred
CLEARING_STATUS Clearing Status (TREA) TPM_TREA_CLEARING_STATUS NUMC 1 0
0 Not Relevant for Clearing
1 Clearing Requested (Planned)
2 Clearing Accepted
3 Clearing Rejected
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
NULL Financial Transaction Is Not Based on a Condition
1 Financial Transaction Is Based on a Condition
RISK_MITIGATING Risk Mitigation Indicator FTR_THRESHOLD_RISK_MITIGATING CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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 ABWTYP AT05 Processing Categories ABWTYP
VTBFHA ABWTYP VTBFHA SANLF AT05 Processing Categories SANLF
VTBFHA ABWTYP VTBFHA SFGTYP AT05 Processing Categories SFGTYP
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 MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTBFHA COMMODITY_ID1 VTBFHA COMMODITY_ID1 TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
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 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 POSACC VTBFHA MANDT TRFT_POS_ACCOUNT Treasury: Futures Account Master Data MANDT
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 MANDT TWD01 Treasury: Securities Account Master Data MANDT
VTBFHA RLDEPO VTBFHA BUKRS TWD01 Treasury: Securities Account Master Data BUKRS
VTBFHA RLDEPO VTBFHA RLDEPO TWD01 Treasury: Securities Account Master Data RLDEPO
VTBFHA RMAID VTBFHA RMAID VTBMA Master Agreement RMAID
VTBFHA RMAID VTBFHA MANDT VTBMA Master Agreement MANDT
VTBFHA RPORTB VTBFHA RPORTB TWPOB Portfolio position RPORTB
VTBFHA RPORTB VTBFHA MANDT TWPOB Portfolio position MANDT
VTBFHA RPORTB VTBFHA BUKRS TWPOB Portfolio position BUKRS
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 MANDT T037S Account Assignment References acc. to Transaction Type MANDT
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 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 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 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 MANDT AT10 Transaction Types MANDT
VTBFHA SFHAART VTBFHA SGSART AT10 Transaction Types SGSART
VTBFHA SFHAART VTBFHA SFHAART AT10 Transaction Types SFHAART
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