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)
⤷ 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
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |