SAP table VTGFHA (TR Transaction Management: Transaction Display Structure)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
RFHA Financial Transaction CHAR 13 0 * TB_RFHA
CRUSER Entered By CHAR 12 0 TB_CRUSER
DCRDAT Entered On DATS 8 0 TB_DCRDAT
TCRTIM Entry Time TIMS 6 0 TB_TCRTIM
UPUSER Last Changed By CHAR 12 0 TB_UPUSER
DUPDAT Changed On DATS 8 0 TB_DUPDAT
TUPTIM Time Changed TIMS 6 0 TB_TUPTIM
RANTYP Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
SANLF Product Category NUMC 3 0 TZAF SANLF
SFGTYP Transaction Category NUMC 3 0 AT01 TB_SFGTYP
SGSART Product Type CHAR 3 0 TZPA VVSART
SFHAART Financial Transaction Type CHAR 3 0 AT10 TB_SFHAART
RGATT Class CHAR 13 0 TI_RGATT
RMAID Master Agreement CHAR 10 0 VTBMA TB_RMAID
RFHAZUNR Number Status of Activity NUMC 5 0 TB_RFHAZUN
RFHAZUL Last Active Transaction Activity NUMC 5 0 TB_RFHAZUL
SAKTIV Active Status of Transaction or Activity NUMC 1 0 TB_SAKTIV
KONTRH Business Partner Number CHAR 10 0 * TB_KUNNR_NEW
SROLEXT 3-Byte field CHAR 3 0 CHAR3
RGARANT Guarantor of Financial Transaction CHAR 10 0 TB_RGARANT_NEW
RREFKONT Obsolete: Accnt Assignment Ref. in Fin. Assets Management CHAR 8 0 T037S RREFKONT_OBSOLETE
RREFKONT2 Obsolete: Accnt Assignment Ref. in Fin. Assets Management CHAR 8 0 T037S RREFKONT_OBSOLETE
RPORTB Portfolio CHAR 10 0 TWPOB RPORTB
WGSCHFT Transaction Currency CUKY 5 0 TCURC TB_WGSCHFT
WGSCHFT1 Currency of Outgoing Side CUKY 5 0 * TB_WGSCHF1
WGSCHFT2 Currency of Incoming Side CUKY 5 0 * TB_WGSCHF2
AMTINPUT Indicator Field for Traded Amount in FX Transactions CHAR 1 0 TB_AMTIN
DBLFZ Term Start DATS 8 0 TB_DBLFZ
SKALID Factory calendar CHAR 2 0 TFACD SKALID
SKALID2 Factory calendar CHAR 2 0 TFACD SKALID
JLIMIT Limit Indicator CHAR 1 0 TB_JLIMIT
AKUEND Period of Notice NUMC 3 0 TB_AKUEND
SKUEND Unit of Period of Notice NUMC 1 0 TB_SKUEND
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
RLDEPO Securities Account CHAR 10 0 TWD01 VRLDEPO
ZUONR Finance Project CHAR 13 0 TB_TFPROJ
DELFZ Term End DATS 8 0 TB_DELFZ
ABWTYP Processing Category CHAR 5 0 AT05 TB_ABWTYP
TBEGRU Authorization Group CHAR 4 0 TRBRG TBEGRU
VRFHA Reference Transaction (Rollover/Premature Settlement) CHAR 13 0 * TB_VORFHA
SINCLBE Calculation Period: Start Inclusive vs. End Inclusive CHAR 1 0 TB_SINCLBE
SNPVCAL NPV Calculation CHAR 1 0 TB_SNPVCAL
SRNDNG Rounding of Amount from Generated Flows CHAR 1 0 TB_SRNDNG
ZUOND Assignment CHAR 18 0 TB_ZUOND
REFER Internal Reference CHAR 16 0 TB_REFER
MERKM Characteristics CHAR 25 0 TB_MERKM
SFRGZUST Transaction Release: Release Status CHAR 1 0 TB_FRGZUST
RANL Security Class ID Number CHAR 13 0 VVRANLW
RCOMVALCL General Valuation Class NUMC 4 0 TRGC_COM_VALCL TPM_COM_VAL_CLASS
FACILITYNR Transaction Number of Facility CHAR 13 0 VTBFHA TB_FACILITYNR
FACILITYBUKRS Company Code of Facility CHAR 4 0 T001 TB_FACILITYBUKRS
POSACC Futures Account for Listed Options and Futures CHAR 10 0 TRFT_POS_ACCOUNT TPM_POS_ACCOUNT_FUT
RCOMVALCL2 General Valuation Class NUMC 4 0 TRGC_COM_VALCL TPM_COM_VAL_CLASS
FUND Fund CHAR 10 0 * FM_FUND
GRANT_NBR Grant CHAR 20 0 * GM_GRANT_NBR
TIMESTAMP_DEAL UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
COMMODITY_ID Commodity ID (obsolete) CHAR 18 0 TRCOT_CTY_MASTER TRCO_COMM_ID
RPORTB2 Portfolio CHAR 10 0 TWPOB RPORTB
COMMODITY_ID1 Commodity ID (obsolete) CHAR 18 0 TRCOT_CTY_MASTER TRCO_COMM_ID
COMMODITY_ID2 Commodity ID (obsolete) CHAR 18 0 TRCOT_CTY_MASTER TRCO_COMM_ID
CLEARING_OPTION Central Clearing Option (TREA) NUMC 1 0 TPM_TREA_CLEARING_OPT
0 Not Relevant
1 Central Clearing Optional
2 Central Clearing Mandatory
3 Central Clearing Already Occurred
CLEARING_STATUS Clearing Status (TREA) NUMC 1 0 TPM_TREA_CLEARING_STATUS
0 Not Relevant for Clearing
1 Clearing Requested (Planned)
2 Clearing Accepted
3 Clearing Rejected
CLEARING_DATE Planned Clearing Date DATS 8 0 TPM_TREA_CLEARING_DATE
EXT_ACCOUNT External Account CHAR 10 0 TPM_EXT_ACCOUNT
CLEAR_DATE_ACT Actual Clearing Date DATS 8 0 TPM_TREA_CLEARING_DATE_ACT
SCONDITION Indicates Whether Financial Trans. Is Based on a Condition CHAR 1 0 FTR_CONDITION_USED
Financial Transaction Is Not Based on a Condition
1 Financial Transaction Is Based on a Condition
RISK_MITIGATING Risk Mitigation Indicator CHAR 1 0 FTR_THRESHOLD_RISK_MITIGATING
FIMA_CALCULATION Cash Flow Calculation CHAR 2 0 TB_FIMA_CALCULATION
Old FIMA with Single Condition
1 New FIMA with Parallel Conditions
2 New FIMA with Parallel Conditions and Group Condition
TRUSTEE Trustee Number CHAR 10 0 * FTR_TRUSTEE
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
RCNTR Cost Center CHAR 10 0 CSKS KOSTL
PS_POSID Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
RBUSA Business Area CHAR 4 0 TGSB GSBER
HEDGE_CLASS Hedging Classification CHAR 5 0 TOEC_CLASS TOE_HEDGING_CLASSIFICATION
INIT_CLASSIFIER Initial Stage Value CHAR 10 0 TRPA_INITIAL_STAGE
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
FB_SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
BEHALF_OF_COMPANY On Behalf of Company Code CHAR 4 0 T001 TRBA_BEHALF_OF_COMPANY
TRADED_CURRENCY Traded Currency CUKY 5 0 * FTR_TRADED_CURR
HEDGE_REQUEST_ID Hedge Request ID CHAR 13 0 TOE_REQUEST_ID
CFI_CODE CFI Code CHAR 6 0 FTR_CFI_CODE
ISIN Security ID Number (ISIN) CHAR 12 0 RANL_ISIN
MIC Market Identifier Code CHAR 4 0 TBAC_MIC TBA_MIC
CONTRACT_TIMESTAMP_UTC Contract Timestamp in UTC DEC 21 7 FTR_CONTRACT_TIMESTAMP_UTC
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
FKBER Functional Area CHAR 16 0 TFKB FKBER
PRICEINDEX_USED Indicator: Index calculation can be used CHAR 1 0 TB_INDEX_ON
Price Index is not used
X Price Index Applied on Interest
Y Price Index Applied on Interest and Repayments
FLOWUUID_ACTIVE Flow UUID Active CHAR 1 0 TB_FLOWUUID_ACTIVE
FLOWUUID not set as REF_FLOWUUID for derived flows
X FLOWUUID set as REF_FLOWUUID for derived flows
XBUKRS Name of Company Code or Company CHAR 25 0 BUTXT
XGSART Name of Product Type CHAR 30 0 TB_XGSART
XFHAART Name of Transaction Type CHAR 30 0 TB_FATEXT
XABWTYP Name: Processing Category CHAR 60 0 TB_XABRBEZ
SKUENDT Period of notice in days CHAR 1 0 TM_SKUENDT
SKUENDM Period of notice in months CHAR 1 0 TM_SKUENDM
XRFHA Financial Transaction Number CHAR 13 0 TB_XRFHA
XAKTIV Active Status: Description CHAR 60 0 TM_XAKTIV
XFRGZUST Transaction Release: Release Status CHAR 60 0 TB_XFRGZUST
XKONTRH Name and Address of Business Partner CHAR 80 0 TB_XKONTRH
XGARANT Name and address of guarantor CHAR 80 0 TB_XGARANT
SNOTE Memo exists CHAR 1 0 TB_SNOTE
SINCLB Calculation Period: Start Inclusive - End Exclusive CHAR 1 0 TB_SINCLBB
SINCLE Calculation Period: Start Exclusive - End Inclusive CHAR 1 0 TB_SINCLEB
SNPVCALY NPV calculation via yield CHAR 1 0 TB_SNPVCALY
SNPVCALD NPV calculation via discounting CHAR 1 0 TB_SNPVCALD
SRNDNGB Round Up or Down to the Nearest Whole Number CHAR 1 0 TB_SRNDNGB
SRNDNGD Round down CHAR 1 0 TB_SRNDNGD
SRNDNGU Round up CHAR 1 0 TB_SRNDNGU
PARENT_CFI_CODE Parent CFI Code CHAR 6 0 FTR_PARENT_CFI_CODE
PARENT_ISIN Parent ISIN CHAR 12 0 TB_PARENT_ISIN
MIC_TEXT Market Identifier Code Description CHAR 40 0 TBA_MIC_TXT
BEGRUTXT Name of authorization group for financial transactions CHAR 50 0 BEGRUTXT
XREFKONT Name of account assignment reference CHAR 40 0 TB_XREFKONT
XREFKONT2 Name of account assignment reference 2 CHAR 40 0 TB_XREFKONT2
XPORTB Portfolio Name CHAR 30 0 VVXPORTB
SVALIDATED Checkbox CHAR 1 0 XFELD
No
X Yes
XALKZ Short Name CHAR 15 0 XALKZ
XALLB Long Name CHAR 60 0 XALLB
EXT_RFHA Financial Transaction CHAR 13 0 TB_RFHA
XLDEPO Securities Account ID CHAR 30 0 XLDEPO
DBLFZ_LABEL Character Field with Length 10 CHAR 10 0 CHAR10
SMSG Message Exists CHAR 1 0 TB_SMSG
FMAREA Financial Management Area CHAR 4 0 FIKRS
CLEARING_DATEX Planned Clearing Date CHAR 10 0 TPM_TREA_CLEAR_DATE_TXT
CLEARING_INFO Char 80 CHAR 80 0 CHAR80
EXT_ACCOUNT_TEXT External Account Name CHAR 30 0 TPM_EXT_ACC_TEXT
XPRCTR General Name CHAR 20 0 KTEXT
XRCNTR General Name CHAR 20 0 KTEXT
XRBUSA Business area description CHAR 30 0 GTEXT
XHEDGE_CLASS Description CHAR 60 0 TOE_TEXT
XCLASSIFIER Text (20 Characters) CHAR 20 0 TEXT20
XCOUNTRY Name of Country/Region (Short) CHAR 15 0 LANDX
XFB_SEGMENT Text Field CHAR 50 0 TEXT50
XBEHALF_OF_COMPANY Name of Company Code or Company CHAR 25 0 BUTXT
ACC_FLAG Hedge Accounting Indicator CHAR 1 0 TOE_ACC_FLAG
0 Inactive
1 Active
XHEDGE_REQUEST_ID Description CHAR 50 0 TOE_DESCRIPTION
XPS_POSID PS: Short description (1st text line) CHAR 40 0 PS_POST1
XZUOND Value Description CHAR 60 0 TRBA_CHK_FIELD_DESCR
XREFER Value Description CHAR 60 0 TRBA_CHK_FIELD_DESCR
XMERKM Value Description CHAR 60 0 TRBA_CHK_FIELD_DESCR
XBUPLA Value Description CHAR 60 0 TRBA_CHK_FIELD_DESCR
XFUND Fund Text CHAR 20 0 FUND_TEXT
XGRANT_NBR Grant Text CHAR 20 0 GRANT_TEXT
XFKBER Name of the Functional Area CHAR 25 0 FIS_FKBTX

