PAYRQ

Payment Requests | #transactional | #language | Component: Automatic Payments
Column Name Description
MANDT FK Client
KEYNO Key Number for Payment Request
Column Name Description
💲 Local Currency (HWAER):
DMBTR Amount in local currency
PAMTL Payment Request Amount in Local Currency
DEDUAMNTL Deductions in Local Currency
WTAMNTL Withholding Tax Amount in Local Currency
💲 Currency Key of Second Local Currency (HWAE2):
DMBE2 Amount in Second Local Currency or Global Currency
💲 Currency Key of Third Local Currency (HWAE3):
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency
💲 Currency Key of the Invoice (WAERS):
WRBTR Amount in document currency
💲 Payment Request Currency Key (PACUR):
PAMTF Payment Request Amount in Payment Currency
DEDUAMNTP Deductions in Payment Currency
WTAMNTP Withholding Tax Amount in Payment Currency
Column Name Description
Column Name Description
CPUDT Day On Which Accounting Document Was Entered
DUEDT Payment Request Due Date
VALUT Value Date for the Sending Bank
CRVAL Value Date at Payee's Bank
BLDAT Document Date in Document
AUGDT Clearing Date
AUGCP Clearing Entry Date
POST_DATE Day on Which Payment Request Was Posted
REL_DATE Release Date for Payment
Column Name Description
SHKZG Debit/Credit Indicator Show values
KOART Account type Show values
DTAMS Report key for data medium exchange Show values
BTYP1 Type of bank in a bank chain (correspondent, intermediary) Show values
BTYP2 Type of bank in a bank chain (correspondent, intermediary) Show values
BTYP3 Type of bank in a bank chain (correspondent, intermediary) Show values
XRELD Indicator: Released for Posting Show values
XRELI Indicator: Complete Show values
XRELP Indicator: Released for Payment Show values
XREVE Indicator: Payment Request Is Reversed Show values
XURGE Indicator: Extremely Urgent Payment Show values
IMPER Value Date May No Longer Be Changed Show values
XPORE Indicator: Individual Payment? Show values
XEZER Indicator: Is there collection authorization ? Show values
XKDFB Do not Post any Exchange Rate Differences Show values
Column Name Description Domain name
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
GJAHR Fiscal Year GJAHR
MONAT Fiscal period MONAT
PARNO Business Partner PRQ_PARNO
PAYEE Account Number of the Alternative Payee PRQ_PARNO
FILKD Account Number of the Branch MAXKK
ANRED Title TEXT15
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
PSTL2 P.O. Box Postal Code PSTLZ
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
STCD1 Tax Number 1 STCD1
ZANRE Title of the payee TEXT15
ZNME1 Name of the payee TEXT35
ZNME2 Name of the payee TEXT35
ZNME3 Name of the payee TEXT35
ZNME4 Name of the payee TEXT35
ZPSTL Postal Code of the Payee PSTLZ
ZORT1 City of the payee TEXT35
ZPST2 P.O. box postal code of the payee PSTLZ
ZSTRA Street and house number of the payee TEXT35
ZPFAC P.O. box of the payee PFACH
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR12
ZTLFX Fax Number TEXT31
ZTELF First telephone number TEXT16
ZTELX Telex number TEXT30
UBNKL Bank number of our bank BANKL
UIBAN IBAN at Our House Bank IBAN
UBKNT Our account number at the bank BANKN
UBKON Bank control key at our bank BKONT
BNKS1 Country/Region Key of Bank LAND1
BNKL1 Bank Keys BANKK
BNKN1 Bank account number BANKN
BKON1 Bank Control Key BKONT
BKRF1 Reference Details for Bank Details CHAR20
IBAN1 IBAN (International Bank Account Number) IBAN
BNKS2 Country/Region Key of Bank LAND1
BNKL2 Bank Keys BANKK
BNKN2 Bank account number BANKN
BKON2 Bank Control Key BKONT
BKRF2 Reference Details for Bank Details CHAR20
IBAN2 IBAN (International Bank Account Number) IBAN
BNKS3 Country/Region Key of Bank LAND1
BNKL3 Bank Keys BANKK
BNKN3 Bank account number BANKN
BKON3 Bank Control Key BKONT
BKRF3 Reference Details for Bank Details CHAR20
IBAN3 IBAN (International Bank Account Number) IBAN
BVTYP Partner bank type BVTYP
ZBNKN Bank account number of the payee BANKN
ZBNKL Bank number of the payee's bank BANKL
ZBKON Bank Control Key of the Payee's Bank BKONT
BKREF Reference Details for Bank Details CHAR20
SWIFT SWIFT/BIC for International Payments SWIFT
KOINH Account Holder Name KOINH
TAGE1 Residence time 1 NUM04
ZUONR Assignment number ZUONR
ZWELS List of Respected Payment Methods ZWELS
SWTXT SWIFT Text PRQ_SWTXT
XBLNR Reference Document Number XBLNR1
SGTXT Item Text TEXT50
PAYGR Grouping Field for Automatic Payments CHAR20
AUGBL Document Number of the Clearing Document BELNR
AWKEY Reference Key AWKEY
RFTTRN Payment code RFTTRN_BF
KIDNO Payment Reference CHAR30
ZIBAN IBAN of the Payee IBAN
SNAME1 Name 1 NAME
SORT01 City TEXT35
SLAND1 Country/Region Key LAND1
VERTN Contract Number RANL
EXTACCOUNT External Account TPM_EXT_ACCOUNT
ZPFOR City of payee's PO box TEXT35
MGUID SEPA Mandate: GUID of Mandate
SNAME2 Name 2 NAME
SNAME3 Name 3 NAME
SNAME4 Name 4 NAME
SSTRAS Street and House Number TEXT35
SSTRS2 Street and House Number TEXT35
SPSTLZ Postal code PSTLZ
SID Original Payer of a Payment (ID) CHAR35
PURP_CODE SEPA Purpose Code: Classification of a Payment/Debit Memo CHAR4
Master Data Relations Join Conditions
Sending Company Code for Payment Requests
  • PAYRQ.MANDT == T001.MANDT
  • PAYRQ.ABSBU == T001.BUKRS
