SAP TABLES | Financial Accounting | Bank Accounting | Automatic Payments(FI-BL-PT-AP) SAP FI

PAYRQ SAP Payment Requests Table and data







PAYRQ is a standard SAP Table which is used to store Payment Requests data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP PAYRQ Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP PAYRQ Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KEYNOPRQ_KEYNOCHAR10 Key Number for Payment RequestALPHA
ZBUKRPRQ_ZBUKRCHAR4 T001Paying Company Code for this Payment Request
ABSBUPRQ_ABSBUCHAR4 T001Sending Company Code for Payment Requests
BUKRSBUKRSCHAR4 T001Company Code
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
GSBERGSBERCHAR4 TGSBBusiness Area
USNAMUSNAMCHAR12 USR02User name
MONATMONATNUMC2 Fiscal Period
CPUDTCPUDTDATS8 Day On Which Accounting Document Was Entered
HWAERHWAERCUKY5 TCURCLocal Currency
WAERSPRQ_DOCURCUKY5 TCURCCurrency Key of the Invoice
HWAE2HWAE2CUKY5 TCURCCurrency Key of Second Local Currency
HWAE3HWAE3CUKY5 TCURCCurrency Key of Third Local Currency
PACURPRQ_PACURCUKY5 TCURCPayment Request Currency Key
DMBTRDMBTRCURR13(2) Amount in Local Currency
DMBE2DMBE2CURR13(2) Amount in Second Local Currency
DMBE3DMBE3CURR13(2) Amount in Third Local Currency
WRBTRWRBTRCURR13(2) Amount in document currency
PAMTLPRQ_AMTLCCURR13(2) Payment Request Amount in Local Currency
PAMTFPRQ_AMTFCCURR13(2) Payment Request Amount in Payment Currency
SHKZGSHKZGCHAR1 Debit/Credit Indicator
KOARTKOARTCHAR1 Account Type
PARNOPRQ_PARNOCHAR10 Business PartnerALPHA
HKONTHKONTCHAR10 SKA1General Ledger AccountALPHA
PAYEEPRQ_PAYEECHAR10 Account Number of the Alternative PayeeALPHA
FILKDFILKDCHAR10 Account Number of the BranchALPHA
ANREDANREDCHAR15 Title
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
NAME3NAME3_GPCHAR35 Name 3
NAME4NAME4_GPCHAR35 Name 4
PSTLZPSTLZCHAR10 Postal Code
ORT01ORT01_GPCHAR35 City
PSTL2PSTL2CHAR10 P.O. Box Postal Code
STRASSTRAS_GPCHAR35 House number and street
PFACHPFACHCHAR10 PO Box


LAND1LAND1CHAR3 T005Country Key
BUSABBUSABCHAR2 T001SAccounting clerk
STCD1STCD1CHAR16 Tax Number 1
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2 T015WInstruction key for data medium exchange
DTWS1DTAT16NUMC2 T015W1Instruction key 1
DTWS2DTAT17NUMC2 T015W1Instruction key 2
DTWS3DTAT18NUMC2 T015W1Instruction key 3
DTWS4DTAT19NUMC2 T015W1Instruction key 4
LZBKZLZBKZCHAR3 T015LState Central Bank Indicator
LANDLLANDLCHAR3 T005Supplying Country
ZANREDZANRECHAR15 Title of the payee
ZNME1DZNME1CHAR35 Name of the payee
ZNME2DZNME1CHAR35 Name of the payee
ZNME3DZNME1CHAR35 Name of the payee
ZNME4DZNME1CHAR35 Name of the payee
ZPSTLDZPSTLCHAR10 Postal code of the payee
ZORT1DZORT1CHAR35 City of the payee
ZPST2DZPST2CHAR10 P.O. box postal code of the payee
ZSTRADZSTRACHAR35 Street and house number of the payee
ZPFACDZPFACCHAR10 P.O. box of the payee
ZLANDDZLANDCHAR3 T005Country Key
ZREGIDZREGICHAR3 T005SRegional code of the payee
ZSPRASPRASLANG1 T002Language KeyISOLA
EIKTOEIKTOCHAR12 Shipper's (Our) Account Number at the Customer or Vendor
ZTLFXTELFXCHAR31 Fax Number
ZTELFTELF1CHAR16 First telephone number
ZTELXTELX1CHAR30 Telex number
HKTIDHKTIDCHAR5 T012KID for account details
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
UBNKYUBNKYCHAR15 BNKABank key of our bank
UBNKSBANKSCHAR3 T005Bank country key
UBNKLUBNKLCHAR15 Bank number of our bank
UIBANUIBANCHAR34 IBAN at our House Bank
UBKNTUBKNTCHAR18 Our account number at the bank
UBKONUBKONCHAR2 Bank control key at our bank
UBNKRPRQ_UBNKRCHAR3 T005SRegional Code of the House Bank
UBHKTUBHKTCHAR10 SKA1G/L Account Number for Our Bank Account / Bank Sub-AccountALPHA
BKHBKPRQ_BKHBKCHAR10 SKA1G/L Account for Bank Clearing AccountALPHA


