VFSFHAZU SAP (Fin. Transaction Activity View for Listed Options / Futures) Structure details

Dictionary Type: Structure
Description: Fin. Transaction Activity View for Listed Options / Futures




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




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

VFSFHAZU 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 "Fin. Transaction Activity View for Listed Options / Futures" 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_VFSFHAZU TYPE VFSFHAZU.

The VFSFHAZU table consists of various fields, each holding specific information or linking keys about Fin. Transaction Activity View for Listed Options / Futures 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: Can be enhanced (character-type or numeric)


SAP VFSFHAZU 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
XAKTIVActive status: description TM_XAKTIVCHAR60TEXT60
XSTOGRDLText Field of Length 60 TEXT60CHAR60TEXT60
XBLFZTerm Start TM_XLFZBEGCHAR10T_XDATUM
XELFZEnd of Term TM_XLFZENDCHAR10T_XDATUM
XVTRABClose Date TM_XABSCHLCHAR10T_XDATUM
XZNSSTDPayment date for deferred interest TM_XZNSSTDCHAR10T_XDATUM
XZINSBMETHDescription of interest calculation method TM_XZINSBMCHAR60TEXT60
XZINSKENNZShort text for interest frequency indicator TM_XZINSKZCHAR60TEXT60
XZNSPROInterest treatment for rollover: description TM_XZNSPROCHAR60TEXT60
XVWERKDescription of working day method TM_XGSCHTGCHAR60TEXT60
XFWERKDescription of working day method TM_XGSCHTGCHAR60TEXT60
XFGZUSTTName of activity category TB_XTTEXTCHAR30TEXT30
XFUNKTVName of Treasury function TB_XFUNKTCHAR30TEXT30
XFUNKTLName of Treasury function TB_XFUNKTCHAR30TEXT30
XCONFIRMText Field of Length 60 TEXT60CHAR60TEXT60
XRECONFIRMText Field of Length 60 TEXT60CHAR60TEXT60
XORDERFlag to create the transaction as an order/fixing TX_XORDERCHAR1CHAR1T47
XVERTRAGFlag to create the transaction as a contract TX_XVERTRCHAR1CHAR1
DORDERXOrder date as text field WP_XORDERCHAR10T_XDATUM
DANSTXReservation date as text field TB_DANSTXCHAR10T_XDATUM
DLIMITXLimit date TB_LIMITDAXCHAR10T_XDATUM
PYIELD_NEWEffective Interest Rate TB_PYIELDDEC10(7) DECV3_7
BZBETR_SUMNet payment amount TB_BZBETR_SUMCURR13(2) WERTV7
WZBETR_SUMPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
DFESTSIActual rate fixing date TB_DFESTSIDATS8DATUM
TFESTSIActual time of rate fixing TB_TFESTSITIMS6SYTIME
SPOT_SE_USecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
SRUNIT_SECurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
SPOT_SE_PSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
RFEEDNAMEMarket Data: Data Provider TB_DFNAMECHAR10Assigned to domainT_DFCHAR10DLNAME
SSPOT_U Market Price as Text0
SSPOT_P Market Price as Text0
SSPOT_ORIGIN Price Source as Text0
JMANUIndicator: Manual entry TB_JMANUCHAR1XFELD
SPOT_SE_U_NEWSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
SRUNIT_SE_NEWCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
SPOT_SE_P_NEWSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
SEFFMETH_NEWEffective Interest Method (Financial Mathematics) SEFFMETH_NEWNUMC1SEFFMETH_NEW
CALL_DATEIssuer call date DKEMIDATS8DATUM

Key field Non-key field



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

As VFSFHAZU 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 VFSFHAZU as there is no data to select.

How to access SAP table VFSFHAZU

Within an ECC or HANA version of SAP you can also view further information about VFSFHAZU 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!