Logical System PAYRQ.AWSYS == TBDLS.LOGSYS
Reference procedure PAYRQ.AWTYP == TTYP.AWTYP
G/L Account for Bank Clearing Account
  • ?
  • Client
  • G/L Account for Bank Clearing Account
  • PAYRQ.[column in domain "KTOPL"] == SKA1.KTOPL
  • PAYRQ.MANDT == SKA1.MANDT
  • PAYRQ.BKHBK == SKA1.SAKNR
Company Code
  • PAYRQ.MANDT == T001.MANDT
  • PAYRQ.BUKRS == T001.BUKRS
Accounting Clerk Abbreviation
  • Sending Company Code for Payment Requests
  • Client
  • Accounting Clerk Abbreviation
  • PAYRQ.ABSBU == T001S.BUKRS
  • PAYRQ.MANDT == T001S.MANDT
  • PAYRQ.BUSAB == T001S.BUSAB
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • Client
  • ?
  • PAYRQ.UBNKS == T015W.BANKS
  • PAYRQ.DTAWS == T015W.DTAWS
  • PAYRQ.MANDT == T015W.MANDT
  • PAYRQ.[column in domain "DZLSCH"] == T015W.ZLSCH
Instruction Key 1
  • ?
  • ?
  • Instruction Key 1
  • PAYRQ.[column in domain "DTWSC"] == T015W1.DTWSC
  • PAYRQ.[column in domain "DTWSF"] == T015W1.DTWSF
  • PAYRQ.DTWS1 == T015W1.DTWSX
Instruction Key 2
  • ?
  • ?
  • Instruction Key 2
  • PAYRQ.[column in domain "DTWSC"] == T015W1.DTWSC
  • PAYRQ.[column in domain "DTWSF"] == T015W1.DTWSF
  • PAYRQ.DTWS2 == T015W1.DTWSX
Instruction key 3
  • ?
  • ?
  • Instruction key 3
  • PAYRQ.[column in domain "DTWSC"] == T015W1.DTWSC
  • PAYRQ.[column in domain "DTWSF"] == T015W1.DTWSF
  • PAYRQ.DTWS3 == T015W1.DTWSX
Instruction key 4
  • ?
  • ?
  • Instruction key 4
  • PAYRQ.[column in domain "DTWSC"] == T015W1.DTWSC
  • PAYRQ.[column in domain "DTWSF"] == T015W1.DTWSF
  • PAYRQ.DTWS4 == T015W1.DTWSX
Partner Bank's Account No. for Bank Account Transfers
  • ?
  • Client
  • Partner Bank's Account No. for Bank Account Transfers
  • PAYRQ.[column in domain "KTOPL"] == SKA1.KTOPL
  • PAYRQ.MANDT == SKA1.MANDT
  • PAYRQ.GGRUP == SKA1.SAKNR
Business Area
  • PAYRQ.MANDT == TGSB.MANDT
  • PAYRQ.GSBER == TGSB.GSBER
Group of House Bank Accounts
  • Paying Company Code for this Payment Request
  • Client
  • Group of House Bank Accounts
Short Key for a House Bank
  • Short Key for a House Bank
  • Paying Company Code for this Payment Request
  • PAYRQ.MANDT == T012.MANDT
  • PAYRQ.HBKID == T012.HBKID
  • PAYRQ.ZBUKR == T012.BUKRS
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • PAYRQ.[column in domain "KTOPL"] == SKA1.KTOPL
  • PAYRQ.MANDT == SKA1.MANDT
  • PAYRQ.HKONT == SKA1.SAKNR
ID for Account Details
  • Paying Company Code for this Payment Request
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • PAYRQ.ZBUKR == T012K.BUKRS
  • PAYRQ.HKTID == T012K.HKTID
  • PAYRQ.MANDT == T012K.MANDT
  • PAYRQ.HBKID == T012K.HBKID
