OFX_PMTRQ_ALL SAP (Payment Request (all)) Structure details

Dictionary Type: Structure
Description: Payment Request (all)




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




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

OFX_PMTRQ_ALL 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 "Payment Request (all)" 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_PMTRQ_ALL TYPE OFX_PMTRQ_ALL.

The OFX_PMTRQ_ALL table consists of various fields, each holding specific information or linking keys about Payment Request (all) data available in SAP. These include BANKACCTFROM (), BANKID (Bank ID for Routing and Transit), BRANCHID (Bank ID for International Banks), ACCTID (Account Number).. 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_PMTRQ_ALL 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
PMTINFO 0
BANKACCTFROM 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
TRNAMTTransaction Amount OFX_TRNAMTCHAR32OFX_AMOUNT
PAYEEIDReceiver's Identification OFX_PAYEEIDCHAR12CHAR12
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
PAYEELSTIDID from List of Payment Recipients (Payee List ID) OFX_PAYEELSTIDCHAR12CHAR12
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
EXTDPMT 0
PAYACCTAccount Number OFX_PAYACCTCHAR32CHAR32
DTDUEPayment Date OFX_DTDUECHAR27OFX_DATETIMESTR
MEMOAdditional Information OFX_MEMOCHAR255CHAR255
BILLREFINFOPayment Reference Number OFX_BILLREFINFOCHAR80TEXT80
PMTINFO2 0
PMTTYPECountry Specific Payment Type OFX_PMTTYPECHAR30OFX_PMTTYPE
BANKACCTFROM 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
TRNAMTTransaction Amount OFX_TRNAMTCHAR32OFX_AMOUNT
PAYEEIDReceiver's Identification OFX_PAYEEIDCHAR12CHAR12
PAYEE2 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
PAYEELSTIDID from List of Payment Recipients (Payee List ID) OFX_PAYEELSTIDCHAR12CHAR12
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
EXTDPMT2 0
PAYACCTAccount Number OFX_PAYACCTCHAR32CHAR32
DTDUEPayment Date OFX_DTDUECHAR27OFX_DATETIMESTR
DTAVAILDate at Which Funds are Available OFX_DTAVAILCHAR27OFX_DATETIMESTR
ITACAUSALEReason for the Payment (Italy only) OFX_ITACAUSALENUMC2NUM2
PMTFORName of the Person for whom the Payment is Carried Out OFX_PMTFORCHAR32TEXT32
BOOKINGTEXTText that Helps to Identify the Payment OFX_BOOKINGTEXTCHAR40TEXT40
MEMO2Additional Information OFX_MEMO2CHAR390CHAR390
BILLREFINFOPayment Reference Number OFX_BILLREFINFOCHAR80TEXT80

Key field Non-key field



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

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

How to access SAP table OFX_PMTRQ_ALL

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