VTBFHA - Transaction

Transaction information is stored in SAP table VTBFHA.
It is part of development package FTA in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "R/3 appl. development for Treasury money,forex,forward gen".

Fields for table VTBFHA

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
BUKRSCompany CodeXBUKRSCHAR8T001
RFHAFinancial TransactionXTB_RFHACHAR26
CRUSEREntered ByTB_CRUSERCHAR24
DCRDATEntered OnTB_DCRDATDATS16
TCRTIMEntry TimeTB_TCRTIMTIMS12
UPUSERLast Changed ByTB_UPUSERCHAR24
DUPDATChanged OnTB_DUPDATDATS16
TUPTIMTime ChangedTB_TUPTIMTIMS12
RANTYPContract TypeRANTYPCHAR2
SANLFProduct CategorySANLFNUMC6TZAF
SFGTYPTransaction CategoryTB_SFGTYPNUMC6AT01
SGSARTProduct TypeVVSARTCHAR6TZPA
SFHAARTFinancial Transaction TypeTB_SFHAARTCHAR6AT10
RGATTClassTI_RGATTCHAR26
RMAIDMaster AgreementTB_RMAIDCHAR20VTBMA
RFHAZUNRNumber Status of ActivityTB_RFHAZUNNUMC10
RFHAZULLast Active Transaction ActivityTB_RFHAZULNUMC10
SAKTIVActive Status of Transaction or ActivityTB_SAKTIVNUMC2
KONTRHBusiness Partner NumberTB_KUNNR_NEWCHAR20
SROLEXT3-Byte fieldCHAR3CHAR6
RGARANTGuarantor of Financial TransactionTB_RGARANT_NEWCHAR20
RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets ManagementRREFKONT_OBSOLETECHAR16T037S
RREFKONT2Obsolete: Accnt Assignment Ref. in Fin. Assets ManagementRREFKONT_OBSOLETECHAR16T037S
RPORTBPortfolioRPORTBCHAR20TWPOB
WGSCHFTTransaction CurrencyTB_WGSCHFTCUKY10TCURC
WGSCHFT1Currency of Outgoing SideTB_WGSCHF1CUKY10
WGSCHFT2Currency of Incoming SideTB_WGSCHF2CUKY10
AMTINPUTIndicator Field for Traded Amount in FX TransactionsTB_AMTINCHAR2
DBLFZTerm StartTB_DBLFZDATS16
SKALIDFactory calendarSKALIDCHAR4TFACD
SKALID2Factory calendarSKALIDCHAR4TFACD
JLIMITLimit IndicatorTB_JLIMITCHAR2
AKUENDPeriod of NoticeTB_AKUENDNUMC6
SKUENDUnit of Period of NoticeTB_SKUENDNUMC2
OBJNRObject numberJ_OBJNRCHAR44ONR00
RLDEPOSecurities AccountVRLDEPOCHAR20TWD01
DELFZTerm EndTB_DELFZDATS16
ABWTYPProcessing CategoryTB_ABWTYPCHAR10AT05
TBEGRUAuthorization GroupTBEGRUCHAR8TRBRG
VRFHAReference Transaction (Rollover/Premature Settlement)TB_VORFHACHAR26
SINCLBECalculation Period: Start Inclusive vs. End InclusiveTB_SINCLBECHAR2
SNPVCALNPV CalculationTB_SNPVCALCHAR2
SRNDNGRounding of Amount from Generated FlowsTB_SRNDNGCHAR2
REFERInternal ReferenceTB_REFERCHAR32
MERKMCharacteristicsTB_MERKMCHAR50
SFRGZUSTTransaction Release: Release StatusTB_FRGZUSTCHAR2
RANLSecurity Class ID NumberVVRANLWCHAR26
RCOMVALCLGeneral Valuation ClassTPM_COM_VAL_CLASSNUMC8TRGC_COM_VALCL
FACILITYNRTransaction Number of FacilityTB_FACILITYNRCHAR26VTBFHA
FACILITYBUKRSCompany Code of FacilityTB_FACILITYBUKRSCHAR8T001
POSACCFutures Account for Listed Options and FuturesTPM_POS_ACCOUNT_FUTCHAR20TRFT_POS_ACCOUNT
RCOMVALCL2General Valuation ClassTPM_COM_VAL_CLASSNUMC8TRGC_COM_VALCL
FUNDFundFM_FUNDCHAR20
GRANT_NBRGrantGM_GRANT_NBRCHAR40
TIMESTAMP_DEALUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
COMMODITY_IDCommodity ID (obsolete)TRCO_COMM_IDCHAR36TRCOT_CTY_MASTER
RPORTB2PortfolioRPORTBCHAR20TWPOB
COMMODITY_ID1Commodity ID (obsolete)TRCO_COMM_IDCHAR36TRCOT_CTY_MASTER
COMMODITY_ID2Commodity ID (obsolete)TRCO_COMM_IDCHAR36TRCOT_CTY_MASTER
CLEARING_OPTIONCentral Clearing Option (TREA)TPM_TREA_CLEARING_OPTNUMC2
CLEARING_STATUSClearing Status (TREA)TPM_TREA_CLEARING_STATUSNUMC2
CLEARING_DATEPlanned Clearing DateTPM_TREA_CLEARING_DATEDATS16
EXT_ACCOUNTExternal AccountTPM_EXT_ACCOUNTCHAR20
CLEAR_DATE_ACTActual Clearing DateTPM_TREA_CLEARING_DATE_ACTDATS16
SCONDITIONIndicates Whether Financial Trans. Is Based on a ConditionFTR_CONDITION_USEDCHAR2
RISK_MITIGATINGRisk Mitigation IndicatorFTR_THRESHOLD_RISK_MITIGATINGCHAR2
FIMA_CALCULATIONCash Flow CalculationTB_FIMA_CALCULATIONCHAR4
TRUSTEETrustee NumberFTR_TRUSTEECHAR20
PRCTRProfit CenterPRCTRCHAR20CEPC
RCNTRCost CenterKOSTLCHAR20CSKS
PS_POSIDWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC16PRPS
RBUSABusiness AreaGSBERCHAR8TGSB
HEDGE_CLASSHedging ClassificationTOE_HEDGING_CLASSIFICATIONCHAR10TOEC_CLASS
INIT_CLASSIFIERInitial Stage ValueTRPA_INITIAL_STAGECHAR20
COUNTRYCountry/Region KeyLAND1CHAR6T005
FB_SEGMENTSegment for Segmental ReportingFB_SEGMENTCHAR20FAGL_SEGM
BEHALF_OF_COMPANYOn Behalf of Company CodeTRBA_BEHALF_OF_COMPANYCHAR8T001
TRADED_CURRENCYTraded CurrencyFTR_TRADED_CURRCUKY10
HEDGE_REQUEST_IDHedge Request IDTOE_REQUEST_IDCHAR26
CFI_CODECFI CodeFTR_CFI_CODECHAR12
ISINSecurity ID Number (ISIN)RANL_ISINCHAR24
MICMarket Identifier CodeTBA_MICCHAR8TBAC_MIC
CONTRACT_TIMESTAMP_UTCContract Timestamp in UTCFTR_CONTRACT_TIMESTAMP_UTCDEC11
BUPLABusiness PlaceBUPLACHAR8J_1BBRANCH
FKBERFunctional AreaFKBERCHAR32TFKB
PRICEINDEX_USEDIndicator: Index calculation can be usedTB_INDEX_ONCHAR2
Privacy Policy