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