PAYRQ - Payment Requests

Payment Requests information is stored in SAP table PAYRQ.
It is part of development package FMZA in software component FI-BL-PT-AP. This development package consists of objects that can be grouped under "Payment program for payment requests".

Fields for table PAYRQ

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
KEYNO	Key Number for Payment Request	X	PRQ_KEYNO	CHAR	20
ABSBU	Sending Company Code for Payment Requests		PRQ_ABSBU	CHAR	8	T001
BUKRS	Company Code		BUKRS	CHAR	8	T001
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
GJAHR	Fiscal Year		GJAHR	NUMC	8
GSBER	Business Area		GSBER	CHAR	8	TGSB
USNAM	User Name		USNAM	CHAR	24	USR02
MONAT	Fiscal period		MONAT	NUMC	4
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
HWAER	Local Currency		HWAER	CUKY	10	TCURC
WAERS	Currency Key of the Invoice		PRQ_DOCUR	CUKY	10	TCURC
HWAE2	Currency Key of Second Local Currency		HWAE2	CUKY	10	TCURC
HWAE3	Currency Key of Third Local Currency		HWAE3	CUKY	10	TCURC
PACUR	Payment Request Currency Key		PRQ_PACUR	CUKY	10	TCURC
DMBTR	Amount in local currency		DMBTR	CURR	12
DMBE2	Amount in Second Local Currency or Global Currency		DMBE2	CURR	12
DMBE3	Amount in Third Local Currency or First Freely-Def. Currency		DMBE3	CURR	12
WRBTR	Amount in document currency		WRBTR	CURR	12
PAMTL	Payment Request Amount in Local Currency		PRQ_AMTLC	CURR	12
PAMTF	Payment Request Amount in Payment Currency		PRQ_AMTFC	CURR	12
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
KOART	Account type		KOART	CHAR	2
PARNO	Business Partner		PRQ_PARNO	CHAR	20
HKONT	General Ledger Account		HKONT	CHAR	20	SKA1
PAYEE	Account Number of the Alternative Payee		PRQ_PAYEE	CHAR	20
FILKD	Account Number of the Branch		FILKD	CHAR	20
ANRED	Title		ANRED	CHAR	30
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
NAME3	Name 3		NAME3_GP	CHAR	70
NAME4	Name 4		NAME4_GP	CHAR	70
PSTLZ	Postal Code		PSTLZ	CHAR	20
ORT01	City		ORT01_GP	CHAR	70
PSTL2	P.O. Box Postal Code		PSTL2	CHAR	20
STRAS	Street and House Number		STRAS_GP	CHAR	70
PFACH	PO Box		PFACH	CHAR	20
LAND1	Country/Region Key		LAND1	CHAR	6	T005
REGIO	Region (State, Province, County)		REGIO	CHAR	6	T005S
BUSAB	Accounting Clerk Abbreviation		BUSAB	CHAR	4	T001S
STCD1	Tax Number 1		STCD1	CHAR	32
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4	T015W
DTWS1	Instruction Key 1		DTAT16	NUMC	4	T015W1
DTWS2	Instruction Key 2		DTAT17	NUMC	4	T015W1
DTWS3	Instruction key 3		DTAT18	NUMC	4	T015W1
DTWS4	Instruction key 4		DTAT19	NUMC	4	T015W1
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6	T015L
LANDL	Supplying Country/Region		LANDL	CHAR	6	T005
EIKTO	Shipper's (Our) Account Number at the Customer or Vendor		EIKTO	CHAR	24
HKTID	ID for Account Details		HKTID	CHAR	10	T012K
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
UBNKY	Bank Key of Our Bank		UBNKY	CHAR	30	BNKA
UBNKS	Country/Region Key of Bank		BANKS	CHAR	6	T005
UBNKL	Bank number of our bank		UBNKL	CHAR	30
UIBAN	IBAN at Our House Bank		UIBAN	CHAR	68
UBKNT	Our account number at the bank		UBKNT	CHAR	36
UBKON	Bank control key at our bank		UBKON	CHAR	4
UBNKR	Regional Code of the House Bank		PRQ_UBNKR	CHAR	6	T005S
UBHKT	G/L Account Number for Our Bank Account / Bank Subaccount		UBHKT	CHAR	20	SKA1
BKHBK	G/L Account for Bank Clearing Account		PRQ_BKHBK	CHAR	20	SKA1
.INCLUDE				REGUHX	0
BTYP1	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS1	Country/Region Key of Bank		BANKS	CHAR	6
BNKL1	Bank Keys		BANKK	CHAR	30
BNKN1	Bank account number		BANKN	CHAR	36
BKON1	Bank Control Key		BKONT	CHAR	4
BKRF1	Reference Details for Bank Details		BKREF	CHAR	40
IBAN1	IBAN (International Bank Account Number)		IBAN	CHAR	68
BTYP2	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS2	Country/Region Key of Bank		BANKS	CHAR	6
BNKL2	Bank Keys		BANKK	CHAR	30
BNKN2	Bank account number		BANKN	CHAR	36
BKON2	Bank Control Key		BKONT	CHAR	4
BKRF2	Reference Details for Bank Details		BKREF	CHAR	40
IBAN2	IBAN (International Bank Account Number)		IBAN	CHAR	68
BTYP3	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS3	Country/Region Key of Bank		BANKS	CHAR	6
BNKL3	Bank Keys		BANKK	CHAR	30
BNKN3	Bank account number		BANKN	CHAR	36
BKON3	Bank Control Key		BKONT	CHAR	4
BKRF3	Reference Details for Bank Details		BKREF	CHAR	40
IBAN3	IBAN (International Bank Account Number)		IBAN	CHAR	68
BVTYP	Partner bank type		BVTYP	CHAR	8
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
SWIFT	SWIFT/BIC for International Payments		SWIFT	CHAR	22
KOINH	Account Holder Name		KOINH_FI	CHAR	120
GGRUP	Partner Bank's Account No. for Bank Account Transfers		PRQ_ZHKONT	CHAR	20	SKA1
XRELD	Indicator: Released for Posting		PRQ_XRELD	CHAR	2
XRELI	Indicator: Complete		PRQ_XRELI	CHAR	2
XRELP	Indicator: Released for Payment		PRQ_XRELP	CHAR	2
XREVE	Indicator: Payment Request Is Reversed		PRQ_XREVE	CHAR	2
STGRD	Reason for Reversal or Inverse Posting		STGRD	CHAR	4	T041C
XURGE	Indicator: Extremely Urgent Payment		PRQ_XURGE	CHAR	2
TAGE1	Residence time 1		TAGE1	NUMC	8
DUEDT	Payment Request Due Date		PRQ_DUEDT	DATS	16
VALUT	Value Date for the Sending Bank		PRQ_VALDT	DATS	16
CRVAL	Value Date at Payee's Bank		PRQ_CRVAL	DATS	16
IMPER	Value Date May No Longer Be Changed		PRQ_IMPER	CHAR	2
XPORE	Indicator: Individual Payment?		PRQ_XPORE	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
XEZER	Indicator: Is there collection authorization ?		XEZER	CHAR	2
SWTXT	SWIFT Text		PRQ_SWTXT	CHAR	280
XBLNR	Reference Document Number		XBLNR1	CHAR	32
BLDAT	Document Date in Document		BLDAT	DATS	16
SGTXT	Item Text		SGTXT	CHAR	100
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
XKDFB	Do not Post any Exchange Rate Differences		XKDFB_042E	CHAR	2
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	T880
AUGDT	Clearing Date		AUGDT	DATS	16
AUGCP	Clearing Entry Date		AUGCP	DATS	16
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AWSYS	Logical System		LOGSYSTEM	CHAR	20	TBDLS
AWTYP	Reference procedure		AWTYP	CHAR	10	TTYP
AWKEY	Reference Key		AWKEY	CHAR	40
ORIGIN	Origin Indicator		FIBL_ORIGIN	CHAR	16	TFIBLORIGIN
HBKGR	Group of House Bank Accounts		FIBL_HBG	CHAR	4	TFIBLHBG
RFTTRN	Payment code		RFTTRN_BF	CHAR	40
POST_NAME	User Who Carried Out the Posting		PRQ_POSTNAME	CHAR	24	USR02
POST_DATE	Day on Which Payment Request Was Posted		PRQ_POSTDATE	DATS	16
REL_NAME	User Who Carried Out the Release		PRQ_RELNAME	CHAR	24	USR02
REL_DATE	Release Date for Payment		PRQ_RELDATE	DATS	16
DEDUAMNTP	Deductions in Payment Currency		PRQ_DEDUAMNTP	CURR	12
DEDUAMNTL	Deductions in Local Currency		PRQ_DEDUAMNTL	CURR	12
WTAMNTP	Withholding Tax Amount in Payment Currency		PRQ_WTAMNTP	CURR	12
WTAMNTL	Withholding Tax Amount in Local Currency		PRQ_WTAMNTL	CURR	12
KIDNO	Payment Reference		KIDNO	CHAR	60
SNAME1	Name 1		NAME1_GP	CHAR	70
SORT01	City		ORT01_GP	CHAR	70
SLAND1	Country/Region Key		LAND1_GP	CHAR	6
.INCLUDE				SI_PAYRQ_TR	0
VERTN	Contract Number		RANL	CHAR	26
EXTACCOUNT	External Account		TPM_EXT_ACCOUNT	CHAR	20
MGUID	SEPA Mandate: GUID of Mandate		SEPA_MGUID	RAW	16
SNAME2	Name 2		NAME2_GP	CHAR	70
SNAME3	Name 3		NAME3_GP	CHAR	70
SNAME4	Name 4		NAME4_GP	CHAR	70
SSTRAS	Street and House Number		STRAS_GP	CHAR	70
SSTRS2	Street and House Number		STRAS_GP	CHAR	70
SPSTLZ	Postal code		PSTLZ_BAS	CHAR	20
SID	Original Payer of a Payment (ID)		SENDER_ID	CHAR	70
PURP_CODE	SEPA Purpose Code: Classification of a Payment/Debit Memo		FPM_PURP_CODE	CHAR	8