VTGFHA foreign key relationships

Table Field Check Table Check Field
0 VTGFHA ABWTYP AT05 Processing Categories SANLF
0 VTGFHA ABWTYP AT05 Processing Categories SFGTYP
0 VTGFHA ABWTYP AT05 Processing Categories ABWTYP
1 VTGFHA BEHALF_OF_COMPANY T001 Company Codes BUKRS
0 VTGFHA BUKRS T001 Company Codes BUKRS
1 VTGFHA BUPLA J_1BBRANCH Business Place MANDT
1 VTGFHA BUPLA J_1BBRANCH Business Place BUKRS
1 VTGFHA BUPLA J_1BBRANCH Business Place BRANCH
1 VTGFHA BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 VTGFHA COMMODITY_ID TRCOT_CTY_MASTER Commodity master data (obsolete) COMMODITY_ID
1 VTGFHA COMMODITY_ID1 TRCOT_CTY_MASTER Commodity master data (obsolete) COMMODITY_ID
0 VTGFHA COMMODITY_ID2 TRCOT_CTY_MASTER Commodity master data (obsolete) COMMODITY_ID
1 VTGFHA COUNTRY T005 Countries MANDT
1 VTGFHA COUNTRY T005 Countries LAND1
0 VTGFHA FACILITYBUKRS T001 Company Codes BUKRS
1 VTGFHA FACILITYNR VTBFHA Transaction BUKRS
1 VTGFHA FACILITYNR VTBFHA Transaction RFHA
0 VTGFHA FB_SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 VTGFHA FKBER TFKB Functional areas FKBER
0 VTGFHA HEDGE_CLASS TOEC_CLASS Hedging Classification CLIENT
0 VTGFHA HEDGE_CLASS TOEC_CLASS Hedging Classification HEDGING_CLASSIFICATION
1 VTGFHA MANDT T000 Clients MANDT
0 VTGFHA MIC TBAC_MIC Customizing table for Market Identification Code MIC
1 VTGFHA OBJNR ONR00 General Object Number MANDT
0 VTGFHA POSACC TRFT_POS_ACCOUNT Treasury: Futures Account Master Data MANDT
0 VTGFHA POSACC TRFT_POS_ACCOUNT Treasury: Futures Account Master Data POS_ACCOUNT
1 VTGFHA PRCTR CEPC Profit Center Master Data Table PRCTR
1 VTGFHA PRCTR CEPC Profit Center Master Data Table DATBI
1 VTGFHA PRCTR CEPC Profit Center Master Data Table KOKRS
0 VTGFHA PS_POSID PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 VTGFHA PS_POSID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 VTGFHA RBUSA TGSB Business Areas MANDT
1 VTGFHA RBUSA TGSB Business Areas GSBER
0 VTGFHA RCNTR CSKS Cost Center Master Record MANDT
0 VTGFHA RCNTR CSKS Cost Center Master Record KOKRS
0 VTGFHA RCNTR CSKS Cost Center Master Record KOSTL
0 VTGFHA RCNTR CSKS Cost Center Master Record DATBI
1 VTGFHA RCOMVALCL TRGC_COM_VALCL General valuation class MANDT
1 VTGFHA RCOMVALCL TRGC_COM_VALCL General valuation class COM_VAL_CLASS
0 VTGFHA RCOMVALCL2 TRGC_COM_VALCL General valuation class MANDT
0 VTGFHA RCOMVALCL2 TRGC_COM_VALCL General valuation class COM_VAL_CLASS
1 VTGFHA RLDEPO TWD01 Treasury: Securities Account Master Data MANDT
1 VTGFHA RLDEPO TWD01 Treasury: Securities Account Master Data BUKRS
1 VTGFHA RLDEPO TWD01 Treasury: Securities Account Master Data RLDEPO
0 VTGFHA RMAID VTBMA Master Agreement MANDT
0 VTGFHA RMAID VTBMA Master Agreement RMAID
1 VTGFHA RPORTB TWPOB Portfolio position MANDT
1 VTGFHA RPORTB TWPOB Portfolio position BUKRS
1 VTGFHA RPORTB TWPOB Portfolio position RPORTB
0 VTGFHA RPORTB2 TWPOB Portfolio position MANDT
0 VTGFHA RPORTB2 TWPOB Portfolio position BUKRS
0 VTGFHA RPORTB2 TWPOB Portfolio position RPORTB
1 VTGFHA RREFKONT T037S Account Assignment References acc. to Transaction Type MANDT
1 VTGFHA RREFKONT T037S Account Assignment References acc. to Transaction Type BUKRS
1 VTGFHA RREFKONT T037S Account Assignment References acc. to Transaction Type RREFKONT
0 VTGFHA RREFKONT2 T037S Account Assignment References acc. to Transaction Type MANDT
0 VTGFHA RREFKONT2 T037S Account Assignment References acc. to Transaction Type BUKRS
0 VTGFHA RREFKONT2 T037S Account Assignment References acc. to Transaction Type RREFKONT
1 VTGFHA SANLF TZAF Product categories SANLF
0 VTGFHA SFGTYP AT01 Transaction Category SANLFOR
1 VTGFHA SFHAART AT10 Transaction Types SGSART
1 VTGFHA SFHAART AT10 Transaction Types SFHAART
0 VTGFHA SGSART TZPA Financial Assets Management Product Types MANDT
0 VTGFHA SGSART TZPA Financial Assets Management Product Types GSART
1 VTGFHA TBEGRU TRBRG Authorization Group for Treasury Transactions MANDT
0 VTGFHA WGSCHFT TCURC Currency Codes MANDT
0 VTGFHA WGSCHFT TCURC Currency Codes WAERS