.INCLUDEREGUHX REGUH extension for the payment request
BTYP1BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS1BANKSCHAR3
*
Bank country key
BNKL1BANKKCHAR15 Bank Keys
BNKN1BANKNCHAR18 Bank account number
BKON1BKONTCHAR2 Bank Control Key
BKRF1BKREFCHAR20 Reference specifications for bank details
IBAN1IBANCHAR34 IBAN (International Bank Account Number)
BTYP2BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS2BANKSCHAR3
*
Bank country key
BNKL2BANKKCHAR15 Bank Keys
BNKN2BANKNCHAR18 Bank account number
BKON2BKONTCHAR2 Bank Control Key
BKRF2BKREFCHAR20 Reference specifications for bank details
IBAN2IBANCHAR34 IBAN (International Bank Account Number)
BTYP3BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS3BANKSCHAR3
*
Bank country key
BNKL3BANKKCHAR15 Bank Keys
BNKN3BANKNCHAR18 Bank account number
BKON3BKONTCHAR2 Bank Control Key
BKRF3BKREFCHAR20 Reference specifications for bank details
IBAN3IBANCHAR34 IBAN (International Bank Account Number)
BVTYPBVTYPCHAR4 Partner Bank Type
ZBNKSDZBNKSCHAR3 T005Country Key
ZBNKNDZBNKNCHAR18 Bank account number of the payee
ZBNKLDZBNKLCHAR15 Bank number of the payee's bank
ZBNKYDZBNKYCHAR15 BNKABank key of the payee's bank
ZBKONDZBKONCHAR2 Bank Control Key of the Payee's Bank
BKREFBKREFCHAR20 Reference specifications for bank details
ZBNKRPRQ_ZBNKRCHAR3 T005SRegional Code of the Payee's Bank
SWIFTSWIFTCHAR11 SWIFT/BIC for International Payments
KOINHKOINH_FICHAR60 Account Holder Name
ZGSBRPRQ_ZGSBRCHAR4 TGSBBusiness Area: Offsetting Posting
GGRUPPRQ_ZHKONTCHAR10 SKA1Partner Bank's Account No. for Bank Account TransfersALPHA
XRELDPRQ_XRELDCHAR1 Indicator: Released for Posting
XRELIPRQ_XRELICHAR1 Indicator: Complete
XRELPPRQ_XRELPCHAR1 Indicator: Released for Payment
XREVEPRQ_XREVECHAR1 Indicator: Payment Request is Reversed
STGRDSTGRDCHAR2 T041CReason for Reversal

XURGEPRQ_XURGECHAR1 Indicator: Extremely Urgent Payment
TAGE1TAGE1NUMC4 Residence time 1
DUEDTPRQ_DUEDTDATS8 Payment Request Due Date
VALUTPRQ_VALDTDATS8 Value Date for the Sending Bank
CRVALPRQ_CRVALDATS8 Value Date at Payee's Bank
IMPERPRQ_IMPERCHAR1 Value Date may no Longer be Changed
ZUONRDZUONRCHAR18 Assignment Number
XPOREPRQ_XPORECHAR1 Indicator: Individual Payment?
UZAWEUZAWECHAR2 T042FPayment Method Supplement
ZWELSDZWELSCHAR10 List of the Payment Methods to be Considered
XEZERXEZERCHAR1 Indicator: Is there collection authorization ?
SWTXTPRQ_SWTXTCHAR140 Swift Text
XBLNRXBLNR1CHAR16 Reference Document Number
BLDATBLDATDATS8 Document Date in Document
SGTXTSGTXTCHAR50 Item Text
PAYGRPAYGRCHAR20 Grouping Field for Automatic Payments
XKDFBXKDFB_042ECHAR1 Do not Post any Exchange Rate Differences
ZLSPRDZLSPRCHAR1 T008Payment Block Key
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
AUGDTAUGDTDATS8 Clearing Date
AUGCPAUGCPDATS8 Clearing Entry Date
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
AWSYSLOGSYSTEMCHAR10 TBDLSLogical SystemALPHA
AWTYPAWTYPCHAR5 TTYPReference Transaction
AWKEYAWKEYCHAR20 Reference Key
ORIGINFIBL_ORIGINCHAR8 TFIBLORIGINOrigin Indicator
HBKGRFIBL_HBGCHAR2 TFIBLHBGGroup of House Bank Accounts
RFTTRNRFTTRN_BFCHAR20 Payment code
POST_NAMEPRQ_POSTNAMECHAR12 USR02User who Carried Out the Posting
POST_DATEPRQ_POSTDATEDATS8 Day on Which Payment Request was Posted
REL_NAMEPRQ_RELNAMECHAR12 USR02User who Carried Out the Release
REL_DATEPRQ_RELDATEDATS8 Release Date for Payment
DEDUAMNTPPRQ_DEDUAMNTPCURR13(2) Deductions in Payment Currency
DEDUAMNTLPRQ_DEDUAMNTLCURR13(2) Deductions in Local Currency
WTAMNTPPRQ_WTAMNTPCURR13(2) Withholding Tax Amount in Payment Currency
WTAMNTLPRQ_WTAMNTLCURR13(2) Withholding Tax Amount in Local Currency
KIDNOKIDNOCHAR30 Payment Reference
ZIBANDZIBANCHAR34 IBAN of the Payee
SNAME1NAME1_GPCHAR35 Name 1
SORT01ORT01_GPCHAR35 City
SLAND1LAND1_GPCHAR3
*
Country Key
.INCLUDESI_PAYRQ_TR Incl. for Payment Requests (for example Fields from REGUP)
VERTNRANLCHAR13 Contract NumberALPHA
EXTACCOUNTTPM_EXT_ACCOUNTCHAR10 External Account
ZPFORPFORT_ZCHAR35 City of payee's PO box
MGUIDSEPA_MGUIDRAW16 SEPA Mandate: GUID of Mandate
SNAME2NAME2_GPCHAR35 Name 2
SNAME3NAME3_GPCHAR35 Name 3
SNAME4NAME4_GPCHAR35 Name 4
SSTRASSTRAS_GPCHAR35 House number and street
SSTRS2STRAS_GPCHAR35 House number and street
SPSTLZPSTLZ_BASCHAR10 Postal code
SIDSENDER_IDCHAR35 Original Payer of a Payment (ID)



Key field
Non-key field