PAYRQ is a standard Automatic Payments Transparent Table in SAP FI application, which stores Payment Requests data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for PAYRQ. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

PAYRQ — Meta Data

Description: Payment Requests
Main Category: FI
Sub Category: Automatic Payments
Table type: Transparent Table (TRANSP)

PAYRQ — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 KEYNO Key Number for Payment Request X CHAR 10
    3 ZBUKR Paying company code CHAR 4 T001
    4 ABSBU Sending company code CHAR 4 T001
    5 BUKRS Company Code CHAR 4 T001
    6 BELNR Document Number CHAR 10
    7 BUZEI Posting row NUMC 3
    8 GJAHR Fiscal Year NUMC 4
    9 GSBER Business Area CHAR 4 TGSB
    10 USNAM User name CHAR 12 USR02
    11 MONAT Period NUMC 2
    12 CPUDT Entered on DATS 8
    13 HWAER Local Currency CUKY 5 TCURC
    14 WAERS Currency CUKY 5 TCURC
    15 HWAE2 Local curr. 2 CUKY 5 TCURC
    16 HWAE3 Local curr. 3 CUKY 5 TCURC
    17 PACUR Payment Request Currency Key CUKY 5 TCURC
    18 DMBTR Amount in LC CURR 23
    19 DMBE2 Amt loc.curr.2 CURR 23
    20 DMBE3 Amt loc. curr.3 CURR 23
    21 WRBTR Amount CURR 23
    22 PAMTL User field for cluster PC (national) CURR 23
    23 PAMTF User field for cluster PC (national) CURR 23
    24 SHKZG Debit/Credit CHAR 1
    25 KOART Account Type CHAR 1
    26 PARNO Sequential Number of the Parameter CHAR 10
    27 HKONT G/L CHAR 10 SKA1
    28 PAYEE Payee CHAR 10
    29 FILKD Branch CHAR 10
    30 ANRED Form of address CHAR 15
    31 NAME1 Name 1 CHAR 35
    32 NAME2 Name 2 CHAR 35
    33 NAME3 Name 3 CHAR 35
    34 NAME4 Name 4 CHAR 35
    35 PSTLZ P.Code/City CHAR 10
    36 ORT01 City CHAR 35
    37 PSTL2 P.O. Box Postal Code CHAR 10
    38 STRAS House number and street CHAR 35
    39 PFACH PO Box CHAR 10
    40 LAND1 Country CHAR 3 T005
    41 REGIO Region (State CHAR 3 T005S
    42 BUSAB Accounting clerk CHAR 2 T001S
    43 STCD1 Tax Number 1 CHAR 16
    44 DTAMS Report key for data medium exchange CHAR 1
    45 DTAWS Instruction key for data medium exchange CHAR 2 T015W
    46 DTWS1 Instruct.key 1 NUMC 2 T015W1
    47 DTWS2 Instruct. key 2 NUMC 2 T015W1
    48 DTWS3 Instruct. key 3 NUMC 2 T015W1
    49 DTWS4 Instruct. key 4 NUMC 2 T015W1
    50 LZBKZ State central bank indicator CHAR 3 T015L
    51 LANDL Supplying Country CHAR 3 T005
    52 ZANRE Form of address text CHAR 15
    53 ZNME1 Name of the payee CHAR 35
    54 ZNME2 Name 2 CHAR 35
    55 ZNME3 Name 3 CHAR 35
    56 ZNME4 Name of the payee CHAR 35
    57 ZPSTL Postal Code of the Payee CHAR 10
    58 ZORT1 Location CHAR 35
    59 ZPST2 PO Box Postal Code CHAR 10
    60 ZSTRA Street CHAR 35
    61 ZPFAC PO Box CHAR 10
    62 ZLAND Trip Country/Trip Country Group CHAR 3 T005
    63 ZREGI Region (State CHAR 3 T005S
    64 ZSPRA Language Key LANG 1 T002
    65 EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12
    66 ZTLFX Payee's telefax number CHAR 31
    67 ZTELF Payee telephone number CHAR 16
    68 ZTELX Payee telex number CHAR 30
    69 HKTID ID for Account Details CHAR 5 T012K
    70 HBKID Short key for a house bank CHAR 5 T012
    71 UBNKY Bank key of our bank CHAR 15 BNKA
    72 UBNKS Bank country key CHAR 3 T005
    73 UBNKL Bank number of our bank CHAR 15
    74 UIBAN IBAN (International Bank Account Number) CHAR 34
    75 UBKNT Our account number at the bank CHAR 18
    76 UBKON Bank control key at our bank CHAR 2
    77 UBNKR Regional Code of the House Bank CHAR 3 T005S
    78 UBHKT G/L Account Number for Our Bank Account / Bank Subaccount CHAR 10 SKA1
    79 BKHBK G/L Account for Bank Clearing Account CHAR 10 SKA1
    80 .INCLUDE 0
    81 BTYP1 Type of bank in a bank chain (correspondent CHAR 1
    82 BNKS1 Bank country key CHAR 3
    83 BNKL1 Bank Keys CHAR 15
    84 BNKN1 Bank account number CHAR 18
    85 BKON1 Bank Control Key CHAR 2
    86 BKRF1 Reference specifications for bank details CHAR 20
    87 IBAN1 IBAN (International Bank Account Number) CHAR 34
    88 BTYP2 Type of bank in a bank chain (correspondent CHAR 1
    89 BNKS2 Bank country key CHAR 3
    90 BNKL2 Bank Keys CHAR 15
    91 BNKN2 Alternative Bank Acct Number (for Ambiguous Acct Number) CHAR 18
    92 BKON2 Bank Control Key CHAR 2
    93 BKRF2 Reference specifications for bank details CHAR 20
    94 IBAN2 IBAN (International Bank Account Number) CHAR 34
    95 BTYP3 Type of bank in a bank chain (correspondent CHAR 1
    96 BNKS3 Bank country key CHAR 3
    97 BNKL3 Bank Keys CHAR 15
    98 BNKN3 Bank account number CHAR 18
    99 BKON3 Bank Control Key CHAR 2
    100 BKRF3 Reference specifications for bank details CHAR 20
    101 IBAN3 IBAN (International Bank Account Number) CHAR 34
    102 BVTYP Partner bank type CHAR 4
    103 ZBNKS Bank country key CHAR 3 T005
    104 ZBNKN Bank account number of the payee CHAR 18
    105 ZBNKL Bank number of the payee's bank CHAR 15
    106 ZBNKY Bank key of the payee's bank CHAR 15 BNKA
    107 ZBKON Bank Control Key of the Payee's Bank CHAR 2
    108 BKREF Reference specifications for bank details CHAR 20
    109 ZBNKR Regional Code of the Payee's Bank CHAR 3 T005S
    110 SWIFT SWIFT/BIC for International Payments CHAR 11
    111 KOINH Account Holder Name CHAR 60
    112 ZGSBR Business Area: Offsetting Posting CHAR 4 TGSB
    113 GGRUP Offsetting account CHAR 10 SKA1
    114 XRELD Indicator: Released for Posting CHAR 1
    115 XRELI Single-Character Flag CHAR 1
    116 XRELP Indicator: Released for Payment CHAR 1
    117 XREVE Document must be reversed CHAR 1
    118 STGRD Reason for Reversal CHAR 2 T041C
    119 XURGE Single-Character Flag CHAR 1
    120 TAGE1 Natural number NUMC 4
    121 DUEDT Contribution Due Days DATS 8
    122 VALUT Value date DATS 8
    123 CRVAL Value Date at Payee's Bank DATS 8
    124 IMPER Value date may no longer be changed CHAR 1
    125 ZUONR Assignment CHAR 18
    126 XPORE Indicator: Single Payment CHAR 1
    127 UZAWE Pmt meth.supl. CHAR 2 T042F
    128 ZWELS List of Respected Payment Methods CHAR 10
    129 XEZER Indicator: Is there collection authorization ? CHAR 1
    130 SWTXT Swift Text CHAR 140
    131 XBLNR Reference CHAR 16
    132 BLDAT Document Date DATS 8
    133 SGTXT Name CHAR 50
    134 PAYGR Grouping Field for Automatic Payments CHAR 20
    135 XKDFB Indicator: Do not Post an Exchange Rate Difference CHAR 1
    136 ZLSPR Pmnt block CHAR 1 T008
    137 VBUND Trading Partner CHAR 6 T880
    138 AUGDT Clearing DATS 8
    139 AUGCP Clearing Entry Date DATS 8
    140 AUGBL Clrng doc. CHAR 10
    141 AWSYS Logical System CHAR 10 TBDLS
    142 AWTYP Ref. Transactn CHAR 5 TTYP
    143 AWKEY Reference Key CHAR 20
    144 ORIGIN Origin CHAR 8 TFIBLORIGIN
    145 HBKGR Group of House Bank Accounts CHAR 2 TFIBLHBG
    146 RFTTRN Payment code CHAR 20
    147 POST_NAME User who Carried Out the Posting CHAR 12 USR02
    148 POST_DATE Posting Date in Commission Case/Document (Acknowledgement) DATS 8
    149 REL_NAME Release of SAP System CHAR 12 USR02
    150 REL_DATE Date DATS 8
    151 DEDUAMNTP Deductions in Payment Currency CURR 23
    152 DEDUAMNTL Deductions in Local Currency CURR 23
    153 WTAMNTP Withholding Tax Amount in Payment Currency CURR 23
    154 WTAMNTL Withholding Tax Amount in Local Currency CURR 23
    155 KIDNO Payment Ref. CHAR 30
    156 ZIBAN IBAN (International Bank Account Number) CHAR 34
    157 SNAME1 Name 1 CHAR 35
    158 SORT01 Text Field CHAR 35
    159 SLAND1 Country Key CHAR 3
    160 .INCLUDE 0
    161 VERTN Contract Number CHAR 13
    162 EXTACCOUNT CHAR 10
    163 ZPFOR City of payee's PO box CHAR 35
    164 MGUID GUID in 'RAW' format RAW 16
    165 SNAME2 Name 2 CHAR 35
    166 SNAME3 Name 3 CHAR 35
    167 SNAME4 Name 4 CHAR 35
    168 SSTRAS Street CHAR 35
    169 SSTRS2 Street and House Number CHAR 35
    170 SPSTLZ Postal Code CHAR 10
    171 SID SID CHAR 35
    172 PURP_CODE Purpose Code (Classification of Payment or Debit Memo) CHAR 4

Related Tables

TABLE Description Functional Area
BSEG Accounting Document Segment FI - Financial Accounting
PAYR Payment Medium File FI - Payment Transactions
PCEC Prenumbered Checks FI - Payment Transactions
EBKPF Fin.Accntng Doc.Header (of Docs from Extern.Systems) FI - Financial Accounting
F111G Global Settings: Payment Program for Payment Requests FI - Automatic Payments
FDZA Cash Management line items in payment requests FI - Automatic Payments
SKAT G/L Account Master Record (Chart of Accounts: Description) FI - Financial Accounting

Transaction Codes for SAP Table PAYRQ

TCODE Description Functional Area
F111 Parameters for Payment of PRequest FI - Automatic Payments
F8BT Display Payment Requests FI - Automatic Payments
CEPC Display Table CEPC EC - Profit Center Accounting
MIRO Enter Incoming Invoice MM - Invoice Verification
F110 Parameters for Automatic Payment FI - Financial Accounting
FF63 Create Planning Memo Record FIN - Basic Functions
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
FS00 G/L acct master record maintenance FI - Basic Functions

FMs for SAP Table PAYRQ

FM Description Functional Area
BAPI_PAYMENTREQUEST_CREATE Creation of a Payment Request FI - Automatic Payments
K_KKB_FIELDCAT_MERGE Build internal table FIELDCAT from internal data table (merge) Basis - SAP List Viewer
DATE_CHECK_PLAUSIBILITY Date plausibility check 30A - Communication Services: Mail
CV120_DOC_CHECKIN_FROM_CLIENT DVS: Dokumente vom Frontend einchecken Cross Application - Document Management System
ALM_ME_ML_EQUI_CLASSVAL Multilanguage for Equipment Classification values PM - Maintenance Processing
J_1I7_USEREXIT_CHEQUENO_CERT User Exit for adding Cheque No to the internal table FI - Localization
TMS_UI_IMPORT_TR_REQUEST Transportauftrag importieren Basis - Transport Management System
OWN_LOGICAL_SYSTEM_GET Specify Name of Current Logged-on System (client in R/3 System) Basis - ALE Integration Technology

ABAP Reports for SAP Table PAYRQ

ABAP REPORT Description Functional Area
RSEINB00 IDoc inbound processing using file Basis - ALE Integration Technology
RSWUWFML Send Mails for Work Items Basis - SAP Business Workflow
RBDAPP01 Inbound Processing of IDocs Ready for Transfer Basis - ALE Integration Technology
SHP_DELIVERY_COMPLETE Manual Completion of Open Deliveries Logistics Execution - Basic Functions
RFFOUS_C International Payment Medium - Check (with check management) FI - Payment Transactions
FIBL_FRFT Rapid Entry with Repetitive Code FI - Payment Transactions
RSEOUT00 Process All Selected IDocs (EDI) Basis - ALE Integration Technology
RV80HGEN Requirements and Formulas - Completely Generated for TFRM (online) SD - Account Determination