Currency Key of Second Local Currency
  • PAYRQ.MANDT == TCURC.MANDT
  • PAYRQ.HWAE2 == TCURC.WAERS
Currency Key of Third Local Currency
  • PAYRQ.MANDT == TCURC.MANDT
  • PAYRQ.HWAE3 == TCURC.WAERS
Local Currency
  • PAYRQ.MANDT == TCURC.MANDT
  • PAYRQ.HWAER == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • PAYRQ.LAND1 == T005.LAND1
  • PAYRQ.MANDT == T005.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • PAYRQ.LANDL == T005.LAND1
  • PAYRQ.MANDT == T005.MANDT
State Central Bank Indicator
  • PAYRQ.MANDT == T015L.MANDT
  • PAYRQ.LZBKZ == T015L.LZBKZ
Client PAYRQ.MANDT == T000.MANDT
Origin Indicator PAYRQ.ORIGIN == TFIBLORIGIN.ORIGIN
Payment Request Currency Key
  • PAYRQ.MANDT == TCURC.MANDT
  • PAYRQ.PACUR == TCURC.WAERS
User Who Carried Out the Posting
  • PAYRQ.MANDT == USR02.MANDT
  • PAYRQ.POST_NAME == USR02.BNAME
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • PAYRQ.MANDT == T005S.MANDT
  • PAYRQ.LAND1 == T005S.LAND1
  • PAYRQ.REGIO == T005S.BLAND
User Who Carried Out the Release
  • PAYRQ.MANDT == USR02.MANDT
  • PAYRQ.REL_NAME == USR02.BNAME
Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • Client
  • PAYRQ.STGRD == T041C.STGRD
  • PAYRQ.MANDT == T041C.MANDT
G/L Account Number for Our Bank Account / Bank Subaccount
  • ?
  • Client
  • G/L Account Number for Our Bank Account / Bank Subaccount
  • PAYRQ.[column in domain "KTOPL"] == SKA1.KTOPL
  • PAYRQ.MANDT == SKA1.MANDT
  • PAYRQ.UBHKT == SKA1.SAKNR
Regional Code of the House Bank
  • Country/Region Key of Bank
  • Regional Code of the House Bank
  • PAYRQ.MANDT == T005S.MANDT
  • PAYRQ.UBNKS == T005S.LAND1
  • PAYRQ.UBNKR == T005S.BLAND
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • PAYRQ.UBNKS == T005.LAND1
  • PAYRQ.MANDT == T005.MANDT
Bank Key of Our Bank
  • Bank Key of Our Bank
  • Country/Region Key of Bank
  • PAYRQ.MANDT == BNKA.MANDT
  • PAYRQ.UBNKY == BNKA.BANKL
  • PAYRQ.UBNKS == BNKA.BANKS
User Name
  • PAYRQ.MANDT == USR02.MANDT
  • PAYRQ.USNAM == USR02.BNAME
Payment method supplement
  • PAYRQ.MANDT == T042F.MANDT
  • PAYRQ.UZAWE == T042F.UZAWE
Company ID of Trading Partner
  • PAYRQ.MANDT == T880.MANDT
  • PAYRQ.VBUND == T880.RCOMP
Currency Key of the Invoice
  • PAYRQ.MANDT == TCURC.MANDT
  • PAYRQ.WAERS == TCURC.WAERS
Regional Code of the Payee's Bank
  • Country/Region Key
  • Regional Code of the Payee's Bank
  • PAYRQ.MANDT == T005S.MANDT
  • PAYRQ.ZBNKS == T005S.LAND1
  • PAYRQ.ZBNKR == T005S.BLAND
Country/Region Key
  • Country/Region Key
  • Client
  • PAYRQ.ZBNKS == T005.LAND1
  • PAYRQ.MANDT == T005.MANDT
Bank key of the payee's bank
  • Bank key of the payee's bank
  • Country/Region Key
  • PAYRQ.MANDT == BNKA.MANDT
  • PAYRQ.ZBNKY == BNKA.BANKL
  • PAYRQ.ZBNKS == BNKA.BANKS
Paying Company Code for this Payment Request
  • PAYRQ.MANDT == T001.MANDT
  • PAYRQ.ZBUKR == T001.BUKRS
Business Area: Offsetting Posting
  • PAYRQ.MANDT == TGSB.MANDT
  • PAYRQ.ZGSBR == TGSB.GSBER
Country/Region Key
  • Country/Region Key
  • Client
  • PAYRQ.ZLAND == T005.LAND1
  • PAYRQ.MANDT == T005.MANDT
Payment Block Key
  • Payment Block Key
  • Client
  • PAYRQ.ZLSPR == T008.ZAHLS
  • PAYRQ.MANDT == T008.MANDT
Regional code of the payee
  • Country/Region Key
  • Regional code of the payee
  • PAYRQ.MANDT == T005S.MANDT
  • PAYRQ.ZLAND == T005S.LAND1
  • PAYRQ.ZREGI == T005S.BLAND
Language Key PAYRQ.ZSPRA == T002.SPRAS