SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

PAYRQ Table in SAP | Payment Requests Table & Fields List

PAYRQ is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of PAYRQ in SAP.

  • Table description : Payment Requests
  • Module : FI-BL-PT-AP
  • Parent Module : FI
  • Package : FMZA
  • Software Component : SAP_FIN
PAYRQ table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP PAYRQ Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
KEYNOKey Number for Payment RequestPRQ_KEYNOPRQ_KEYNO
ZBUKRPaying Company Code for this Payment RequestPRQ_ZBUKRBUKRS
ABSBUSending Company Code for Payment RequestsPRQ_ABSBUBUKRS
BUKRSCompany CodeBUKRSBUKRS
BELNRAccounting Document NumberBELNR_DBELNR
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
GJAHRFiscal YearGJAHRGJAHR
GSBERBusiness AreaGSBERGSBER
USNAMUser nameUSNAMXUBNAME
MONATFiscal periodMONATMONAT
CPUDTAccounting document entry dateCPUDTDATUM
HWAERLocal CurrencyHWAERWAERS
WAERSCurrency Key of the InvoicePRQ_DOCURWAERS
HWAE2Currency Key of Second Local CurrencyHWAE2WAERS
HWAE3Currency Key of Third Local CurrencyHWAE3WAERS
PACURPayment Request Currency KeyPRQ_PACURWAERS
DMBTRAmount in local currencyDMBTRWERT7
DMBE2Amount in Second Local CurrencyDMBE2WERT7
DMBE3Amount in Third Local CurrencyDMBE3WERT7
WRBTRAmount in document currencyWRBTRWERT7
PAMTLPayment Request Amount in Local CurrencyPRQ_AMTLCWERT7
PAMTFPayment Request Amount in Payment CurrencyPRQ_AMTFCWERT7
SHKZGDebit/Credit IndicatorSHKZGSHKZG
KOARTAccount typeKOARTKOART
PARNOBusiness PartnerPRQ_PARNOPRQ_PARNO
HKONTGeneral Ledger AccountHKONTSAKNR
PAYEEAccount Number of the Alternative PayeePRQ_PAYEEPRQ_PARNO
FILKDAccount Number of the BranchFILKDMAXKK
ANREDTitleANREDTEXT15
NAME1Name 1NAME1_GPNAME
NAME2Name 2NAME2_GPNAME
NAME3Name 3NAME3_GPNAME
NAME4Name 4NAME4_GPNAME
PSTLZPostal CodePSTLZPSTLZ
ORT01CityORT01_GPTEXT35
PSTL2P.O. Box Postal CodePSTL2PSTLZ
STRASHouse number and streetSTRAS_GPTEXT35
PFACHPO BoxPFACHPFACH
LAND1Country KeyLAND1LAND1
REGIORegion (State, Province, County)REGIOREGIO
BUSABAccounting clerkBUSABBUSAB
STCD1Tax Number 1STCD1STCD1
DTAMSReport key for data medium exchangeDTAMSDTAMS
DTAWSInstruction key for data medium exchangeDTAWSDTAWS
DTWS1Instruction key 1DTAT16DTWSX
DTWS2Instruction key 2DTAT17DTWSX
DTWS3Instruction key 3DTAT18DTWSX
DTWS4Instruction key 4DTAT19DTWSX
LZBKZState central bank indicatorLZBKZLZBKZ
LANDLSupplying CountryLANDLLAND1
ZANRETitle of the payeeDZANRETEXT15
ZNME1Name of the payeeDZNME1TEXT35
ZNME2Name of the payeeDZNME1TEXT35
ZNME3Name of the payeeDZNME1TEXT35
ZNME4Name of the payeeDZNME1TEXT35
ZPSTLPostal code of the payeeDZPSTLPSTLZ
ZORT1City of the payeeDZORT1TEXT35
ZPST2P.O. box postal code of the payeeDZPST2PSTLZ
ZSTRAStreet and house number of the payeeDZSTRATEXT35
ZPFACP.O. box of the payeeDZPFACPFACH
ZLANDCountry KeyDZLANDLAND1
ZREGIRegional code of the payeeDZREGIREGIO
ZSPRALanguage KeySPRASSPRAS
EIKTOShipper's (Our) Account Number at the Customer or VendorEIKTOCHAR12
ZTLFXFax NumberTELFXTEXT31
ZTELFFirst telephone numberTELF1TEXT16
ZTELXTelex numberTELX1TEXT30
HKTIDID for account detailsHKTIDHKTID
HBKIDShort key for a house bankHBKIDHBKID
UBNKYBank key of our bankUBNKYBANKK
UBNKSBank country keyBANKSLAND1
UBNKLBank number of our bankUBNKLBANKL
UIBANIBAN at our House BankUIBANIBAN
UBKNTOur account number at the bankUBKNTBANKN
UBKONBank control key at our bankUBKONBKONT
UBNKRRegional Code of the House BankPRQ_UBNKRREGIO
UBHKTG/L Account Number for Our Bank Account / Bank Sub-AccountUBHKTSAKNR
BKHBKG/L Account for Bank Clearing AccountPRQ_BKHBKSAKNR
.INCLUDEREGUH extension for the payment request    
BTYP1Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS1Bank country keyBANKSLAND1
BNKL1Bank KeysBANKKBANKK
BNKN1Bank account numberBANKNBANKN
BKON1Bank Control KeyBKONTBKONT
BKRF1Reference specifications for bank detailsBKREFCHAR20
IBAN1IBAN (International Bank Account Number)IBANIBAN
BTYP2Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS2Bank country keyBANKSLAND1
BNKL2Bank KeysBANKKBANKK
BNKN2Bank account numberBANKNBANKN
BKON2Bank Control KeyBKONTBKONT
BKRF2Reference specifications for bank detailsBKREFCHAR20
IBAN2IBAN (International Bank Account Number)IBANIBAN
BTYP3Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS3Bank country keyBANKSLAND1
BNKL3Bank KeysBANKKBANKK
BNKN3Bank account numberBANKNBANKN
BKON3Bank Control KeyBKONTBKONT
BKRF3Reference specifications for bank detailsBKREFCHAR20
IBAN3IBAN (International Bank Account Number)IBANIBAN
BVTYPPartner bank typeBVTYPBVTYP
ZBNKSCountry KeyDZBNKSLAND1
ZBNKNBank account number of the payeeDZBNKNBANKN
ZBNKLBank number of the payee's bankDZBNKLBANKL
ZBNKYBank key of the payee's bankDZBNKYBANKK
ZBKONBank Control Key of the Payee's BankDZBKONBKONT
BKREFReference specifications for bank detailsBKREFCHAR20
ZBNKRRegional Code of the Payee's BankPRQ_ZBNKRREGIO
SWIFTSWIFT/BIC for International PaymentsSWIFTSWIFT
KOINHAccount Holder NameKOINH_FIKOINH
ZGSBRBusiness Area: Offsetting PostingPRQ_ZGSBRGSBER
GGRUPPartner Bank's Account No. for Bank Account TransfersPRQ_ZHKONTSAKNR
XRELDIndicator: Released for PostingPRQ_XRELDX
XRELIIndicator: CompletePRQ_XRELIX
XRELPIndicator: Released for PaymentPRQ_XRELPX
XREVEIndicator: Payment Request is ReversedPRQ_XREVEXFELD
STGRDReason for ReversalSTGRDSTGRD
XURGEIndicator: Extremely Urgent PaymentPRQ_XURGEX
TAGE1Residence time 1TAGE1NUM04
DUEDTPayment Request Due DatePRQ_DUEDTDATUM
VALUTValue Date for the Sending BankPRQ_VALDTDATUM
CRVALValue Date at Payee's BankPRQ_CRVALDATUM
IMPERValue Date may no Longer be ChangedPRQ_IMPERPRQ_IMPER
ZUONRAssignment numberDZUONRZUONR
XPOREIndicator: Individual Payment?PRQ_XPOREXFELD
UZAWEPayment method supplementUZAWEUZAWE
ZWELSList of the Payment Methods to be ConsideredDZWELSZWELS
XEZERIndicator: Is there collection authorization ?XEZERXFELD
SWTXTSwift TextPRQ_SWTXTPRQ_SWTXT
XBLNRReference Document NumberXBLNR1XBLNR1
BLDATDocument Date in DocumentBLDATDATUM
SGTXTItem TextSGTXTTEXT50
PAYGRGrouping Field for Automatic PaymentsPAYGRCHAR20
XKDFBDo not Post any Exchange Rate DifferencesXKDFB_042EXFELD
ZLSPRPayment Block KeyDZLSPRZAHLS
VBUNDCompany ID of trading partnerRASSCRCOMP
AUGDTClearing DateAUGDTDATUM
AUGCPClearing Entry DateAUGCPDATUM
AUGBLDocument Number of the Clearing DocumentAUGBLBELNR
AWSYSLogical SystemLOGSYSTEMLOGSYS
AWTYPReference procedureAWTYPAWTYP
AWKEYObject keyAWKEYAWKEY
ORIGINOrigin IndicatorFIBL_ORIGINFIBL_ORIGIN
HBKGRGroup of House Bank AccountsFIBL_HBGFIBL_HBG
RFTTRNPayment codeRFTTRN_BFRFTTRN_BF
POST_NAMEUser who Carried Out the PostingPRQ_POSTNAMEXUBNAME
POST_DATEDay on Which Payment Request was PostedPRQ_POSTDATEDATUM
REL_NAMEUser who Carried Out the ReleasePRQ_RELNAMEXUBNAME
REL_DATERelease Date for PaymentPRQ_RELDATEDATUM
DEDUAMNTPDeductions in Payment CurrencyPRQ_DEDUAMNTPWERT7
DEDUAMNTLDeductions in Local CurrencyPRQ_DEDUAMNTLWERT7
WTAMNTPWithholding Tax Amount in Payment CurrencyPRQ_WTAMNTPWERT7
WTAMNTLWithholding Tax Amount in Local CurrencyPRQ_WTAMNTLWERT7
KIDNOPayment ReferenceKIDNOCHAR30
ZIBANIBAN of the PayeeDZIBANIBAN
SNAME1Name 1NAME1_GPNAME
SORT01CityORT01_GPTEXT35
SLAND1Country KeyLAND1_GPLAND1
.INCLUDEIncl. for Payment Requests (for example Fields from REGUP)    
VERTNContract NumberRANLRANL
ZPFORCity of payee's PO boxPFORT_ZTEXT35
MGUIDSEPA Mandate: GUID of MandateSEPA_MGUID  
SNAME2Name 2NAME2_GPNAME
SNAME3Name 3NAME3_GPNAME
SNAME4Name 4NAME4_GPNAME
SSTRASHouse number and streetSTRAS_GPTEXT35
SSTRS2House number and streetSTRAS_GPTEXT35
SPSTLZPostal codePSTLZ_BASPSTLZ
SIDOriginal Payer of a Payment (ID)SENDER_IDCHAR35
PURP_CODESEPA Purpose Code: Classification of a Payment/Debit MemoFPM_PURP_CODECHAR4

PAYRQ related tables

TableNote
F111GGlobal Settings: Payment Program for Payment Requests
T018ZCash Transfer: Payment Method Determination Payment Requests
TPRQPBPayment Block when using Payment Requests
RSODSACTREQActivation table of M-requests to change-log requests
RSODSACTREQMPPActivation table of M-requests to change-log requests
RSODSACTREQSAVE2Activation table of M-requests to change-log requests
TSP02ADynamic Attributes for Spool Requests and Output Requests
REGUHMPayment Data for Cross-Payment Run Payment Medium
REGUVMPayment Data for Cross-Payment Run Payment Medium
ATPRATreasury: Clearing Account for Payment Requests
FDZACash Management line items in payment requests
PAYBUHeader Supplement for Payment Requests Without Vendor
PAYRQPayment Requests
T175DP_STATEUpdate Down Payment Requests in Purchase Order History
TRPRT_PAYMENTSPersistent Data for Payment Requests
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com