1. Home
  2. Resources
  3. SAP Tables
  4. VTGFHA - TR Transaction Management: Transaction Display Structure

SAP Table VTGFHA

TR Transaction Management: Transaction Display Structure

VTGFHA (TR Transaction Management: Transaction Display Structure) 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 VTGFHA to other SAP tables.

VTGFHA 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
XBUKRS Name of Company Code or Company BUTXT CHAR 25 0
XGSART Name of product type TB_XGSART CHAR 30 0
XFHAART Name of Transaction Type TB_FATEXT CHAR 30 0
XABWTYP Name: Processing Category TB_XABRBEZ CHAR 60 0
SKUENDT Period of notice in days TM_SKUENDT CHAR 1 0
X Yes
NULL No
SKUENDM Period of notice in months TM_SKUENDM CHAR 1 0
X Yes
NULL No
XRFHA Financial transaction number TB_XRFHA CHAR 13 0
XAKTIV Active status: description TM_XAKTIV CHAR 60 0
XFRGZUST Transaction release: Release status TB_XFRGZUST CHAR 60 0
XKONTRH Name and address of business partner TB_XKONTRH CHAR 80 0
XGARANT Name and address of guarantor TB_XGARANT CHAR 80 0
SNOTE Memo exists TB_SNOTE CHAR 1 0
X Yes
NULL No
SINCLB Calculation Period: Start Inclusive - End Exclusive TB_SINCLBB CHAR 1 0
X Yes
NULL No
SINCLE Calculation Period: Start Exclusive - End Inclusive TB_SINCLEB CHAR 1 0
X Yes
NULL No
SNPVCALY NPV calculation via yield TB_SNPVCALY CHAR 1 0
X Yes
NULL No
SNPVCALD NPV calculation via discounting TB_SNPVCALD CHAR 1 0
X Yes
NULL No
SRNDNGB Round Up or Down to the Nearest Whole Number TB_SRNDNGB CHAR 1 0
X Yes
NULL No
SRNDNGD Round down TB_SRNDNGD CHAR 1 0
X Yes
NULL No
SRNDNGU Round up TB_SRNDNGU CHAR 1 0
X Yes
NULL No
BEGRUTXT Name of authorization group for financial transactions BEGRUTXT CHAR 50 0
XREFKONT Name of account assignment reference TB_XREFKONT CHAR 40 0
XREFKONT2 Name of account assignment reference 2 TB_XREFKONT2 CHAR 40 0
XPORTB Portfolio name VVXPORTB CHAR 30 0
SVALIDATED Checkbox XFELD CHAR 1 0
X Yes
NULL No
XALKZ Short name XALKZ CHAR 15 0
XALLB Long name XALLB CHAR 60 0
EXT_RFHA Financial Transaction TB_RFHA CHAR 13 0
XLDEPO Securities account ID XLDEPO CHAR 30 0
DBLFZ_LABEL Character Field Length = 10 CHAR10 CHAR 10 0
SMSG Messages Exist TB_SMSG CHAR 1 0
X Yes
NULL No
FMAREA Financial Management Area FIKRS CHAR 4 0
CLEARING_DATEX Planned Clearing Date TPM_TREA_CLEAR_DATE_TXT CHAR 10 0
CLEARING_INFO Char 80 CHAR80 CHAR 80 0
EXT_ACCOUNT_TEXT External Account Name TPM_EXT_ACC_TEXT CHAR 30 0

VTGFHA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTGFHA ABWTYP VTGFHA ABWTYP AT05 Processing Categories ABWTYP
VTGFHA ABWTYP VTGFHA SANLF AT05 Processing Categories SANLF
VTGFHA ABWTYP VTGFHA SFGTYP AT05 Processing Categories SFGTYP
VTGFHA BUKRS VTGFHA MANDT T001 Company Codes MANDT
VTGFHA BUKRS VTGFHA BUKRS T001 Company Codes BUKRS
VTGFHA COMMODITY_ID VTGFHA MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTGFHA COMMODITY_ID VTGFHA COMMODITY_ID TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTGFHA COMMODITY_ID1 VTGFHA MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTGFHA COMMODITY_ID1 VTGFHA COMMODITY_ID1 TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTGFHA COMMODITY_ID2 VTGFHA MANDT TRCOT_CTY_MASTER Commodity master data MANDT
VTGFHA COMMODITY_ID2 VTGFHA COMMODITY_ID2 TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
VTGFHA FACILITYBUKRS VTGFHA MANDT T001 Company Codes MANDT
VTGFHA FACILITYBUKRS VTGFHA FACILITYBUKRS T001 Company Codes BUKRS
VTGFHA FACILITYNR VTGFHA MANDT VTBFHA Transaction MANDT
VTGFHA FACILITYNR VTGFHA FACILITYBUKRS VTBFHA Transaction BUKRS
VTGFHA FACILITYNR VTGFHA FACILITYNR VTBFHA Transaction RFHA
VTGFHA MANDT VTGFHA MANDT T000 Clients MANDT
VTGFHA OBJNR VTGFHA MANDT ONR00 General Object Number MANDT
VTGFHA OBJNR VTGFHA OBJNR ONR00 General Object Number OBJNR
VTGFHA POSACC VTGFHA BUKRS TRFT_POS_ACCOUNT Treasury: Futures Account Master Data COMPANY_CODE
VTGFHA POSACC VTGFHA POSACC TRFT_POS_ACCOUNT Treasury: Futures Account Master Data POS_ACCOUNT
VTGFHA POSACC VTGFHA MANDT TRFT_POS_ACCOUNT Treasury: Futures Account Master Data MANDT
VTGFHA RCOMVALCL VTGFHA MANDT TRGC_COM_VALCL General valuation class MANDT
VTGFHA RCOMVALCL VTGFHA RCOMVALCL TRGC_COM_VALCL General valuation class COM_VAL_CLASS
VTGFHA RCOMVALCL2 VTGFHA MANDT TRGC_COM_VALCL General valuation class MANDT
VTGFHA RCOMVALCL2 VTGFHA RCOMVALCL2 TRGC_COM_VALCL General valuation class COM_VAL_CLASS
VTGFHA RLDEPO VTGFHA MANDT TWD01 Treasury: Securities Account Master Data MANDT
VTGFHA RLDEPO VTGFHA BUKRS TWD01 Treasury: Securities Account Master Data BUKRS
VTGFHA RLDEPO VTGFHA RLDEPO TWD01 Treasury: Securities Account Master Data RLDEPO
VTGFHA RMAID VTGFHA RMAID VTBMA Master Agreement RMAID
VTGFHA RMAID VTGFHA MANDT VTBMA Master Agreement MANDT
VTGFHA RPORTB VTGFHA RPORTB TWPOB Portfolio position RPORTB
VTGFHA RPORTB VTGFHA MANDT TWPOB Portfolio position MANDT
VTGFHA RPORTB VTGFHA BUKRS TWPOB Portfolio position BUKRS
VTGFHA RPORTB2 VTGFHA MANDT TWPOB Portfolio position MANDT
VTGFHA RPORTB2 VTGFHA BUKRS TWPOB Portfolio position BUKRS
VTGFHA RPORTB2 VTGFHA RPORTB2 TWPOB Portfolio position RPORTB
VTGFHA RREFKONT VTGFHA MANDT T037S Account Assignment References acc. to Transaction Type MANDT
VTGFHA RREFKONT VTGFHA BUKRS T037S Account Assignment References acc. to Transaction Type BUKRS
VTGFHA RREFKONT VTGFHA RANTYP T037S Account Assignment References acc. to Transaction Type RANTYP
VTGFHA RREFKONT VTGFHA RREFKONT T037S Account Assignment References acc. to Transaction Type RREFKONT
VTGFHA RREFKONT2 VTGFHA BUKRS T037S Account Assignment References acc. to Transaction Type BUKRS
VTGFHA RREFKONT2 VTGFHA RANTYP T037S Account Assignment References acc. to Transaction Type RANTYP
VTGFHA RREFKONT2 VTGFHA RREFKONT2 T037S Account Assignment References acc. to Transaction Type RREFKONT
VTGFHA RREFKONT2 VTGFHA MANDT T037S Account Assignment References acc. to Transaction Type MANDT
VTGFHA SANLF VTGFHA SANLF TZAF Product categories SANLF
VTGFHA SFGTYP VTGFHA SANLF AT01 Transaction Category SANLFOR
VTGFHA SFGTYP VTGFHA SFGTYP AT01 Transaction Category SFGTYP
VTGFHA SFHAART VTGFHA MANDT AT10 Transaction Types MANDT
VTGFHA SFHAART VTGFHA SGSART AT10 Transaction Types SGSART
VTGFHA SFHAART VTGFHA SFHAART AT10 Transaction Types SFHAART
VTGFHA SGSART VTGFHA MANDT TZPA Financial Assets Management Product Types MANDT
VTGFHA SGSART VTGFHA SGSART TZPA Financial Assets Management Product Types GSART
VTGFHA SKALID VTGFHA SKALID TFACD Factory calendar definition IDENT
VTGFHA SKALID2 VTGFHA SKALID2 TFACD Factory calendar definition IDENT
VTGFHA TBEGRU VTGFHA MANDT TRBRG Authorization Group for Treasury Transactions MANDT
VTGFHA TBEGRU VTGFHA TBEGRU TRBRG Authorization Group for Treasury Transactions TBEGRU
VTGFHA WGSCHFT VTGFHA MANDT TCURC Currency Codes MANDT
VTGFHA WGSCHFT VTGFHA WGSCHFT TCURC Currency Codes WAERS