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
Here is some free PDF files that you can download free for your reference.
Download Now
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
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
KEYNO | Key Number for Payment Request | PRQ_KEYNO | PRQ_KEYNO |
ZBUKR | Paying Company Code for this Payment Request | PRQ_ZBUKR | BUKRS |
ABSBU | Sending Company Code for Payment Requests | PRQ_ABSBU | BUKRS |
BUKRS | Company Code | BUKRS | BUKRS |
BELNR | Accounting Document Number | BELNR_D | BELNR |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
GJAHR | Fiscal Year | GJAHR | GJAHR |
GSBER | Business Area | GSBER | GSBER |
USNAM | User name | USNAM | XUBNAME |
MONAT | Fiscal period | MONAT | MONAT |
CPUDT | Accounting document entry date | CPUDT | DATUM |
HWAER | Local Currency | HWAER | WAERS |
WAERS | Currency Key of the Invoice | PRQ_DOCUR | WAERS |
HWAE2 | Currency Key of Second Local Currency | HWAE2 | WAERS |
HWAE3 | Currency Key of Third Local Currency | HWAE3 | WAERS |
PACUR | Payment Request Currency Key | PRQ_PACUR | WAERS |
DMBTR | Amount in local currency | DMBTR | WERT7 |
DMBE2 | Amount in Second Local Currency | DMBE2 | WERT7 |
DMBE3 | Amount in Third Local Currency | DMBE3 | WERT7 |
WRBTR | Amount in document currency | WRBTR | WERT7 |
PAMTL | Payment Request Amount in Local Currency | PRQ_AMTLC | WERT7 |
PAMTF | Payment Request Amount in Payment Currency | PRQ_AMTFC | WERT7 |
SHKZG | Debit/Credit Indicator | SHKZG | SHKZG |
KOART | Account type | KOART | KOART |
PARNO | Business Partner | PRQ_PARNO | PRQ_PARNO |
HKONT | General Ledger Account | HKONT | SAKNR |
PAYEE | Account Number of the Alternative Payee | PRQ_PAYEE | PRQ_PARNO |
FILKD | Account Number of the Branch | FILKD | MAXKK |
ANRED | Title | ANRED | TEXT15 |
NAME1 | Name 1 | NAME1_GP | NAME |
NAME2 | Name 2 | NAME2_GP | NAME |
NAME3 | Name 3 | NAME3_GP | NAME |
NAME4 | Name 4 | NAME4_GP | NAME |
PSTLZ | Postal Code | PSTLZ | PSTLZ |
ORT01 | City | ORT01_GP | TEXT35 |
PSTL2 | P.O. Box Postal Code | PSTL2 | PSTLZ |
STRAS | House number and street | STRAS_GP | TEXT35 |
PFACH | PO Box | PFACH | PFACH |
LAND1 | Country Key | LAND1 | LAND1 |
REGIO | Region (State, Province, County) | REGIO | REGIO |
BUSAB | Accounting clerk | BUSAB | BUSAB |
STCD1 | Tax Number 1 | STCD1 | STCD1 |
DTAMS | Report key for data medium exchange | DTAMS | DTAMS |
DTAWS | Instruction key for data medium exchange | DTAWS | DTAWS |
DTWS1 | Instruction key 1 | DTAT16 | DTWSX |
DTWS2 | Instruction key 2 | DTAT17 | DTWSX |
DTWS3 | Instruction key 3 | DTAT18 | DTWSX |
DTWS4 | Instruction key 4 | DTAT19 | DTWSX |
LZBKZ | State central bank indicator | LZBKZ | LZBKZ |
LANDL | Supplying Country | LANDL | LAND1 |
ZANRE | Title of the payee | DZANRE | TEXT15 |
ZNME1 | Name of the payee | DZNME1 | TEXT35 |
ZNME2 | Name of the payee | DZNME1 | TEXT35 |
ZNME3 | Name of the payee | DZNME1 | TEXT35 |
ZNME4 | Name of the payee | DZNME1 | TEXT35 |
ZPSTL | Postal code of the payee | DZPSTL | PSTLZ |
ZORT1 | City of the payee | DZORT1 | TEXT35 |
ZPST2 | P.O. box postal code of the payee | DZPST2 | PSTLZ |
ZSTRA | Street and house number of the payee | DZSTRA | TEXT35 |
ZPFAC | P.O. box of the payee | DZPFAC | PFACH |
ZLAND | Country Key | DZLAND | LAND1 |
ZREGI | Regional code of the payee | DZREGI | REGIO |
ZSPRA | Language Key | SPRAS | SPRAS |
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR12 |
ZTLFX | Fax Number | TELFX | TEXT31 |
ZTELF | First telephone number | TELF1 | TEXT16 |
ZTELX | Telex number | TELX1 | TEXT30 |
HKTID | ID for account details | HKTID | HKTID |
HBKID | Short key for a house bank | HBKID | HBKID |
UBNKY | Bank key of our bank | UBNKY | BANKK |
UBNKS | Bank country key | BANKS | LAND1 |
UBNKL | Bank number of our bank | UBNKL | BANKL |
UIBAN | IBAN at our House Bank | UIBAN | IBAN |
UBKNT | Our account number at the bank | UBKNT | BANKN |
UBKON | Bank control key at our bank | UBKON | BKONT |
UBNKR | Regional Code of the House Bank | PRQ_UBNKR | REGIO |
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | SAKNR |
BKHBK | G/L Account for Bank Clearing Account | PRQ_BKHBK | SAKNR |
.INCLUDE | REGUH extension for the payment request | ||
BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS1 | Bank country key | BANKS | LAND1 |
BNKL1 | Bank Keys | BANKK | BANKK |
BNKN1 | Bank account number | BANKN | BANKN |
BKON1 | Bank Control Key | BKONT | BKONT |
BKRF1 | Reference specifications for bank details | BKREF | CHAR20 |
IBAN1 | IBAN (International Bank Account Number) | IBAN | IBAN |
BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS2 | Bank country key | BANKS | LAND1 |
BNKL2 | Bank Keys | BANKK | BANKK |
BNKN2 | Bank account number | BANKN | BANKN |
BKON2 | Bank Control Key | BKONT | BKONT |
BKRF2 | Reference specifications for bank details | BKREF | CHAR20 |
IBAN2 | IBAN (International Bank Account Number) | IBAN | IBAN |
BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS3 | Bank country key | BANKS | LAND1 |
BNKL3 | Bank Keys | BANKK | BANKK |
BNKN3 | Bank account number | BANKN | BANKN |
BKON3 | Bank Control Key | BKONT | BKONT |
BKRF3 | Reference specifications for bank details | BKREF | CHAR20 |
IBAN3 | IBAN (International Bank Account Number) | IBAN | IBAN |
BVTYP | Partner bank type | BVTYP | BVTYP |
ZBNKS | Country Key | DZBNKS | LAND1 |
ZBNKN | Bank account number of the payee | DZBNKN | BANKN |
ZBNKL | Bank number of the payee's bank | DZBNKL | BANKL |
ZBNKY | Bank key of the payee's bank | DZBNKY | BANKK |
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | BKONT |
BKREF | Reference specifications for bank details | BKREF | CHAR20 |
ZBNKR | Regional Code of the Payee's Bank | PRQ_ZBNKR | REGIO |
SWIFT | SWIFT/BIC for International Payments | SWIFT | SWIFT |
KOINH | Account Holder Name | KOINH_FI | KOINH |
ZGSBR | Business Area: Offsetting Posting | PRQ_ZGSBR | GSBER |
GGRUP | Partner Bank's Account No. for Bank Account Transfers | PRQ_ZHKONT | SAKNR |
XRELD | Indicator: Released for Posting | PRQ_XRELD | X |
XRELI | Indicator: Complete | PRQ_XRELI | X |
XRELP | Indicator: Released for Payment | PRQ_XRELP | X |
XREVE | Indicator: Payment Request is Reversed | PRQ_XREVE | XFELD |
STGRD | Reason for Reversal | STGRD | STGRD |
XURGE | Indicator: Extremely Urgent Payment | PRQ_XURGE | X |
TAGE1 | Residence time 1 | TAGE1 | NUM04 |
DUEDT | Payment Request Due Date | PRQ_DUEDT | DATUM |
VALUT | Value Date for the Sending Bank | PRQ_VALDT | DATUM |
CRVAL | Value Date at Payee's Bank | PRQ_CRVAL | DATUM |
IMPER | Value Date may no Longer be Changed | PRQ_IMPER | PRQ_IMPER |
ZUONR | Assignment number | DZUONR | ZUONR |
XPORE | Indicator: Individual Payment? | PRQ_XPORE | XFELD |
UZAWE | Payment method supplement | UZAWE | UZAWE |
ZWELS | List of the Payment Methods to be Considered | DZWELS | ZWELS |
XEZER | Indicator: Is there collection authorization ? | XEZER | XFELD |
SWTXT | Swift Text | PRQ_SWTXT | PRQ_SWTXT |
XBLNR | Reference Document Number | XBLNR1 | XBLNR1 |
BLDAT | Document Date in Document | BLDAT | DATUM |
SGTXT | Item Text | SGTXT | TEXT50 |
PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR20 |
XKDFB | Do not Post any Exchange Rate Differences | XKDFB_042E | XFELD |
ZLSPR | Payment Block Key | DZLSPR | ZAHLS |
VBUND | Company ID of trading partner | RASSC | RCOMP |
AUGDT | Clearing Date | AUGDT | DATUM |
AUGCP | Clearing Entry Date | AUGCP | DATUM |
AUGBL | Document Number of the Clearing Document | AUGBL | BELNR |
AWSYS | Logical System | LOGSYSTEM | LOGSYS |
AWTYP | Reference procedure | AWTYP | AWTYP |
AWKEY | Object key | AWKEY | AWKEY |
ORIGIN | Origin Indicator | FIBL_ORIGIN | FIBL_ORIGIN |
HBKGR | Group of House Bank Accounts | FIBL_HBG | FIBL_HBG |
RFTTRN | Payment code | RFTTRN_BF | RFTTRN_BF |
POST_NAME | User who Carried Out the Posting | PRQ_POSTNAME | XUBNAME |
POST_DATE | Day on Which Payment Request was Posted | PRQ_POSTDATE | DATUM |
REL_NAME | User who Carried Out the Release | PRQ_RELNAME | XUBNAME |
REL_DATE | Release Date for Payment | PRQ_RELDATE | DATUM |
DEDUAMNTP | Deductions in Payment Currency | PRQ_DEDUAMNTP | WERT7 |
DEDUAMNTL | Deductions in Local Currency | PRQ_DEDUAMNTL | WERT7 |
WTAMNTP | Withholding Tax Amount in Payment Currency | PRQ_WTAMNTP | WERT7 |
WTAMNTL | Withholding Tax Amount in Local Currency | PRQ_WTAMNTL | WERT7 |
KIDNO | Payment Reference | KIDNO | CHAR30 |
ZIBAN | IBAN of the Payee | DZIBAN | IBAN |
SNAME1 | Name 1 | NAME1_GP | NAME |
SORT01 | City | ORT01_GP | TEXT35 |
SLAND1 | Country Key | LAND1_GP | LAND1 |
.INCLUDE | Incl. for Payment Requests (for example Fields from REGUP) | ||
VERTN | Contract Number | RANL | RANL |
ZPFOR | City of payee's PO box | PFORT_Z | TEXT35 |
MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | |
SNAME2 | Name 2 | NAME2_GP | NAME |
SNAME3 | Name 3 | NAME3_GP | NAME |
SNAME4 | Name 4 | NAME4_GP | NAME |
SSTRAS | House number and street | STRAS_GP | TEXT35 |
SSTRS2 | House number and street | STRAS_GP | TEXT35 |
SPSTLZ | Postal code | PSTLZ_BAS | PSTLZ |
SID | Original Payer of a Payment (ID) | SENDER_ID | CHAR35 |
PURP_CODE | SEPA Purpose Code: Classification of a Payment/Debit Memo | FPM_PURP_CODE | CHAR4 |
PAYRQ related tables
Table | Note |
---|---|
F111G | Global Settings: Payment Program for Payment Requests |
T018Z | Cash Transfer: Payment Method Determination Payment Requests |
TPRQPB | Payment Block when using Payment Requests |
RSODSACTREQ | Activation table of M-requests to change-log requests |
RSODSACTREQMPP | Activation table of M-requests to change-log requests |
RSODSACTREQSAVE2 | Activation table of M-requests to change-log requests |
TSP02A | Dynamic Attributes for Spool Requests and Output Requests |
REGUHM | Payment Data for Cross-Payment Run Payment Medium |
REGUVM | Payment Data for Cross-Payment Run Payment Medium |
ATPRA | Treasury: Clearing Account for Payment Requests |
FDZA | Cash Management line items in payment requests |
PAYBU | Header Supplement for Payment Requests Without Vendor |
PAYRQ | Payment Requests |
T175DP_STATE | Update Down Payment Requests in Purchase Order History |
TRPRT_PAYMENTS | Persistent Data for Payment Requests |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP