REGUH is a standard Payment Transactions Transparent Table in SAP FI application, which stores Settlement data from payment program 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 REGUH. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
REGUH — Meta Data
Description: | Settlement data from payment program |
Main Category: | FI |
Sub Category: | Payment Transactions |
Table type: | Transparent Table (TRANSP) |
REGUH — 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 | LAUFD | Date on Which the Program Is to Be Run | X | DATS | 8 | |
3 | LAUFI | Additional Identification | X | CHAR | 6 | |
4 | XVORL | Indicator: Only Proposal Run? | X | CHAR | 1 | |
5 | ZBUKR | Paying company code | X | CHAR | 4 | T001 |
6 | LIFNR | Vendor | X | CHAR | 10 | LFA1 |
7 | KUNNR | Customer | X | CHAR | 10 | KNA1 |
8 | EMPFG | Payee code | X | CHAR | 16 | |
9 | VBLNR | Accounting Document Number | X | CHAR | 10 | |
10 | AVISG | Reason for Printing Payment Advice | CHAR | 1 | ||
11 | WAERS | Currency | CUKY | 5 | TCURC | |
12 | SRTGB | Business Area | CHAR | 4 | TGSB | |
13 | ANRED | Form of address | CHAR | 15 | ||
14 | NAME1 | Name 1 | CHAR | 35 | ||
15 | NAME2 | Name 2 | CHAR | 35 | ||
16 | NAME3 | Name 3 | CHAR | 35 | ||
17 | NAME4 | Name 4 | CHAR | 35 | ||
18 | PSTLZ | P.Code/City | CHAR | 10 | ||
19 | ORT01 | City | CHAR | 35 | ||
20 | STRAS | House number and street | CHAR | 35 | ||
21 | PFACH | PO Box | CHAR | 10 | ||
22 | LAND1 | Country | CHAR | 3 | T005 | |
23 | STCD1 | Tax Number 1 | CHAR | 16 | ||
24 | WEVWV | Single-Character Flag | CHAR | 1 | ||
25 | ZANRE | Form of address text | CHAR | 15 | ||
26 | ZNME1 | Name of the payee | CHAR | 35 | ||
27 | ZNME2 | Name 2 | CHAR | 35 | ||
28 | ZNME3 | Name 3 | CHAR | 35 | ||
29 | ZNME4 | Name of the payee | CHAR | 35 | ||
30 | ZPSTL | Postal Code of the Payee | CHAR | 10 | ||
31 | ZORT1 | Location | CHAR | 35 | ||
32 | ZSTRA | Street | CHAR | 35 | ||
33 | ZPFAC | PO Box | CHAR | 10 | ||
34 | ZLAND | Trip Country/Trip Country Group | CHAR | 3 | T005 | |
35 | ZREGI | Region (State | CHAR | 3 | T005S | |
36 | ZBNKS | Bank country key | CHAR | 3 | T005 | |
37 | ZBNKN | Bank account number of the payee | CHAR | 18 | ||
38 | ZBNKL | Bank number of the payee's bank | CHAR | 15 | ||
39 | ZBKON | Bank Control Key of the Payee's Bank | CHAR | 2 | ||
40 | ZBVTY | Bank Data Indicator for the Payee | CHAR | 4 | ||
41 | ZSWIF | SWIFT/BIC for International Payments | CHAR | 11 | ||
42 | XEZER | Indicator: Is there collection authorization ? | CHAR | 1 | ||
43 | ZSPRA | Language Key | LANG | 1 | T002 | |
44 | ZALDT | Payment date | DATS | 8 | ||
45 | RZAWE | Payment Method | CHAR | 1 | T042Z | |
46 | RUMSK | Special G/L Indicator of the Payment Transaction | CHAR | 1 | ||
47 | RZUMS | Target Special G/L Indicator of the Payment Transaction | CHAR | 1 | ||
48 | HKTID | ID for Account Details | CHAR | 5 | T012K | |
49 | HBKID | Short key for a house bank | CHAR | 5 | T012 | |
50 | HKTIW | Short Key of the Account Data for the Bill of Exchange | CHAR | 5 | T012K | |
51 | HBKIW | Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex. | CHAR | 5 | T012 | |
52 | BVTYP | Partner bank type | CHAR | 4 | ||
53 | UBKON | Bank control key at our bank | CHAR | 2 | ||
54 | UBKNT | Our account number at the bank | CHAR | 18 | ||
55 | UBNKS | Bank country key | CHAR | 3 | T005 | |
56 | UBNKL | Bank number of our bank | CHAR | 15 | ||
57 | UIBAN | IBAN (International Bank Account Number) | CHAR | 34 | ||
58 | UBHKT | G/L Account Number for Our Bank Account / Bank Subaccount | CHAR | 10 | SKB1 | |
59 | VALUT | Value date | DATS | 8 | ||
60 | CRVAL | Value Date at Payee's Bank | DATS | 8 | ||
61 | ANFAE | Bill of Exchange Payment Request Due Date | DATS | 8 | ||
62 | WEFAE | Bill of Exchange Due Date | DATS | 8 | ||
63 | RBETR | Amount Paid in Local Currency | CURR | 23 | ||
64 | RSKON | User field for cluster PC (national) | CURR | 23 | ||
65 | RWBTR | Amount paid in transaction currency | CURR | 23 | ||
66 | RWSKT | User field for cluster PC (national) | CURR | 23 | ||
67 | RSPE1 | Form Charges | CURR | 23 | ||
68 | RSPE2 | Form Charges | CURR | 23 | ||
69 | RPOST | Number of paid invoices | DEC | 5 | ||
70 | RTEXT | Object Type Text | DEC | 5 | ||
71 | RSPM1 | Form Charges for Bill of Exchange with Maximum Amount | CURR | 23 | ||
72 | RSPM2 | Form Charges for Bill of Exchange with Maximum Amount | CURR | 23 | ||
73 | WEHMX | Maximum Amount per Bill of Exchange in Local Currency | CURR | 23 | ||
74 | WEFMX | Maximum Amount per Bill of Exchange in Payment Currency | CURR | 23 | ||
75 | WEHRS | Remaining Amount in Local Crcy for Last Bill of Exchange | CURR | 23 | ||
76 | WEFRS | Remaining Amount in Payment Crcy for Last Bill of Exchange | CURR | 23 | ||
77 | WEAMX | Number of Bills of Exchange with Maximum Amount | DEC | 3 | ||
78 | BUSAB | Accounting clerk | CHAR | 2 | T001S | |
79 | EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | CHAR | 12 | ||
80 | XINVE | Indicator: Capital Goods Affected? | CHAR | 1 | ||
81 | WDATE | Work Joining Date | DATS | 8 | ||
82 | XAEND | Text for change or deletion | CHAR | 1 | ||
83 | ZLSPR | Pmnt block | CHAR | 1 | T008 | |
84 | DTAWS | Instruction key for data medium exchange | CHAR | 2 | ||
85 | DTAMS | Report key for data medium exchange | CHAR | 1 | ||
86 | KURSF | Exchange rate | DEC | 9 | ||
87 | ABWAE | Settlement currency for bank transfers | CUKY | 5 | TCURC | |
88 | SKVHW | Lost Cash Discount in Local Currency | CURR | 23 | ||
89 | SKVFW | Lost Cash Discount in Payment Currency | CURR | 23 | ||
90 | DSKVH | Impending Lost Cash Discount in Local Currency | CURR | 23 | ||
91 | ZPST2 | PO Box Postal Code | CHAR | 10 | ||
92 | PAYGR | Grouping Field for Automatic Payments | CHAR | 20 | ||
93 | ZBNKY | Bank key of the payee's bank | CHAR | 15 | ||
94 | UBNKY | Bank key of our bank | CHAR | 15 | ||
95 | PSTL2 | P.O. Box Postal Code | CHAR | 10 | ||
96 | ABSBU | Sending company code | CHAR | 4 | T001 | |
97 | RBET2 | Amount Paid in Second Local Currency | CURR | 23 | ||
98 | RBET3 | Amount Paid in Third Local Currency | CURR | 23 | ||
99 | RSKO2 | Payment Transaction Total Discount in Second Local Currency | CURR | 23 | ||
100 | RSKO3 | Payment Transaction Total Discount in Third Local Currency | CURR | 23 | ||
101 | KURS2 | Exchange Rate for the Second Local Currency | DEC | 9 | ||
102 | KURS3 | Exchange Rate for the Third Local Currency | DEC | 9 | ||
103 | BKREF | Reference specifications for bank details | CHAR | 20 | ||
104 | UZAWE | Pmt meth.supl. | CHAR | 2 | T042F | |
105 | ZORT2 | District | CHAR | 35 | ||
106 | ZTLFX | Payee's telefax number | CHAR | 31 | ||
107 | XSIWE | Indicator: Bill on demand | CHAR | 1 | ||
108 | ZPFOR | City of payee's PO box | CHAR | 35 | ||
109 | PERNR | Personnel No. | NUMC | 8 | ||
110 | SEQNR | Sequence Number | CHAR | 5 | ||
111 | BTZNR | Assignment of Transfers | RAW | 1 | ||
112 | AUSFD | Due date of the paid items | DATS | 8 | ||
113 | AUGDT | Clearing | DATS | 8 | ||
114 | EDIAV | EDI Payment Advice Status | CHAR | 1 | ||
115 | IDOC_NUM_AVIS | IDoc number | NUMC | 16 | ||
116 | EDIBN | EDI Payment Order Status | CHAR | 1 | ||
117 | IDOC_NUM | IDoc number | NUMC | 16 | ||
118 | ZTELF | Payee telephone number | CHAR | 20 | ||
119 | ZTELX | Payee telex number | CHAR | 30 | ||
120 | KOINH | Account Holder Name | CHAR | 60 | ||
121 | DTWS1 | Instruct.key 1 | NUMC | 2 | ||
122 | DTWS2 | Instruct. key 2 | NUMC | 2 | ||
123 | DTWS3 | Instruct. key 3 | NUMC | 2 | ||
124 | DTWS4 | Instruct. key 4 | NUMC | 2 | ||
125 | ZSTC1 | Payee's tax number 1 | CHAR | 16 | ||
126 | KIDNO | Payment Ref. | CHAR | 30 | ||
127 | PYORD | Payment Order | CHAR | 10 | ||
128 | REGIO | Region (State | CHAR | 3 | ||
129 | TEXT | Text of anonymization set | CHAR | 29 | ||
130 | BTYP1 | Type of bank in a bank chain (correspondent | CHAR | 1 | ||
131 | BNKS1 | Bank country key | CHAR | 3 | ||
132 | BNKL1 | Bank Keys | CHAR | 15 | ||
133 | BNKN1 | Bank account number | CHAR | 18 | ||
134 | BKON1 | Bank Control Key | CHAR | 2 | ||
135 | BKRF1 | Reference specifications for bank details | CHAR | 20 | ||
136 | IBAN1 | IBAN (International Bank Account Number) | CHAR | 34 | ||
137 | BTYP2 | Type of bank in a bank chain (correspondent | CHAR | 1 | ||
138 | BNKS2 | Bank country key | CHAR | 3 | ||
139 | BNKL2 | Bank Keys | CHAR | 15 | ||
140 | BNKN2 | Alternative Bank Acct Number (for Ambiguous Acct Number) | CHAR | 18 | ||
141 | BKON2 | Bank Control Key | CHAR | 2 | ||
142 | BKRF2 | Reference specifications for bank details | CHAR | 20 | ||
143 | IBAN2 | IBAN (International Bank Account Number) | CHAR | 34 | ||
144 | BTYP3 | Type of bank in a bank chain (correspondent | CHAR | 1 | ||
145 | BNKS3 | Bank country key | CHAR | 3 | ||
146 | BNKL3 | Bank Keys | CHAR | 15 | ||
147 | BNKN3 | Bank account number | CHAR | 18 | ||
148 | BKON3 | Bank Control Key | CHAR | 2 | ||
149 | BKRF3 | Reference specifications for bank details | CHAR | 20 | ||
150 | IBAN3 | IBAN (International Bank Account Number) | CHAR | 34 | ||
151 | SAKNR | G/L Account | CHAR | 10 | ||
152 | HKONT | G/L | CHAR | 10 | ||
153 | ALEBN | ALE: PCA document number in system where created | CHAR | 1 | ||
154 | XKDFB | Indicator: Do not Post an Exchange Rate Difference | CHAR | 1 | ||
155 | SRTBP | Business Place | CHAR | 4 | ||
156 | .INCLUDE | 0 | ||||
157 | FPM_KEY | Rundate | CHAR | 15 | ||
158 | GRPNO | Count parameters | INT4 | 10 | ||
159 | SRTF1 | Char 20 | CHAR | 38 | ||
160 | SRTF2 | Next record counter of cluster table | CHAR | 56 | ||
161 | SRTF3 | Field Name | CHAR | 38 | ||
162 | XCORR | Checkbox | CHAR | 1 | ||
163 | XAVIS | Display Field - Payment Advice Required by User | CHAR | 1 | ||
164 | XCOPM | Payment Medium for Business Partner (Correspondence) | CHAR | 1 | ||
165 | DORIGIN | Origin Indicator | CHAR | 8 | ||
166 | RFTTRN | Payment code | CHAR | 20 | ||
167 | ZADNR | Address number | CHAR | 10 | ||
168 | ADRNR | Address | CHAR | 10 | ||
169 | ZIBAN | IBAN (International Bank Account Number) | CHAR | 34 | ||
170 | MGUID | GUID in 'RAW' format | RAW | 16 | ||
171 | SEQ_TYPE | SEPA: Sequence Type | CHAR | 4 | ||
172 | INST_CODE | Local Instrument Code | CHAR | 4 | ||
173 | PURP_CODE | Purpose Code (Classification of Payment or Debit Memo) | CHAR | 4 | ||
174 | XMLST | Status of XML Payment Advice | CHAR | 1 | ||
175 | TIMESTAMP_AVIS | Time Stamp for Sending XML Payment Advice | DEC | 15 | ||
176 | .INCLU--AP | 0 | ||||
177 | FM_STATUS | Availability Status for a Payment | CHAR | 1 | ||
178 | .INCLU--AP | 0 | ||||
179 | FILE_NBR | Key for multiple files from single Payment Program Print | NUMC | 6 |
SAP Help, Wiki Resources, and Forum Discussions on REGUH
Click the above link for the full list of resources and help pages, only the first few are posted below
-
BSEG_SGTXT_REGUH_SGTXT | SCN
bseg text is not coping to regup sgtxt if i give * also in line iteam leavel...please let me know any alternative way to get text check printing?
http://scn.sap.com/message/10155112
-
Bank chain details in REGUH via F110 | SCN
Bank chain is configured after activating the bank chain, you need to set up the relationship among your vendor bank, your housebank and a correspondent (intermediary) bank vide FIBPU. Once this is done, you can send payments to any banks in the world even if your housebank do not have any relationship with the vendor bank. You can have a maximum of 3 intermediaries.
http://scn.sap.com/message/7063051
-
How can I link REGUP and REGUH table | SCN
This question is answered
http://scn.sap.com/message/6578407
-
Any Business Event to substitute , bank account id (REGUH-HKTID).
. If the payment is for a customer (REGUH-KUNNR) and it is payment methods (REGUH-RZAWE) u2018Tu2019 or C, and the currency (REGUH-WAERS) is AUD
http://scn.sap.com/message/11000238
-
Which datasource has PAYR and REGUH tables | SCN
Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...
http://scn.sap.com/message/10351257
-
Bank details in REGUH | SCN
I am not able to see the bank details that we maintained on vendor master data in REGUH table when payment run is done. Is there some config or update i need to do or does it not update the REGUH table?
http://scn.sap.com/message/7442928
-
Get REGUH statement | SCN
What is the use of get keaword and what it does on the table REGUH (get REGUH).
http://scn.sap.com/message/4810066
-
What is PAYR, REGUH and REGUP tables. | SCN
i need to get extract data for active and inactive vendors and both paid and unpaid transactions.
http://scn.sap.com/message/4839639
-
Remove leading space(blank) REGUH-RWBTR in script | SCN
the amount field i use is REGUH-RWBTR in script. but the output come with leading of space.
http://scn.sap.com/message/4156684
-
Regarding tables REGUH and REGUP | SCN
I want to update the tables REGUH and REGUP.Please let me know how to get it done.
http://scn.sap.com/message/3744953
-
Have regup , REGUH table How to get check number. | SCN
Have regup , REGUH table How to get check number from PAYR table.
http://scn.sap.com/message/4495192
Related Tables
TABLE | Description | Functional Area |
---|---|---|
REGUP | Processed items from payment program | FI - Payment Transactions |
BSEG | Accounting Document Segment | FI - Financial Accounting |
PAYR | Payment Medium File | FI - Payment Transactions |
REGUD | Form print transfer data | FI - Payment Transactions |
BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | FI - Financial Accounting |
BNKA | Bank master record | Cross Application - Bank |
REGUV | Control records for the payment program | FI - Payment Transactions |
Transaction Codes for SAP Table REGUH
TCODE | Description | Functional Area |
---|---|---|
F110 | Parameters for Automatic Payment | FI - Financial Accounting |
FBZP | Maintain Pmnt Program Configuration | FI - Financial Accounting |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
F-58 | Payment with Printout | FI - Financial Accounting |
SE38 | ABAP Editor | Basis - ABAP Editor |
FBL1N | Vendor Line Items | FI - Information System |
F-53 | Post Outgoing Payments | FI - Financial Accounting |
SE16 | Data Browser | Basis - Workbench Utilities |
FMs for SAP Table REGUH
FM | Description | Functional Area |
---|---|---|
CONVERSION_EXIT_ALPHA_INPUT | Conversion exit ALPHA, external->internal | Basis - Syntax, Compiler, Runtime |
WRITE_FORM | SAPscript: Output text element in form window | Basis - SAPscript |
OPEN_FORM | SAPscript: Open form printing | Basis - SAPscript |
SPELL_AMOUNT | Spell Out Numbers | Cross Application - Country-Specific Objects |
CLOSE_FORM | SAPscript: End layout set printing | Basis - SAPscript |
F4IF_INT_TABLE_VALUE_REQUEST | F4 help also returning the value to be displayed in internal table | Basis - F4 Help |
USER_SETTINGS | User settings | Basis - Terminology/Glossary |
SSF_FUNCTION_MODULE_NAME | Basis - Smart Forms |
ABAP Reports for SAP Table REGUH
ABAP REPORT | Description | Functional Area |
---|---|---|
RFFOUS_C | International Payment Medium - Check (with check management) | FI - Payment Transactions |
RFFOUS_T | Payment Medium USA - Transfers/Bank Direct Debits in ACH Format | FI - Payment Transactions |
RFFOEDI1 | International Payment Medium - Payment Orders by EDI | FI - Payment Transactions |
RFZALI20 | Payment List | FI - Payment Transactions |
RFFOAVIS_FPAYM | Payment Medium - Correspondence for Generic Payment Medium Program | FI - Payment Transactions |
RFFORI06 | International Payment Medium Include: Payment Advice | FI - Payment Transactions |
SAPF110S | Payment Program | FI - Payment Transactions |
RFFORI01 | International Payment Medium Include: Check | FI - Payment Transactions |
BW Datasources for SAP Table REGUH
BW DATASOURCE | Description | Functional Area |
---|---|---|
0FI_AP_4 | Vendors: Line Items with Delta Extrcation | FI - Accounts Payable |
0FI_GL_4 | General Ledger: Line Items with Delta Extraction | FI - General Ledger Accounting |
0FI_AR_4 | Customers: Line Items with Delta Extraction | FI - Accounts Receivable |
0CO_PC_PCP_01 | Product Cost Planning: All Calculations | CO - Product Cost Controlling |
0CO_PC_PCP_03 | Product Cost Planning: Itemizations Costing | CO - Product Cost Controlling |
2LIS_03_S198 | Periodic plant stock | MM - Materials Management |
2LIS_03_BF | Goods Movements From Inventory Management | MM - Materials Management |
0CO_OM_CCA_3 | Cost centers: Activities | CO - Cost Center Accounting |
Authorization Objects for SAP Table REGUH
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_BKPF_BUK | Accounting Document: Authorization for Company Codes | |
S_TCODE | Transaction Code Check at Transaction Start | |
G_EXTRACT | Report Writer: Extract Management (obsolete, do not use) | |
F_LFA1_GRP | Vendor: Account Group Authorization | |
F_REGU_BUK | Automatic Payment: Activity Authorization for Company Codes | |
P_PERNR | HR: Master Data - Personnel Number Check | |
S_PROGRAM | ABAP: Program Flow Checks |
Most searched SAP Financial Accounting Tables
- Vendor Master Tables
- Customer Master Tables
- Company Codes Tables
- Tax Code Tables
- Gl Account Tables
- Gl Account Master Tables
- Bank Account Tables
- Withholding Tax Tables
- Payment Term Tables
- Region Tables
- Bank Details Tables
- Company Code Tables
- Payment Method Tables
- Asset Tables
- Transaction Type Tables
- Tax Jurisdiction Tables
- Customer Tables
- Vendor Tables
- Business Area Tables
- Payment Tables
- Plant Company Code Tables
- Account Assignment Tables