SAP ABAP Table REGUO (Extract from the payment records for online list)

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	INTTAB	Structure
Structure	REGUO	Table Relationship Diagram
Short Description	Extract from the payment records for online list

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
2	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
3	EMPFG	EMPFG	EMPFG	CHAR	16	0	Payee code
4	VBLNR	VBLNR	BELNR	CHAR	10	0	Document Number of the Payment Document
5	AVISG	AVISG	AVISG	CHAR	1	0	Reason for Printing Payment Advice
6	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key	*
7	SRTGB	GSBER	GSBER	CHAR	4	0	Business Area	*
8	SRTBP	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
9	NAME1	NAME1_GP	NAME	CHAR	35	0	Name 1
10	ORT01	ORT01_GP	TEXT35	CHAR	35	0	City
11	LAND1	LAND1	LAND1	CHAR	3	0	Country Key	*
12	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	ZNME1	DZNME1	TEXT35	CHAR	35	0	Name of the payee
14	ZORT1	DZORT1	TEXT35	CHAR	35	0	City of the payee
15	ZLAND	DZLAND	LAND1	CHAR	3	0	Country Key	*
16	ZBNKS	DZBNKS	LAND1	CHAR	3	0	Country Key	*
17	ZBNKN	DZBNKN	BANKN	CHAR	18	0	Bank account number of the payee
18	ZBNKL	DZBNKL	BANKL	CHAR	15	0	Bank number of the payee's bank
19	ZBKON	DZBKON	BKONT	CHAR	2	0	Bank Control Key of the Payee's Bank
20	ZBVTY	DZBVTY	BVTYP	CHAR	4	0	Bank Data Indicator for the Payee
21	ZSWIF	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
22	RZAWE	RZAWE	ZLSCH	CHAR	1	0	Payment Method for This Payment	*
23	HKTID	HKTID	HKTID	CHAR	5	0	ID for account details	*
24	HBKID	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
25	HKTIW	HKTIW	HKTID	CHAR	5	0	Short Key of the Account Data for the Bill of Exchange	*
26	HBKIW	HBKIW	HBKID	CHAR	5	0	Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.	*
27	BVTYP	BVTYP	BVTYP	CHAR	4	0	Partner bank type
28	VALUT	VALUT	DATUM	DATS	8	0	Fixed Value Date
29	WDATE	WDATE	DATUM	DATS	8	0	Bill of Exchange Issue Date
30	ANFAE	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
31	WEFAE	WEFAE	DATUM	DATS	8	0	Bill of Exchange Due Date
32	WEVWV	WEVWV	WEVWV	CHAR	1	0	Planned usage of the bill of exchange
33	RBETR	RBETR	WRTV7	CURR	13	2	Amount in Local Currency
34	RSKON	RSKON	WRTV7	CURR	13	2	Total Cash Discount for the Payment Trans. (Local Currency)
35	SKVHW	SKVHW	WERT7	CURR	13	2	Lost Cash Discount in Local Currency
36	RWBTR	RWBTR	WRTV7	CURR	13	2	Amount Paid in the Payment Currency
37	RWSKT	RWSKT	WRTV7	CURR	13	2	Total Cash Discount for the Pmnt Transactn in Pmnt Currency
38	SKVFW	SKVFW	WERT7	CURR	13	2	Lost Cash Discount in Payment Currency
39	DSKVH	DSKVH	WERT7	CURR	13	2	Impending Lost Cash Discount in Local Currency
40	RPOST	RPOST	PACK3	DEC	5	0	Number of Items Paid
41	RTEXT	RTEXT_D	PACK3	DEC	5	0	Number of Text Lines for the Items Paid
42	RUMSK	RUMSK	UMSKZ	CHAR	1	0	Special G/L Indicator of the Payment Transaction	*
43	RZUMS	RZUMS	UMSKZ	CHAR	1	0	Target Special G/L Indicator of the Payment Transaction	*
44	WEHMX	WEHMX	WERT7	CURR	13	2	Maximum Amount per Bill of Exchange in Local Currency
45	WEFMX	WEFMX	WERT7	CURR	13	2	Maximum Amount per Bill of Exchange in Payment Currency
46	WEHRS	WEHRS	WERT7	CURR	13	2	Remaining Amount in Local Crcy for Last Bill of Exchange
47	WEFRS	WEFRS	WERT7	CURR	13	2	Remaining Amount in Payment Crcy for Last Bill of Exchange
48	WEAMX	WEAMX	PACK2	DEC	3	0	Number of Bills of Exchange with Maximum Amount
49	RSPE1	SPES1	WERT6	CURR	11	2	Form Charges
50	RSPE2	SPES2	WERT6	CURR	11	2	Form Charges
51	RSPM1	SPEM1	WERT6	CURR	11	2	Form Charges for Bill of Exchange with Maximum Amount
52	RSPM2	SPEM2	WERT6	CURR	11	2	Form Charges for Bill of Exchange with Maximum Amount
53	BUSAB	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
54	INSEL	INSEL	NUM01	NUMC	1	0	Indicator: Partial Selection of Postings
55	ORISO	ORISO	PACK4	DEC	7	0	Index Number for Original Sorting
56	TYPAE	TYPAE	CHAR1	CHAR	1	0	Type of Change
57	UBHKT	UBHKT	SAKNR	CHAR	10	0	G/L Account Number for Our Bank Account / Bank Sub-Account	*
58	UBKNT	UBKNT	BANKN	CHAR	18	0	Our account number at the bank
59	UBKON	UBKON	BKONT	CHAR	2	0	Bank control key at our bank
60	UBNKS	BANKS	LAND1	CHAR	3	0	Bank country key	*
61	UBNKL	UBNKL	BANKL	CHAR	15	0	Bank number of our bank
62	PAYGR	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
63	UBNKY	UBNKY	BANKK	CHAR	15	0	Bank key of our bank
64	ZBNKY	DZBNKY	BANKK	CHAR	15	0	Bank key of the payee's bank
65	KURSF	KURSF	KURSF	DEC	9	5	Exchange rate
66	RBET2	RBET2	WRTV7	CURR	13	2	Amount Paid in Second Local Currency
67	RBET3	RBET3	WRTV7	CURR	13	2	Amount Paid in Third Local Currency
68	RSKO2	RSKO2	WRTV7	CURR	13	2	Payment Transaction Total Discount in Second Local Currency
69	RSKO3	RSKO3	WRTV7	CURR	13	2	Payment Transaction Total Discount in Third Local Currency
70	KURS2	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
71	KURS3	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
72	BKREF	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
73	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
74	ZPFOR	PFORT_Z	TEXT35	CHAR	35	0	City of payee's PO box
75	AUSFD	AUSFD	DATUM	DATS	8	0	Due date of the paid items
76	AUGDT	AUGDT	DATUM	DATS	8	0	Clearing Date
77	DTAWS	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
78	EDIAV	EDIAV	EDIST	CHAR	1	0	EDI Payment Advice Status
79	EDIBN	EDIBN	EDIST	CHAR	1	0	EDI Payment Order Status
80	KOINH	KOINH_FI	KOINH	CHAR	60	0	Account Holder Name
81	DTWS1	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
82	DTWS2	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
83	DTWS3	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
84	DTWS4	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
85	KIDNO	KIDNO	CHAR30	CHAR	30	0	Payment Reference
86	PYORD	PYORD	PYORD	CHAR	10	0	Payment Order
87	VERTN	RANL	RANL	CHAR	13	0	Contract Number
88	VBEWA	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
89	BTYP1	BNTYP	BNTYP	CHAR	1	0	Type of bank in a bank chain (correspondent, intermediary)
90	BNKS1	BANKS	LAND1	CHAR	3	0	Bank country key	*
91	BNKL1	BANKK	BANKK	CHAR	15	0	Bank Keys
92	BNKN1	BANKN	BANKN	CHAR	18	0	Bank account number
93	BKON1	BKONT	BKONT	CHAR	2	0	Bank Control Key
94	BTYP2	BNTYP	BNTYP	CHAR	1	0	Type of bank in a bank chain (correspondent, intermediary)
95	BNKS2	BANKS	LAND1	CHAR	3	0	Bank country key	*
96	BNKL2	BANKK	BANKK	CHAR	15	0	Bank Keys
97	BNKN2	BANKN	BANKN	CHAR	18	0	Bank account number
98	BKON2	BKONT	BKONT	CHAR	2	0	Bank Control Key
99	BTYP3	BNTYP	BNTYP	CHAR	1	0	Type of bank in a bank chain (correspondent, intermediary)
100	BNKS3	BANKS	LAND1	CHAR	3	0	Bank country key	*
101	BNKL3	BANKK	BANKK	CHAR	15	0	Bank Keys
102	BNKN3	BANKN	BANKN	CHAR	18	0	Bank account number
103	BKON3	BKONT	BKONT	CHAR	2	0	Bank Control Key
104	SAKNR	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
105	XURGE	PRQ_XURGE	X	CHAR	1	0	Indicator: Extremely Urgent Payment
106	ZIBAN	DZIBAN	IBAN	CHAR	34	0	IBAN of the Payee
107	MGUID	SEPA_MGUID		RAW	16	0	SEPA Mandate: GUID of Mandate
108	MNDID	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
109	SEQ_TYPE	SEPA_SEQ_TYPE	SEPA_SEQ_TYPE	CHAR	4	0	SEPA: Sequence Type
110	INST_CODE	FSEPA_INST_CODE	FSEPA_INST_CODE	CHAR	4	0	Local Instrument Code (Direct Debit Type)