SAP ABAP Table REGUH (Settlement data from payment program)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBZ (Package) Payments
Basic Data
Table Category TRANSP    Transparent table 
Transparent table REGUH   Table Relationship Diagram
Short Description Settlement data from payment program    
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 LAUFD LAUFD DATUM DATS 8   0   Date on Which the Program Is to Be Run  
3 LAUFI LAUFI LAUFI CHAR 6   0   Additional Identification  
4 XVORL XVORL XFELD CHAR 1   0   Indicator: Only Proposal Run?  
5 ZBUKR DZBUKR BUKRS CHAR 4   0   Paying company code T001
6 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
7 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
8 EMPFG EMPFG EMPFG CHAR 16   0   Payee code  
9 VBLNR VBLNR BELNR CHAR 10   0   Document Number of the Payment Document  
10 AVISG AVISG AVISG CHAR 1   0   Reason for Printing Payment Advice  
11 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
12 SRTGB GSBER GSBER CHAR 4   0   Business Area TGSB
13 ANRED ANRED TEXT15 CHAR 15   0   Title  
14 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
15 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
16 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
17 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
18 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
19 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
20 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
21 PFACH PFACH PFACH CHAR 10   0   PO Box  
22 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
23 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
24 WEVWV WEVWV WEVWV CHAR 1   0   Planned usage of the bill of exchange  
25 ZANRE DZANRE TEXT15 CHAR 15   0   Title of the payee  
26 ZNME1 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
27 ZNME2 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
28 ZNME3 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
29 ZNME4 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
30 ZPSTL DZPSTL PSTLZ CHAR 10   0   Postal code of the payee  
31 ZORT1 DZORT1 TEXT35 CHAR 35   0   City of the payee  
32 ZSTRA DZSTRA TEXT35 CHAR 35   0   Street and house number of the payee  
33 ZPFAC DZPFAC PFACH CHAR 10   0   P.O. box of the payee  
34 ZLAND DZLAND LAND1 CHAR 3   0   Country Key T005
35 ZREGI DZREGI REGIO CHAR 3   0   Regional code of the payee T005S
36 ZBNKS DZBNKS LAND1 CHAR 3   0   Country Key T005
37 ZBNKN DZBNKN BANKN CHAR 18   0   Bank account number of the payee  
38 ZBNKL DZBNKL BANKL CHAR 15   0   Bank number of the payee's bank  
39 ZBKON DZBKON BKONT CHAR 2   0   Bank Control Key of the Payee's Bank  
40 ZBVTY DZBVTY BVTYP CHAR 4   0   Bank Data Indicator for the Payee  
41 ZSWIF SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
42 XEZER XEZER XFELD CHAR 1   0   Indicator: Is there collection authorization ?  
43 ZSPRA DZSPRA SPRAS LANG 1   0   Language key of the payee T002
44 ZALDT DZALDT_ZHL DATUM DATS 8   0   Posting date of the payment document  
45 RZAWE RZAWE ZLSCH CHAR 1   0   Payment Method for This Payment T042Z
46 RUMSK RUMSK UMSKZ CHAR 1   0   Special G/L Indicator of the Payment Transaction *
47 RZUMS RZUMS UMSKZ CHAR 1   0   Target Special G/L Indicator of the Payment Transaction *
48 HKTID HKTID HKTID CHAR 5   0   ID for account details T012K
49 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
50 HKTIW HKTIW HKTID CHAR 5   0   Short Key of the Account Data for the Bill of Exchange T012K
51 HBKIW HBKIW HBKID CHAR 5   0   Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex. T012
52 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
53 UBKON UBKON BKONT CHAR 2   0   Bank control key at our bank  
54 UBKNT UBKNT BANKN CHAR 18   0   Our account number at the bank  
55 UBNKS BANKS LAND1 CHAR 3   0   Bank country key T005
56 UBNKL UBNKL BANKL CHAR 15   0   Bank number of our bank  
57 UIBAN UIBAN IBAN CHAR 34   0   IBAN at our House Bank  
58 UBHKT UBHKT SAKNR CHAR 10   0   G/L Account Number for Our Bank Account / Bank Sub-Account SKB1
59 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
60 CRVAL PRQ_CRVAL DATUM DATS 8   0   Value Date at Payee's Bank  
61 ANFAE ANFAE DATUM DATS 8   0   Bill of Exchange Payment Request Due Date  
62 WEFAE WEFAE DATUM DATS 8   0   Bill of Exchange Due Date  
63 RBETR RBETR WRTV7 CURR 13   2   Amount in Local Currency  
64 RSKON RSKON WRTV7 CURR 13   2   Total Cash Discount for the Payment Trans. (Local Currency)  
65 RWBTR RWBTR WRTV7 CURR 13   2   Amount Paid in the Payment Currency  
66 RWSKT RWSKT WRTV7 CURR 13   2   Total Cash Discount for the Pmnt Transactn in Pmnt Currency  
67 RSPE1 SPES1 WERT6 CURR 11   2   Form Charges  
68 RSPE2 SPES2 WERT6 CURR 11   2   Form Charges  
69 RPOST RPOST PACK3 DEC 5   0   Number of Items Paid  
70 RTEXT RTEXT_D PACK3 DEC 5   0   Number of Text Lines for the Items Paid  
71 RSPM1 SPEM1 WERT6 CURR 11   2   Form Charges for Bill of Exchange with Maximum Amount  
72 RSPM2 SPEM2 WERT6 CURR 11   2   Form Charges for Bill of Exchange with Maximum Amount  
73 WEHMX WEHMX WERT7 CURR 13   2   Maximum Amount per Bill of Exchange in Local Currency  
74 WEFMX WEFMX WERT7 CURR 13   2   Maximum Amount per Bill of Exchange in Payment Currency  
75 WEHRS WEHRS WERT7 CURR 13   2   Remaining Amount in Local Crcy for Last Bill of Exchange  
76 WEFRS WEFRS WERT7 CURR 13   2   Remaining Amount in Payment Crcy for Last Bill of Exchange  
77 WEAMX WEAMX PACK2 DEC 3   0   Number of Bills of Exchange with Maximum Amount  
78 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk T001S
79 EIKTO EIKTO CHAR12 CHAR 12   0   Shipper's (Our) Account Number at the Customer or Vendor  
80 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
81 WDATE WDATE DATUM DATS 8   0   Bill of Exchange Issue Date  
82 XAEND XAEND_REGU XFELD CHAR 1   0   Indicator: Payment Proposal was Changed Afterwards  
83 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
84 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
85 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
86 KURSF KURSF KURSF DEC 9   5   Exchange rate  
87 ABWAE ABWAE WAERS CUKY 5   0   Settlement currency for bank transfers TCURC
88 SKVHW SKVHW WERT7 CURR 13   2   Lost Cash Discount in Local Currency  
89 SKVFW SKVFW WERT7 CURR 13   2   Lost Cash Discount in Payment Currency  
90 DSKVH DSKVH WERT7 CURR 13   2   Impending Lost Cash Discount in Local Currency  
91 ZPST2 DZPST2 PSTLZ CHAR 10   0   P.O. box postal code of the payee  
92 PAYGR PAYGR CHAR20 CHAR 20   0   Grouping Field for Automatic Payments  
93 ZBNKY DZBNKY BANKK CHAR 15   0   Bank key of the payee's bank  
94 UBNKY UBNKY BANKK CHAR 15   0   Bank key of our bank  
95 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
96 ABSBU ABSBU BUKRS CHAR 4   0   Sending company code T001
97 RBET2 RBET2 WRTV7 CURR 13   2   Amount Paid in Second Local Currency  
98 RBET3 RBET3 WRTV7 CURR 13   2   Amount Paid in Third Local Currency  
99 RSKO2 RSKO2 WRTV7 CURR 13   2   Payment Transaction Total Discount in Second Local Currency  
100 RSKO3 RSKO3 WRTV7 CURR 13   2   Payment Transaction Total Discount in Third Local Currency  
101 KURS2 KURS2 KURSF DEC 9   5   Exchange Rate for the Second Local Currency  
102 KURS3 KURS3 KURSF DEC 9   5   Exchange Rate for the Third Local Currency  
103 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
104 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
105 ZORT2 ORT02_Z TEXT35 CHAR 35   0   Location from payee's address  
106 ZTLFX TELFX_Z TEXT31 CHAR 31   0   Payee's telefax number  
107 XSIWE XSIWE XFELD CHAR 1   0   Indicator: Bill on demand  
108 ZPFOR PFORT_Z TEXT35 CHAR 35   0   City of payee's PO box  
109 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
110 SEQNR SEQC5 CHAR5 CHAR 5   0   Sequence Number  
111 BTZNR BTZNR RAW1 RAW 1   0   Assignment of Transfers  
112 AUSFD AUSFD DATUM DATS 8   0   Due date of the paid items  
113 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
114 EDIAV EDIAV EDIST CHAR 1   0   EDI Payment Advice Status  
115 IDOC_NUM_AVIS EDI_DOCNUM EDI_DOCNUM NUMC 16   0   IDoc number  
116 EDIBN EDIBN EDIST CHAR 1   0   EDI Payment Order Status  
117 IDOC_NUM EDI_DOCNUM EDI_DOCNUM NUMC 16   0   IDoc number  
118 ZTELF TELFN_Z TEXT20 CHAR 20   0   Payee telephone number  
119 ZTELX TELEX_Z TEXT30 CHAR 30   0   Payee telex number  
120 KOINH KOINH_FI KOINH CHAR 60   0   Account Holder Name  
121 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
122 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
123 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
124 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
125 ZSTC1 STCD1_Z STCD1 CHAR 16   0   Payee's tax number 1  
126 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
127 PYORD PYORD PYORD CHAR 10   0   Payment Order  
128 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
129 TEXT TEXT FL_TEXT CHAR 29   0   Text field  
130 BTYP1 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
131 BNKS1 BANKS LAND1 CHAR 3   0   Bank country key *
132 BNKL1 BANKK BANKK CHAR 15   0   Bank Keys  
133 BNKN1 BANKN BANKN CHAR 18   0   Bank account number  
134 BKON1 BKONT BKONT CHAR 2   0   Bank Control Key  
135 BKRF1 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
136 IBAN1 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
137 BTYP2 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
138 BNKS2 BANKS LAND1 CHAR 3   0   Bank country key *
139 BNKL2 BANKK BANKK CHAR 15   0   Bank Keys  
140 BNKN2 BANKN BANKN CHAR 18   0   Bank account number  
141 BKON2 BKONT BKONT CHAR 2   0   Bank Control Key  
142 BKRF2 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
143 IBAN2 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
144 BTYP3 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
145 BNKS3 BANKS LAND1 CHAR 3   0   Bank country key *
146 BNKL3 BANKK BANKK CHAR 15   0   Bank Keys  
147 BNKN3 BANKN BANKN CHAR 18   0   Bank account number  
148 BKON3 BKONT BKONT CHAR 2   0   Bank Control Key  
149 BKRF3 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
150 IBAN3 IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
151 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
152 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
153 ALEBN ALEBN ALEIST CHAR 1   0   ALE IDoc Distribution Status of Payment Data  
154 XKDFB XKDFB_042E XFELD CHAR 1   0   Do not Post any Exchange Rate Differences  
155 SRTBP BUPLA J_1BBRANCH CHAR 4   0   Business Place *
156 .INCLUDE       0   0   Redundant Key Fields from REGUH  
157 FPM_KEY FPM_KEY   CHAR 15   0   Rundate, ID, and Default Indicator Concatenated  
158 GRPNO GRPNO_FPM GRPNO_FPM INT4 10   0   Grouping Criterium for Payments  
159 SRTF1 SRTF1N_FPM CHAR38 CHAR 38   0   Format-specific sorting of payments incl. sequence nuber  
160 SRTF2 SRTF2N_FPM CHAR56 CHAR 56   0   User-defined sorting of payments incl. sequence number  
161 SRTF3 SRTF1N_FPM CHAR38 CHAR 38   0   Format-specific sorting of payments incl. sequence nuber  
162 XCORR XCORR_FPM XFELD CHAR 1   0   Indicator: Payment Correspondence  
163 XAVIS XAVIS_FPM XFELD CHAR 1   0   Indicator: Separate Payment Advice  
164 XCOPM XCOPM_FPM XCOPM_FPM CHAR 1   0   Payment Medium for Business Partner (Correspondence)  
165 DORIGIN FIBL_DORIGIN FIBL_ORIGIN CHAR 8   0   Grouping Origin *
166 RFTTRN RFTTRN_BF RFTTRN_BF CHAR 20   0   Payment code  
167 ZADNR ADRNR_Z AD_ADDRNUM CHAR 10   0   Payee's Address Number *
168 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
169 ZIBAN DZIBAN IBAN CHAR 34   0   IBAN of the Payee  
170 MGUID SEPA_MGUID   RAW 16   0   SEPA Mandate: GUID of Mandate  
171 SEQ_TYPE SEPA_SEQ_TYPE SEPA_SEQ_TYPE CHAR 4   0   SEPA: Sequence Type  
172 INST_CODE FSEPA_INST_CODE FSEPA_INST_CODE CHAR 4   0   Local Instrument Code (Direct Debit Type)  
173 PURP_CODE FPM_PURP_CODE CHAR4 CHAR 4   0   SEPA Purpose Code: Classification of a Payment/Debit Memo  
174 XMLST XMLST_AVIS XMLST_AVIS CHAR 1   0   Status of XML Payment Advice  
175 TIMESTAMP_AVIS TIMESTAMP_AVIS FI_TIMESTAMP DEC 15   0   Time Stamp for Sending XML Payment Advice  
176 .INCLU--AP       0   0   Budget data section of payment data  
177 FM_STATUS FM_PAY_STA FM_PAY_STA CHAR 1   0   Availability Status for a Payment  
178 .INCLU--AP       0   0   U.S. Federal Government ISPS  
179 FILE_NBR FMFG_FILE_NO   NUMC 6   0   Key for multiple files from single Payment Program Print  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 REGUH ABSBU T001 BUKRS    
2 REGUH ABWAE TCURC WAERS REF C CN
3 REGUH BUSAB T001S BUSAB REF C CN
4 REGUH HBKID T012 HBKID REF 1 CN
5 REGUH HBKIW T012 HBKID REF C CN
6 REGUH HKTID T012K HKTID REF 1 CN
7 REGUH HKTIW T012K HKTID REF C CN
8 REGUH KUNNR KNA1 KUNNR KEY 1 CN
9 REGUH LAND1 T005 LAND1 REF C CN
10 REGUH LIFNR LFA1 LIFNR KEY 1 CN
11 REGUH MANDT T000 MANDT KEY 1 CN
12 REGUH RZAWE T042Z ZLSCH REF 1 CN
13 REGUH SRTGB TGSB GSBER REF C CN
14 REGUH UBHKT SKB1 SAKNR REF 1 CN
15 REGUH UBNKS T005 LAND1 REF C CN
16 REGUH UZAWE T042F UZAWE C CN
17 REGUH WAERS TCURC WAERS REF 1 CN
18 REGUH ZBNKS T005 LAND1 REF C CN
19 REGUH ZBUKR T001 BUKRS KEY 1 CN
20 REGUH ZLAND T005 LAND1 REF 1 CN
21 REGUH ZLSPR T008 ZAHLS REF C CN
22 REGUH ZREGI T005S BLAND REF C CN
23 REGUH ZSPRA T002 SPRAS REF 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in