SAP ABAP Table PAYRQ (Payment Requests)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-BL-PT-AP (Application Component) Automatic Payments
     ⤷ FMZA (Package) Payment program for payment requests
Basic Data
Table Category TRANSP    Transparent table 
Transparent table PAYRQ   Table Relationship Diagram
Short Description Payment Requests    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 KEYNO PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request  
3 ZBUKR PRQ_ZBUKR BUKRS CHAR 4   0   Paying Company Code for this Payment Request T001
4 ABSBU PRQ_ABSBU BUKRS CHAR 4   0   Sending Company Code for Payment Requests T001
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
7 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
8 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
9 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
10 USNAM USNAM XUBNAME CHAR 12   0   User name USR02
11 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
12 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
13 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
14 WAERS PRQ_DOCUR WAERS CUKY 5   0   Currency Key of the Invoice TCURC
15 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency TCURC
16 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency TCURC
17 PACUR PRQ_PACUR WAERS CUKY 5   0   Payment Request Currency Key TCURC
18 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
19 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
20 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
21 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
22 PAMTL PRQ_AMTLC WERT7 CURR 13   2   Payment Request Amount in Local Currency  
23 PAMTF PRQ_AMTFC WERT7 CURR 13   2   Payment Request Amount in Payment Currency  
24 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
25 KOART KOART KOART CHAR 1   0   Account type  
26 PARNO PRQ_PARNO PRQ_PARNO CHAR 10   0   Business Partner  
27 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account SKA1
28 PAYEE PRQ_PAYEE PRQ_PARNO CHAR 10   0   Account Number of the Alternative Payee  
29 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
30 ANRED ANRED TEXT15 CHAR 15   0   Title  
31 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
32 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
33 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
34 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
35 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
36 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
37 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
38 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
39 PFACH PFACH PFACH CHAR 10   0   PO Box  
40 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
41 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
42 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk T001S
43 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
44 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
45 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange T015W
46 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 T015W1
47 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 T015W1
48 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 T015W1
49 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 T015W1
50 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
51 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
52 ZANRE DZANRE TEXT15 CHAR 15   0   Title of the payee  
53 ZNME1 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
54 ZNME2 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
55 ZNME3 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
56 ZNME4 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
57 ZPSTL DZPSTL PSTLZ CHAR 10   0   Postal code of the payee  
58 ZORT1 DZORT1 TEXT35 CHAR 35   0   City of the payee  
59 ZPST2 DZPST2 PSTLZ CHAR 10   0   P.O. box postal code of the payee  
60 ZSTRA DZSTRA TEXT35 CHAR 35   0   Street and house number of the payee  
61 ZPFAC DZPFAC PFACH CHAR 10   0   P.O. box of the payee  
62 ZLAND DZLAND LAND1 CHAR 3   0   Country Key T005
63 ZREGI DZREGI REGIO CHAR 3   0   Regional code of the payee T005S
64 ZSPRA SPRAS SPRAS LANG 1   0   Language Key T002
65 EIKTO EIKTO CHAR12 CHAR 12   0   Shipper's (Our) Account Number at the Customer or Vendor  
66 ZTLFX TELFX TEXT31 CHAR 31   0   Fax Number  
67 ZTELF TELF1 TEXT16 CHAR 16   0   First telephone number  
68 ZTELX TELX1 TEXT30 CHAR 30   0   Telex number  
69 HKTID HKTID HKTID CHAR 5   0   ID for account details T012K
70 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
71 UBNKY UBNKY BANKK CHAR 15   0   Bank key of our bank BNKA
72 UBNKS BANKS LAND1 CHAR 3   0   Bank country key T005
73 UBNKL UBNKL BANKL CHAR 15   0   Bank number of our bank  
74 UIBAN UIBAN IBAN CHAR 34   0   IBAN at our House Bank  
75 UBKNT UBKNT BANKN CHAR 18   0   Our account number at the bank  
76 UBKON UBKON BKONT CHAR 2   0   Bank control key at our bank  
77 UBNKR PRQ_UBNKR REGIO CHAR 3   0   Regional Code of the House Bank T005S
78 UBHKT UBHKT SAKNR CHAR 10   0   G/L Account Number for Our Bank Account / Bank Sub-Account SKA1
79 BKHBK PRQ_BKHBK SAKNR CHAR 10   0   G/L Account for Bank Clearing Account SKA1
80 .INCLUDE       0   0   REGUH extension for the payment request  
81 BTYP1 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
82 BNKS1 BANKS LAND1 CHAR 3   0   Bank country key *
83 BNKL1 BANKK BANKK CHAR 15   0   Bank Keys  
84 BNKN1 BANKN BANKN CHAR 18   0   Bank account number  
85 BKON1 BKONT BKONT CHAR 2   0   Bank Control Key  
86 BKRF1 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
87 IBAN1 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
88 BTYP2 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
89 BNKS2 BANKS LAND1 CHAR 3   0   Bank country key *
90 BNKL2 BANKK BANKK CHAR 15   0   Bank Keys  
91 BNKN2 BANKN BANKN CHAR 18   0   Bank account number  
92 BKON2 BKONT BKONT CHAR 2   0   Bank Control Key  
93 BKRF2 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
94 IBAN2 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
95 BTYP3 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
96 BNKS3 BANKS LAND1 CHAR 3   0   Bank country key *
97 BNKL3 BANKK BANKK CHAR 15   0   Bank Keys  
98 BNKN3 BANKN BANKN CHAR 18   0   Bank account number  
99 BKON3 BKONT BKONT CHAR 2   0   Bank Control Key  
100 BKRF3 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
101 IBAN3 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
102 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
103 ZBNKS DZBNKS LAND1 CHAR 3   0   Country Key T005
104 ZBNKN DZBNKN BANKN CHAR 18   0   Bank account number of the payee  
105 ZBNKL DZBNKL BANKL CHAR 15   0   Bank number of the payee's bank  
106 ZBNKY DZBNKY BANKK CHAR 15   0   Bank key of the payee's bank BNKA
107 ZBKON DZBKON BKONT CHAR 2   0   Bank Control Key of the Payee's Bank  
108 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
109 ZBNKR PRQ_ZBNKR REGIO CHAR 3   0   Regional Code of the Payee's Bank T005S
110 SWIFT SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
111 KOINH KOINH_FI KOINH CHAR 60   0   Account Holder Name  
112 ZGSBR PRQ_ZGSBR GSBER CHAR 4   0   Business Area: Offsetting Posting TGSB
113 GGRUP PRQ_ZHKONT SAKNR CHAR 10   0   Partner Bank's Account No. for Bank Account Transfers SKA1
114 XRELD PRQ_XRELD X CHAR 1   0   Indicator: Released for Posting  
115 XRELI PRQ_XRELI X CHAR 1   0   Indicator: Complete  
116 XRELP PRQ_XRELP X CHAR 1   0   Indicator: Released for Payment  
117 XREVE PRQ_XREVE XFELD CHAR 1   0   Indicator: Payment Request is Reversed  
118 STGRD STGRD STGRD CHAR 2   0   Reason for Reversal T041C
119 XURGE PRQ_XURGE X CHAR 1   0   Indicator: Extremely Urgent Payment  
120 TAGE1 TAGE1 NUM04 NUMC 4   0   Residence time 1  
121 DUEDT PRQ_DUEDT DATUM DATS 8   0   Payment Request Due Date  
122 VALUT PRQ_VALDT DATUM DATS 8   0   Value Date for the Sending Bank  
123 CRVAL PRQ_CRVAL DATUM DATS 8   0   Value Date at Payee's Bank  
124 IMPER PRQ_IMPER PRQ_IMPER CHAR 1   0   Value Date may no Longer be Changed  
125 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
126 XPORE PRQ_XPORE XFELD CHAR 1   0   Indicator: Individual Payment?  
127 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
128 ZWELS DZWELS ZWELS CHAR 10   0   List of the Payment Methods to be Considered  
129 XEZER XEZER XFELD CHAR 1   0   Indicator: Is there collection authorization ?  
130 SWTXT PRQ_SWTXT PRQ_SWTXT CHAR 140   0   Swift Text  
131 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
132 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
133 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
134 PAYGR PAYGR CHAR20 CHAR 20   0   Grouping Field for Automatic Payments  
135 XKDFB XKDFB_042E XFELD CHAR 1   0   Do not Post any Exchange Rate Differences  
136 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
137 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
138 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
139 AUGCP AUGCP DATUM DATS 8   0   Clearing Entry Date  
140 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
141 AWSYS LOGSYSTEM LOGSYS CHAR 10   0   Logical System TBDLS
142 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure TTYP
143 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
144 ORIGIN FIBL_ORIGIN FIBL_ORIGIN CHAR 8   0   Origin Indicator TFIBLORIGIN
145 HBKGR FIBL_HBG FIBL_HBG CHAR 2   0   Group of House Bank Accounts TFIBLHBG
146 RFTTRN RFTTRN_BF RFTTRN_BF CHAR 20   0   Payment code  
147 POST_NAME PRQ_POSTNAME XUBNAME CHAR 12   0   User who Carried Out the Posting USR02
148 POST_DATE PRQ_POSTDATE DATUM DATS 8   0   Day on Which Payment Request was Posted  
149 REL_NAME PRQ_RELNAME XUBNAME CHAR 12   0   User who Carried Out the Release USR02
150 REL_DATE PRQ_RELDATE DATUM DATS 8   0   Release Date for Payment  
151 DEDUAMNTP PRQ_DEDUAMNTP WERT7 CURR 13   2   Deductions in Payment Currency  
152 DEDUAMNTL PRQ_DEDUAMNTL WERT7 CURR 13   2   Deductions in Local Currency  
153 WTAMNTP PRQ_WTAMNTP WERT7 CURR 13   2   Withholding Tax Amount in Payment Currency  
154 WTAMNTL PRQ_WTAMNTL WERT7 CURR 13   2   Withholding Tax Amount in Local Currency  
155 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
156 ZIBAN DZIBAN IBAN CHAR 34   0   IBAN of the Payee  
157 SNAME1 NAME1_GP NAME CHAR 35   0   Name 1  
158 SORT01 ORT01_GP TEXT35 CHAR 35   0   City  
159 SLAND1 LAND1_GP LAND1 CHAR 3   0   Country Key *
160 .INCLUDE       0   0   Incl. for Payment Requests (for example Fields from REGUP)  
161 VERTN RANL RANL CHAR 13   0   Contract Number  
162 ZPFOR PFORT_Z TEXT35 CHAR 35   0   City of payee's PO box  
163 MGUID SEPA_MGUID   RAW 16   0   SEPA Mandate: GUID of Mandate  
164 SNAME2 NAME2_GP NAME CHAR 35   0   Name 2  
165 SNAME3 NAME3_GP NAME CHAR 35   0   Name 3  
166 SNAME4 NAME4_GP NAME CHAR 35   0   Name 4  
167 SSTRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
168 SSTRS2 STRAS_GP TEXT35 CHAR 35   0   House number and street  
169 SPSTLZ PSTLZ_BAS PSTLZ CHAR 10   0   Postal code  
170 SID SENDER_ID CHAR35 CHAR 35   0   Original Payer of a Payment (ID)  
171 PURP_CODE FPM_PURP_CODE CHAR4 CHAR 4   0   SEPA Purpose Code: Classification of a Payment/Debit Memo  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PAYRQ ABSBU T001 BUKRS REF 1 CN
2 PAYRQ AWSYS TBDLS LOGSYS REF 1 CN
3 PAYRQ AWTYP TTYP AWTYP REF 1 CN
4 PAYRQ BKHBK SKA1 SAKNR REF 1 CN
5 PAYRQ BUKRS T001 BUKRS REF 1 CN
6 PAYRQ BUSAB T001S BUSAB REF 1 CN
7 PAYRQ DTAWS T015W DTAWS REF 1 CN
8 PAYRQ DTWS1 T015W1 DTWSX REF 1 CN
9 PAYRQ DTWS2 T015W1 DTWSX REF 1 CN
10 PAYRQ DTWS3 T015W1 DTWSX REF 1 CN
11 PAYRQ DTWS4 T015W1 DTWSX REF 1 CN
12 PAYRQ GGRUP SKA1 SAKNR REF 1 CN
13 PAYRQ GSBER TGSB GSBER REF 1 CN
14 PAYRQ HBKGR TFIBLHBG HBKGR REF 1 CN
15 PAYRQ HBKID T012 HBKID REF 1 CN
16 PAYRQ HKONT SKA1 SAKNR REF 1 CN
17 PAYRQ HKTID T012K HKTID REF 1 CN
18 PAYRQ HWAE2 TCURC WAERS REF 1 CN
19 PAYRQ HWAE3 TCURC WAERS REF 1 CN
20 PAYRQ HWAER TCURC WAERS REF 1 CN
21 PAYRQ LAND1 T005 LAND1 REF 1 CN
22 PAYRQ LANDL T005 LAND1 REF 1 CN
23 PAYRQ LZBKZ T015L LZBKZ REF 1 CN
24 PAYRQ MANDT T000 MANDT KEY 1 CN
25 PAYRQ ORIGIN TFIBLORIGIN ORIGIN REF 1 CN
26 PAYRQ PACUR TCURC WAERS    
27 PAYRQ POST_NAME USR02 BNAME REF 1 CN
28 PAYRQ REGIO T005S BLAND REF 1 CN
29 PAYRQ REL_NAME USR02 BNAME REF 1 CN
30 PAYRQ STGRD T041C STGRD REF 1 CN
31 PAYRQ UBHKT SKA1 SAKNR REF 1 CN
32 PAYRQ UBNKR T005S BLAND    
33 PAYRQ UBNKS T005 LAND1 REF 1 CN
34 PAYRQ UBNKY BNKA BANKL REF 1 CN
35 PAYRQ USNAM USR02 BNAME REF 1 CN
36 PAYRQ UZAWE T042F UZAWE REF 1 CN
37 PAYRQ VBUND T880 RCOMP REF 1 CN
38 PAYRQ WAERS TCURC WAERS REF 1 CN
39 PAYRQ ZBNKR T005S BLAND REF 1 CN
40 PAYRQ ZBNKS T005 LAND1 REF 1 CN
41 PAYRQ ZBNKY BNKA BANKL REF 1 CN
42 PAYRQ ZBUKR T001 BUKRS REF 1 CN
43 PAYRQ ZGSBR TGSB GSBER REF 1 CN
44 PAYRQ ZLAND T005 LAND1 REF 1 CN
45 PAYRQ ZLSPR T008 ZAHLS REF 1 CN
46 PAYRQ ZREGI T005S BLAND REF 1 CN
47 PAYRQ ZSPRA T002 SPRAS REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in