SAP table VTBFHA (Transaction)

SAP table VTBFHA has 3 primary key fields being MANDT,BUKRS,RFHA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VTBFHA foreign key relationships

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