TXI_VTBFHAZU SAP (Transaction Activity) Structure details

Dictionary Type: Structure
Description: Transaction Activity




ABAP Code to SELECT data from TXI_VTBFHAZU
Related tables to TXI_VTBFHAZU
Access table TXI_VTBFHAZU




Structure field list including key, data, relationships and ABAP select examples

TXI_VTBFHAZU is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transaction Activity" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXI_VTBFHAZU TYPE TXI_VTBFHAZU.

The TXI_VTBFHAZU table consists of various fields, each holding specific information or linking keys about Transaction Activity data available in SAP. These include MANDT (Client), BUKRS (Company Code), RFHA (Financial Transaction), RFHAZU (Transaction activity).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TXI_VTBFHAZU structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
RFHAZUTransaction activity TB_RFHAZUNUMC5T_RFHAZUFAS
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12
DCRDATEntered On TB_DCRDATDATS8DATUM
TCRTIMEntry Time TB_TCRTIMTIMS6UZEIT
UPUSERLast Changed by TB_UPUSERCHAR12SYCHAR12
DUPDATChanged on TB_DUPDATDATS8DATUM
TUPTIMTime changed TB_TUPTIMTIMS6UZEIT
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2AT02T_SFGZUTYC_AT02
SFUNKTVTransition Function from Directly Preceding Activity TB_SFUNKTVCHAR4AT60T_FUNKTION
SFUNKTLLatest function used in editing activity TB_SFUNKTLCHAR4AT60T_FUNKTION
ROFHAZUPrevious Activity TB_ROFHAZUNUMC5T_RFHAZU
RFHAZUXPrevious activity, which is supplemented by current activity TB_RFHAZUXNUMC5T_RFHAZU
SAKTIVActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
SSTOGRDReason for Reversal SSTOGRDCHAR2TZSTSSTOGRD
RDEALERTrader RDEALERCHAR12TZDEARDEALER
DVTRABContract Conclusion Date TB_DVTRABDATS8DATUM
TVTRABTime of contract conclusion TB_TVTRABTIMS6UZEIT
GSPPARTContact Person TB_GSPPARTCHAR19TEXT19
XAKTFile Number XAKTCHAR32CHAR32
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
DBLFZTerm Start TB_DBLFZDATS8DATUM
DELFZTerm End TB_DELFZDATS8DATUM
DFIXFixing date TB_DFIXDATS8DATUM
SINCLEEnd of Term Inclusive Indicator TB_SINCLECHAR1XFELD
DZSTNDLast activity transition date (e.g. for rollover) TB_DZSTNDDATS8DATUM
SZNSPROInterest Handling with Rollover TB_SZNSPRONUMC1T_SZNSPRO
DZNSSTDPayment date for deferred interest TB_DZNSSTDDATS8DATUM
KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
KKASSASpot Rate TB_KKASSADEC13(9) TB_KKURS
KSWAPSwap Rate TB_KSWAPDEC13(9) T_SWKURS
WLWAERSLeading currency TB_WLWAERSCUKY5TCURCWAERS
WFWAERSFollowing Currency TB_WFWAERSCUKY5TCURLWAERS
LIMITARTLimit type TB_LIMITARCHAR2ATORT_LIMITAR
LIMITDATLimit date TB_LIMITDADATS8DATUM
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
LIWAERSReference currency for limit TB_LIWAERSCUKY5TCURCWAERS
KWLIQUILiquidity effect for rollover TX_KWLIQDEC13(9) T_SWKURS
SCONFIRMConfirmation Status TB_CONFNUMC1TB_CONF
DEXDATConfirmation Date TB_DCONFDATS8DATUM
UEXNAMConfirmation Executed By (User Responsible) TB_UCONFCHAR12USNAM
SRECONFIRMCounterconfirmation TB_RECONFNUMC1TB_RECONF
DREDATCounterconfirmation Date TB_DREDATDATS8DATUM
URENAMCounterconfirmation Executed by (User Responsible) TB_URENAMCHAR12USNAM
DORDEROrder date TB_DORDERDATS8DATUM
DANSTReservation date TB_DANSTDATS8DATUM
TANSTOrder time of day TB_TANSTTIMS6TIMES
SANSTReservation Reason TB_SANSTCHAR2TW14SANST
SSPESENExpenses key TB_SPESENCHAR1T_SPESEN
BUPRCLIMLimit Price for Unit Quotation TB_BUPRCLIMDEC15(6) VVPKTKUR
SRUNITLIMCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
BPPRCLIMLimit Price for Percentage Quotation TB_BPPRCLIMDEC15(6) VVPKTKUR
JVERK6BFlag for sale from ยง6b - position TB_VERK6BCHAR1CHAR1
PEFFZINSEffective Interest Rate TB_PYIELDDEC10(7) DECV3_7
PEFFZINS_GIVENGiven Effective Interest Rate TB_PYIELD_GIVENDEC10(7) DECV3_7
PEFFZCALLEffective interest rate - termination of issuer TB_PYIELDCALLDEC10(7) DECV3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
NOTICE_DATEOTC Notice Date TB_NOTICE_DATEDATS8DATUM
ROUNDING_RULERounding Rule TPM_ROUNDING_RULECHAR4TRSC_ROUND_RULETPM_ROUNDING_RULE
BPPRC_SPOT2Spot Rate at Maturity in Percentage TB_BPPRC_SPOT_MATDEC15(6) VVPKTKUR
BPPRC_SPOT1Current Spot Rate in Percentage TB_BPPRC_SPOT1DEC15(6) VVPKTKUR
BPPRC_MARGMargin Rate in Percentage TB_BPPRC_MARGDEC15(5) DEC15_5DB4
COC_RATEInterest Rate for Cost of Carryforward TB_BPPRC_COC2DEC15(6) TPM_TRR_AMOUNT
FORWARD_DATEForward Date FTR_FWDDATEDATS8DATS
SNOTDELIVEREDSecurity not delivered FTR_NOT_DEL_FLGCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure TXI_VTBFHAZU using ABAP code?

As TXI_VTBFHAZU is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_VTBFHAZU as there is no data to select.

How to access SAP table TXI_VTBFHAZU

Within an ECC or HANA version of SAP you can also view further information about TXI_VTBFHAZU and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!