VWSFHA SAP (Transaction from Securities View) Structure details

Dictionary Type: Structure
Description: Transaction from Securities View




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




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

VWSFHA 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 from Securities View" 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_VWSFHA TYPE VWSFHA.

The VWSFHA table consists of various fields, each holding specific information or linking keys about Transaction from Securities View data available in SAP. These include MANDT (Client), BUKRS (Company Code), RFHA (Financial Transaction), CRUSER (Entered by).. 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 VWSFHA 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_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
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
RANTYPContract Type RANTYPCHAR1RANTYP
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
RGATTClass TI_RGATTCHAR13ALPHAT_RGATTT04
RMAIDMaster Agreement TB_RMAIDCHAR10VTBMAALPHAT_RMAIDTMAVTMA
RFHAZUNRNumber status of activity TB_RFHAZUNNUMC5T_RFHAZU
RFHAZULLast Active Transaction Activity TB_RFHAZULNUMC5T_RFHAZU
SAKTIVActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
KONTRHBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SROLEXT3-Byte field CHAR3CHAR3CHAR3
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8T037SUSTRUKRE
RREFKONT2Obsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8T037SUSTRUKRE
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
WGSCHFTCurrency of transaction TB_WGSCHFTCUKY5TCURCWAERS
WGSCHFT1Currency of Outgoing Side TB_WGSCHF1CUKY5Assigned to domainWAERS
WGSCHFT2Currency of Incoming Side TB_WGSCHF2CUKY5Assigned to domainWAERS
AMTINPUTNote field for traded amount forex transactions TB_AMTINCHAR1TX_AMTIN
DBLFZTerm Start TB_DBLFZDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
SKALID2Factory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
JLIMITLimit indicator TB_JLIMITCHAR1XFELD
AKUENDPeriod of Notice TB_AKUENDNUMC2T_AKUEND
SKUENDUnit of Period of Notice TB_SKUENDNUMC1T_SKUEND
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
ZUONRFinance Project TB_TFPROJCHAR13T_TFPROJ
DELFZTerm End TB_DELFZDATS8DATUM
ABWTYPProcessing Category TB_ABWTYPCHAR5AT05T_ABWTYP
TBEGRUAuthorization Group TBEGRUCHAR4TRBRGTRBEGRU
VRFHAReference transaction (Rollover/premature settlement) TB_VORFHACHAR13Assigned to domainALPHAT_RFHA
SINCLBECalculation Period: Start Inclusive vs. End Inclusive TB_SINCLBECHAR1T_SINCLBE
SNPVCALNPV Calculation TB_SNPVCALCHAR1T_SNPVCAL
SRNDNGRounding of Amount from Generated Flows TB_SRNDNGCHAR1TFM_SROUND
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SFRGZUSTTransaction Release: Release Status TB_FRGZUSTCHAR1T_FRGZUST
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RCOMVALCLGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
FACILITYNRTransaction Number of Facility TB_FACILITYNRCHAR13VTBFHAALPHAT_RFHAF4_FTR_FC
FACILITYBUKRSCompany Code of Facility TB_FACILITYBUKRSCHAR4T001BUKRSH_T001
POSACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10TRFT_POS_ACCOUNTTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
RCOMVALCL2General Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
TIMESTAMP_DEALUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
RPORTB2Portfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
COMMODITY_ID1Commodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
COMMODITY_ID2Commodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CLEARING_OPTIONCentral Clearing Option (TREA) TPM_TREA_CLEARING_OPTNUMC1TPM_TREA_CLEARING_OPT
CLEARING_STATUSClearing Status (TREA) TPM_TREA_CLEARING_STATUSNUMC1TPM_TREA_CLEARING_STATUS
CLEARING_DATEPlanned Clearing Date TPM_TREA_CLEARING_DATEDATS8TPM_TREA_CLEARING_DATE
EXT_ACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
CLEAR_DATE_ACTActual Clearing Date TPM_TREA_CLEARING_DATE_ACTDATS8TPM_TREA_CLEARING_DATE
SCONDITIONIndicates Whether Financial Trans. Is Based on a Condition FTR_CONDITION_USEDCHAR1FTR_CONDITION_USED
RISK_MITIGATINGRisk Mitigation Indicator FTR_THRESHOLD_RISK_MITIGATINGCHAR1FLAG
.INCLU--AP 0
.INCLU--AP 0
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
VBELNSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
VBELPSales document item VBELPNUMC6Assigned to domainPOSNR
XBUKRSName of Company Code or Company BUTXTCHAR25TEXT25
XGSARTName of product type TB_XGSARTCHAR30TEXT30
XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
XABWTYPName: Processing Category TB_XABRBEZCHAR60TEXT60
SKUENDTPeriod of notice in days TM_SKUENDTCHAR1XFELD
SKUENDMPeriod of notice in months TM_SKUENDMCHAR1XFELD
XRFHAFinancial transaction number TB_XRFHACHAR13T_XRFHA
XAKTIVActive status: description TM_XAKTIVCHAR60TEXT60
XFRGZUSTTransaction release: Release status TB_XFRGZUSTCHAR60TEXT60
XKONTRHName and address of business partner TB_XKONTRHCHAR80TEXT80
XGARANTName and address of guarantor TB_XGARANTCHAR80TEXT80
SNOTEMemo exists TB_SNOTECHAR1XFELD
SINCLBCalculation Period: Start Inclusive - End Exclusive TB_SINCLBBCHAR1XFELD
SINCLECalculation Period: Start Exclusive - End Inclusive TB_SINCLEBCHAR1XFELD
SNPVCALYNPV calculation via yield TB_SNPVCALYCHAR1XFELD
SNPVCALDNPV calculation via discounting TB_SNPVCALDCHAR1XFELD
SRNDNGBRound Up or Down to the Nearest Whole Number TB_SRNDNGBCHAR1XFELD
SRNDNGDRound down TB_SRNDNGDCHAR1XFELD
SRNDNGURound up TB_SRNDNGUCHAR1XFELD
XALKZShort name XALKZCHAR15XKBEZ
NORDEROrder Number NORDERNUMC8NUM8ORD
DVORGANGActivity date DVORGANGDATS8DATUM
XLDEPOSecurities account ID XLDEPOCHAR30XLDEPO
KONTRH_NEWBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
XPORTBPortfolio name VVXPORTBCHAR30TEXT30

Key field Non-key field



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

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

How to access SAP table VWSFHA

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