OFX_STMTTRN_1 SAP (Transaction for Account Statement (V1)) Structure details

Dictionary Type: Structure
Description: Transaction for Account Statement (V1)




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




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

OFX_STMTTRN_1 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 for Account Statement (V1)" 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_OFX_STMTTRN_1 TYPE OFX_STMTTRN_1.

The OFX_STMTTRN_1 table consists of various fields, each holding specific information or linking keys about Transaction for Account Statement (V1) data available in SAP. These include DTPOSTED (Date at Which the Transaction Reaches the Account), DTUSER (Date on Which the User Started the Transaction), DTAVAIL (Date at Which Funds are Available), TRNAMT (Transaction Amount).. 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 OFX_STMTTRN_1 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
TRNTYPETransaction Type (There are Currently 17 Types) OFX_TRNTYPECHAR64CHAR64
DTPOSTEDDate at Which the Transaction Reaches the Account OFX_DTPOSTEDCHAR27OFX_DATETIMESTR
DTUSERDate on Which the User Started the Transaction OFX_DTUSERCHAR27OFX_DATETIMESTR
DTAVAILDate at Which Funds are Available OFX_DTAVAILCHAR27OFX_DATETIMESTR
TRNAMTTransaction Amount OFX_TRNAMTCHAR32OFX_AMOUNT
FITIDTransaction Identification Assigned by Financial Institution OFX_FITIDCHAR255OFX_FITID
CORRECTFITIDFITID of Transaction to be Corrected by this Transaction OFX_CORRECTFITIDCHAR255OFX_FITID
CORRECTACTIONAction with Transaction to be Corrected (REPLACE or DELETE) OFX_CORRECTACTIONCHAR16CHAR16
SRVRTIDIdentification Assigned by Server OFX_SRVRTIDCHAR10OFX_SRVRTID
CHECKNUMCheck Number OFX_CHECKNUMCHAR12CHAR12
REFNUMUnique Reference Number of Transaction OFX_REFNUMCHAR32CHAR32
SICStandard Industry Code OFX_SICNUMC6NUM6
PAYEEIDReceiver's Identification OFX_PAYEEIDCHAR12CHAR12
NAMEName of Recipient or of Transaction OFX_NAMECHAR32CHAR32
PAYEE 0
NAMEName of Recipient or of Transaction OFX_NAMECHAR32CHAR32
ADDR1Address Line OFX_ADDRCHAR32CHAR32
ADDR2Address Line OFX_ADDRCHAR32CHAR32
ADDR3Address Line OFX_ADDRCHAR32CHAR32
CITYCity OFX_CITYCHAR32CHAR32
STATEState OFX_STATECHAR5CHAR5
POSTALCODEPostal Code OFX_POSTALCODECHAR11CHAR11
COUNTRYCountry (3 Character Code from ISO/DIS-3166) OFX_COUNTRYCHAR3CHAR3
PHONETelephone Number OFX_PHONECHAR32CHAR32
BANKACCTTO 0
BANKIDBank ID for Routing and Transit OFX_BANKIDCHAR9CHAR9
BRANCHIDBank ID for International Banks OFX_BRANCHIDCHAR22CHAR22
ACCTIDAccount Number OFX_ACCTIDCHAR22CHAR22
ACCTTYPEAccount Type OFX_ACCTTYPECHAR10OFX_ACCTTYPE
ACCTKEYControl Total for International Banks OFX_ACCTKEYCHAR22CHAR22
CCACCTTO 0
ACCTIDAccount Number OFX_ACCTIDCHAR22CHAR22
ACCTKEYControl Total for International Banks OFX_ACCTKEYCHAR22CHAR22
MEMOAdditional Information OFX_MEMOCHAR255CHAR255
CURRENCY 0
CURRATEExchange Rate Between CURDEF Currency and CURSYM Currency OFX_CURRATECHAR32OFX_AMOUNT
CURSYMCurrency (3-Letter Code from ISO-4217) OFX_CURSYMCHAR3OFX_CURRSYMBOL
ORIGCURRENCY 0
CURRATEExchange Rate Between CURDEF Currency and CURSYM Currency OFX_CURRATECHAR32OFX_AMOUNT
CURSYMCurrency (3-Letter Code from ISO-4217) OFX_CURSYMCHAR3OFX_CURRSYMBOL

Key field Non-key field



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

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

How to access SAP table OFX_STMTTRN_1

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