SAP REGUH Table: Settlement Data from Payment Program

What Is the SAP REGUH Table?

SAP REGUH Table stores settlement data generated by the automatic payment program in SAP Financial Accounting (FI).

When the payments are processed using transaction Code F110, SAP generates payment information for selected customers and vendors and stores the relevant settlement data in REGUH table.

REGUH table contains information such as Payment Run Date, Payment Run Identification, Paying Company Code, Payment Recipient, Payment Document Number, and Payment Amount.

This table is used to review payment details generated during automatic payment processing. Each payment record is linked to one or more corresponding payment items maintained in REGUP table (processed items from payment program).

SAP REGUH Table for Settlement Data from Payment Program

Quick overview

SAP table	REGUH
Short description	Settlement data from payment program
Table type	Transparent table
Primary key	MANDT (Client), LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), XVORL (Indicator: Only Proposal Run?), ZBUKR (Paying company code), LIFNR (Account Number of Supplier), KUNNR (Customer Number), EMPFG (Payment Recipient Code), VBLNR (Document Number of the Payment Document)
Client-dependent	Yes

At a glance

Module: Financial Accounting FI
Application component: ACCOUNTS PAYABLE FI-AP
Subcomponent: BASIC FUNCTIONS FI-AP-AP
Specific component: PAYMENT PROGAM / PAYMENT TRANSFER (DE, JP, US) FI-AP-AP-B

Technical details

Delivery class: A (Application table: master and transaction data)
Data class: APPL1 (Transaction Data, Transparent Tables)
Package: Payments (FBZ)

Primary key fields

Field	Description	Data element	Type	Length
`MANDT`	Client	MANDT	CLNT	3
`LAUFD`	Date on Which the Program Is to Be Run	LAUFD	DATS	8
`LAUFI`	Additional Identification	LAUFI	CHAR	6
`XVORL`	Indicator: Only Proposal Run?	XVORL	CHAR	1
`ZBUKR`	Paying company code	DZBUKR	CHAR	4
`LIFNR`	Account Number of Supplier	LIFNR	CHAR	10
`KUNNR`	Customer Number	KUNNR	CHAR	10
`EMPFG`	Payment Recipient Code	EMPFG	CHAR	16
`VBLNR`	Document Number of the Payment Document	VBLNR	CHAR	10

Table fields

184 fields

Search fields

Key status

Data type

184 fields

Field	Description	Data element	Domain	Type	Length	Decimals	Check table
`MANDT` Key	Client	MANDT	MANDT	CLNT	3	—	T000
`LAUFD` Key	Date on Which the Program Is to Be Run	LAUFD	DATUM	DATS	8	—
`LAUFI` Key	Additional Identification	LAUFI	LAUFI	CHAR	6	—
`XVORL` Key	Indicator: Only Proposal Run?	XVORL	XFELD	CHAR	1	—
`ZBUKR` Key	Paying company code	DZBUKR	BUKRS	CHAR	4	—	T001
`LIFNR` Key	Account Number of Supplier	LIFNR	LIFNR	CHAR	10	—	LFA1
`KUNNR` Key	Customer Number	KUNNR	KUNNR	CHAR	10	—	KNA1
`EMPFG` Key	Payment Recipient Code	EMPFG	EMPFG	CHAR	16	—
`VBLNR` Key	Document Number of the Payment Document	VBLNR	BELNR	CHAR	10	—
`AVISG`	Reason for Printing Payment Advice	AVISG	AVISG	CHAR	1	—
`WAERS`	Currency Key	WAERS	WAERS	CUKY	5	—	TCURC
`SRTGB`	Business Area	GSBER	GSBER	CHAR	4	—	TGSB
`ANRED`	Title	ANRED	TEXT15	CHAR	15	—
`NAME1`	Name 1	NAME1_GP	NAME	CHAR	35	—
`NAME2`	Name 2	NAME2_GP	NAME	CHAR	35	—
`NAME3`	Name 3	NAME3_GP	NAME	CHAR	35	—
`NAME4`	Name 4	NAME4_GP	NAME	CHAR	35	—
`PSTLZ`	Postal Code	PSTLZ	PSTLZ	CHAR	10	—
`ORT01`	City	ORT01_GP	TEXT35	CHAR	35	—
`STRAS`	Street and House Number	STRAS_GP	TEXT35	CHAR	35	—
`PFACH`	PO Box	PFACH	PFACH	CHAR	10	—
`LAND1`	Country/Region Key	LAND1	LAND1	CHAR	3	—	T005
`STCD1`	Tax Number 1	STCD1	STCD1	CHAR	16	—
`WEVWV`	Planned Usage of the Bill of Exchange	WEVWV	WEVWV	CHAR	1	—
`ZANRE`	Title of the payee	DZANRE	TEXT15	CHAR	15	—
`ZNME1`	Name of the payee	DZNME1	TEXT35	CHAR	35	—
`ZNME2`	Name of the payee	DZNME1	TEXT35	CHAR	35	—
`ZNME3`	Name of the payee	DZNME1	TEXT35	CHAR	35	—
`ZNME4`	Name of the payee	DZNME1	TEXT35	CHAR	35	—
`ZPSTL`	Postal Code of the Payee	DZPSTL	PSTLZ	CHAR	10	—
`ZORT1`	City of the payee	DZORT1	TEXT35	CHAR	35	—
`ZSTRA`	Street and house number of the payee	DZSTRA	TEXT35	CHAR	35	—
`ZPFAC`	P.O. box of the payee	DZPFAC	PFACH	CHAR	10	—
`ZLAND`	Country/Region Key	DZLAND	LAND1	CHAR	3	—	T005
`ZREGI`	Regional code of the payee	DZREGI	REGIO	CHAR	3	—	T005S
`ZBNKS`	Country/Region Key	DZBNKS	LAND1	CHAR	3	—	T005
`ZBNKN`	Bank account number of the payee	DZBNKN	BANKN	CHAR	18	—
`ZBNKN_LONG`	Bank Account Number of the Payee	DZBNKN35	BANKN35	CHAR	35	—
`ZBNKL`	Bank number of the payee's bank	DZBNKL	BANKL	CHAR	15	—
`ZBKON`	Bank Control Key of the Payee's Bank	DZBKON	BKONT	CHAR	2	—
`ZBVTY`	Bank Data Indicator for the Payee	DZBVTY	BVTYP	CHAR	4	—
`ZSWIF`	SWIFT/BIC for International Payments	SWIFT	SWIFT	CHAR	11	—
`XEZER`	Indicator: Is there collection authorization ?	XEZER	XFELD	CHAR	1	—
`ZSPRA`	Language key of the payee	DZSPRA	SPRAS	LANG	1	—	T002
`ZALDT`	Posting Date of Payment Document	DZALDT_ZHL	DATUM	DATS	8	—
`RZAWE`	Payment Method for This Payment	RZAWE	ZLSCH	CHAR	1	—	T042Z
`RUMSK`	Special G/L Indicator of the Payment Transaction	RUMSK	UMSKZ	CHAR	1	—
`RZUMS`	Target Special G/L Indicator of the Payment Transaction	RZUMS	UMSKZ	CHAR	1	—
`HKTID`	ID for Account Details	HKTID	HKTID	CHAR	5	—	T012K
`HBKID`	Short Key for a House Bank	HBKID	HBKID	CHAR	5	—	T012
`HKTIW`	Short Key of the Account Data for the Bill of Exchange	HKTIW	HKTID	CHAR	5	—	T012K
`HBKIW`	Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.	HBKIW	HBKID	CHAR	5	—	T012
`BVTYP`	Partner bank type	BVTYP	BVTYP	CHAR	4	—
`UBKON`	Bank control key at our bank	UBKON	BKONT	CHAR	2	—
`UBKNT`	Our account number at the bank	UBKNT	BANKN	CHAR	18	—
`UBKNT_LONG`	Our Account Number at the Bank	UBKNT35	BANKN35	CHAR	35	—
`UBNKS`	Bank Country/Region Key	BANKS	LAND1	CHAR	3	—	T005
`UBNKL`	Bank number of our bank	UBNKL	BANKL	CHAR	15	—
`UIBAN`	IBAN at Our House Bank	UIBAN	IBAN	CHAR	34	—
`UBHKT`	G/L Account Number for Our Bank Account / Bank Subaccount	UBHKT	SAKNR	CHAR	10	—	SKB1
`VALUT`	Value date	VALUT	DATUM	DATS	8	—
`CRVAL`	Value Date at Payee's Bank	PRQ_CRVAL	DATUM	DATS	8	—
`ANFAE`	Bill of Exchange Payment Request Due Date	ANFAE	DATUM	DATS	8	—
`WEFAE`	Bill of Exchange Due Date	WEFAE	DATUM	DATS	8	—
`RBETR`	Amount in Local Currency	RBETR	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RSKON`	Total Cash Discount for the Payment Trans. (Local Currency)	RSKON	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RWBTR`	Amount Paid in the Payment Currency	RWBTR	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RWSKT`	Total Cash Discount for the Pmnt Transactn in Pmnt Currency	RWSKT	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RSPE1`	Form Charges	SPES1	AFLE11D2O14N_TO_23D2O30N	CURR	23	2
`RSPE2`	Form Charges	SPES2	AFLE11D2O14N_TO_23D2O30N	CURR	23	2
`RPOST`	Number of Items Paid	RPOST	PACK3	DEC	5	0
`RTEXT`	Number of Text Lines for the Items Paid	RTEXT_D	PACK3	DEC	5	0
`RSPM1`	Form Charges for Bill of Exchange with Maximum Amount	SPEM1	AFLE11D2O14N_TO_23D2O30N	CURR	23	2
`RSPM2`	Form Charges for Bill of Exchange with Maximum Amount	SPEM2	AFLE11D2O14N_TO_23D2O30N	CURR	23	2
`WEHMX`	Maximum Amount per Bill of Exchange in Local Currency	WEHMX	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`WEFMX`	Maximum Amount per Bill of Exchange in Payment Currency	WEFMX	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`WEHRS`	Remaining Amount in Local Crcy for Last Bill of Exchange	WEHRS	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`WEFRS`	Remaining Amount in Payment Crcy for Last Bill of Exchange	WEFRS	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`WEAMX`	Number of Bills of Exchange with Maximum Amount	WEAMX	PACK2	DEC	3	0
`BUSAB`	Accounting Clerk Abbreviation	BUSAB	BUSAB	CHAR	2	—	T001S
`EIKTO`	Shipper's (Our) Account Number at the Customer or Vendor	EIKTO	CHAR12	CHAR	12	—
`XINVE`	Indicator: Capital Goods Affected?	XINVE	XFELD	CHAR	1	—
`WDATE`	Bill of Exchange Issue Date	WDATE	DATUM	DATS	8	—
`XAEND`	Indicator: Payment Proposal was Changed Afterwards	XAEND_REGU	XFELD	CHAR	1	—
`ZLSPR`	Payment Block Key	DZLSPR	ZAHLS	CHAR	1	—	T008
`DTAWS`	Instruction Key for Data Medium Exchange	DTAWS	DTAWS	CHAR	2	—
`DTAMS`	Recipient Code for Data Medium Exchange	DTAMS	DTAMS	CHAR	1	—
`KURSF`	Exchange rate	KURSF	KURSF	DEC	9	5
`ABWAE`	Settlement currency for bank transfers	ABWAE	WAERS	CUKY	5	—	TCURC
`SKVHW`	Lost Cash Discount in Local Currency	SKVHW	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`SKVFW`	Lost Cash Discount in Payment Currency	SKVFW	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`DSKVH`	Impending Lost Cash Discount in Local Currency	DSKVH	AFLE13D2O16N_TO_23D2O30N	CURR	23	2
`ZPST2`	P.O. box postal code of the payee	DZPST2	PSTLZ	CHAR	10	—
`PAYGR`	Grouping Field for Automatic Payments	PAYGR	CHAR20	CHAR	20	—
`ZBNKY`	Bank key of the payee's bank	DZBNKY	BANKK	CHAR	15	—
`UBNKY`	Bank Key of Our Bank	UBNKY	BANKK	CHAR	15	—
`PSTL2`	P.O. Box Postal Code	PSTL2	PSTLZ	CHAR	10	—
`ABSBU`	Sending company code	ABSBU	BUKRS	CHAR	4	—	T001
`RBET2`	Amount Paid in Second Local Currency	RBET2	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RBET3`	Amount Paid in Third Local Currency	RBET3	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RSKO2`	Payment Transaction Total Discount in Second Local Currency	RSKO2	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`RSKO3`	Payment Transaction Total Discount in Third Local Currency	RSKO3	AFLE13D2O18S_TO_23D2O31S	CURR	23	2
`KURS2`	Exchange Rate for the Second Local Currency	KURS2	KURSF	DEC	9	5
`KURS3`	Exchange Rate for the Third Local Currency	KURS3	KURSF	DEC	9	5
`BKREF`	Reference Details for Bank Details	BKREF	CHAR20	CHAR	20	—
`UZAWE`	Payment method supplement	UZAWE	UZAWE	CHAR	2	—	T042F
`ZORT2`	Location from payee's address	ORT02_Z	TEXT35	CHAR	35	—
`ZTLFX`	Payee's telefax number	TELFX_Z	TEXT31	CHAR	31	—
`XSIWE`	Indicator: Bill on Demand	XSIWE	XFELD	CHAR	1	—
`ZPFOR`	City of payee's PO box	PFORT_Z	TEXT35	CHAR	35	—
`PERNR`	Personnel Number	PERNR_D	PERNR	NUMC	8	—
`SEQNR`	Sequence Number	SEQC5	CHAR5	CHAR	5	—
`BTZNR`	Assignment of Transfers	BTZNR	RAW1	RAW	1	—
`AUSFD`	Due date of the paid items	AUSFD	DATUM	DATS	8	—
`AUGDT`	Clearing Date	AUGDT	DATUM	DATS	8	—
`EDIAV`	EDI Payment Advice Status	EDIAV	EDIST	CHAR	1	—
`IDOC_NUM_AVIS`	IDoc number	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	—
`EDIBN`	EDI Payment Order Status	EDIBN	EDIST	CHAR	1	—
`IDOC_NUM`	IDoc number	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	—
`ZTELF`	Payee telephone number	TELFN_Z	TEXT20	CHAR	20	—
`ZTELX`	Payee telex number	TELEX_Z	TEXT30	CHAR	30	—
`KOINH`	Account Holder Name	KOINH_FI	KOINH	CHAR	60	—
`DTWS1`	Instruction Key 1	DTAT16	DTWSX	NUMC	2	—
`DTWS2`	Instruction Key 2	DTAT17	DTWSX	NUMC	2	—
`DTWS3`	Instruction key 3	DTAT18	DTWSX	NUMC	2	—
`DTWS4`	Instruction key 4	DTAT19	DTWSX	NUMC	2	—
`PAYT_RSN`	Payment Reason	FARP_PAYT_RSN	FARP_PAYT_RSN	CHAR	4	—	FARP_PAYT_RSN_T
`ZSTC1`	Payee's tax number 1	STCD1_Z	STCD1	CHAR	16	—
`KIDNO`	Payment Reference	KIDNO	CHAR30	CHAR	30	—
`PYORD`	Payment Order	PYORD	PYORD	CHAR	10	—
`REGIO`	Region (State, Province, County)	REGIO	REGIO	CHAR	3	—
`TEXT`	Text field	TEXT	FL_TEXT	CHAR	29	—
`BTYP1`	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	BNTYP	CHAR	1	—
`BNKS1`	Bank Country/Region Key	BANKS	LAND1	CHAR	3	—
`BNKL1`	Bank Keys	BANKK	BANKK	CHAR	15	—
`BNKN1`	Bank Account Number	BANKN	BANKN	CHAR	18	—
`BKON1`	Bank Control Key	BKONT	BKONT	CHAR	2	—
`BKRF1`	Reference Details for Bank Details	BKREF	CHAR20	CHAR	20	—
`IBAN1`	IBAN (International Bank Account Number)	IBAN	IBAN	CHAR	34	—
`BTYP2`	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	BNTYP	CHAR	1	—
`BNKS2`	Bank Country/Region Key	BANKS	LAND1	CHAR	3	—
`BNKL2`	Bank Keys	BANKK	BANKK	CHAR	15	—
`BNKN2`	Bank Account Number	BANKN	BANKN	CHAR	18	—
`BKON2`	Bank Control Key	BKONT	BKONT	CHAR	2	—
`BKRF2`	Reference Details for Bank Details	BKREF	CHAR20	CHAR	20	—
`IBAN2`	IBAN (International Bank Account Number)	IBAN	IBAN	CHAR	34	—
`BTYP3`	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	BNTYP	CHAR	1	—
`BNKS3`	Bank Country/Region Key	BANKS	LAND1	CHAR	3	—
`BNKL3`	Bank Keys	BANKK	BANKK	CHAR	15	—
`BNKN3`	Bank Account Number	BANKN	BANKN	CHAR	18	—
`BKON3`	Bank Control Key	BKONT	BKONT	CHAR	2	—
`BKRF3`	Reference Details for Bank Details	BKREF	CHAR20	CHAR	20	—
`IBAN3`	IBAN (International Bank Account Number)	IBAN	IBAN	CHAR	34	—
`SAKNR`	G/L Account Number	SAKNR	SAKNR	CHAR	10	—
`HKONT`	General Ledger Account	HKONT	SAKNR	CHAR	10	—
`ALEBN`	ALE IDoc Distribution Status of Payment Data	ALEBN	ALEIST	CHAR	1	—
`XKDFB`	Do not Post any Exchange Rate Differences	XKDFB_042E	XFELD	CHAR	1	—
`SRTBP`	Business Place	BUPLA	J_1BBRANCH	CHAR	4	—
`FPM_KEY`	Rundate, ID, and Default Indicator Concatenated	FPM_KEY	—	CHAR	15	—
`GRPNO`	Grouping Criterium for Payments	GRPNO_FPM	GRPNO_FPM	INT4	10	—
`SRTF1`	Format-Specific Sorting of Payments incl. Sequence Number	SRTF1N_FPM	CHAR38	CHAR	38	—
`SRTF2`	User-Defined Sorting of Payments incl. Sequence Number	SRTF2N_FPM	CHAR56	CHAR	56	—
`SRTF3`	Format-Specific Sorting of Payments incl. Sequence Number	SRTF1N_FPM	CHAR38	CHAR	38	—
`XCORR`	Indicator: Payment Correspondence	XCORR_FPM	XFELD	CHAR	1	—
`XAVIS`	Indicator: Separate Payment Advice	XAVIS_FPM	XFELD	CHAR	1	—
`XCOPM`	Payment Medium for Business Partner (Correspondence)	XCOPM_FPM	XCOPM_FPM	CHAR	1	—
`DORIGIN`	Grouping Origin	FIBL_DORIGIN	FIBL_ORIGIN	CHAR	8	—
`RFTTRN`	Payment code	RFTTRN_BF	RFTTRN_BF	CHAR	20	—
`ZADNR`	Payee's Address Number	ADRNR_Z	AD_ADDRNUM	CHAR	10	—
`ADRNR`	Address Number	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	—
`ZIBAN`	IBAN of the Payee	DZIBAN	IBAN	CHAR	34	—
`MGUID`	Mandate: GUID of Mandate	SEPA_MGUID	—	RAW	16	—
`SEQ_TYPE`	Mandate: Sequence Type	SEPA_SEQ_TYPE	SEPA_SEQ_TYPE	CHAR	4	—
`INST_CODE`	Local Instrument Code (Direct Debit Type)	FSEPA_INST_CODE	FSEPA_INST_CODE	CHAR	4	—
`PURP_CODE`	SEPA Purpose Code: Classification of a Payment/Debit Memo	FPM_PURP_CODE	CHAR4	CHAR	4	—
`XMLST`	Status of XML Payment Advice	XMLST_AVIS	XMLST_AVIS	CHAR	1	—
`TIMESTAMP_AVIS`	Time Stamp for Sending XML Payment Advice	TIMESTAMP_AVIS	FI_TIMESTAMP	DEC	15	0
`UETR`	Unique Transaction Reference (UETR)	FPM_UETR	SMUM_C36	CHAR	36	—
`ZPAYMENT_SYSTEM`	Payee Payment System	PAYEE_PAYMENT_SYSTEM	PAYMENT_SYSTEM	CHAR	15	—
`ZALIAS_TYPE`	Payee Alias Type	PAYEE_ALIAS_TYPE	ALIAS_TYPE	CHAR	15	—
`ZBANK_ALIAS`	Payee Alias	PAYEE_BANK_ALIAS	BANK_ALIAS	CHAR	255	—
`J_1TPBUPL`	Branch Code	BCODE	BCODE	CHAR	5	—
`FM_STATUS`	Availability Status for a Payment	FM_PAY_STA	FM_PAY_STA	CHAR	1	—
`FILE_NBR`	Key for multiple files from single Payment Program Print	FMFG_FILE_NO	—	NUMC	6	—

SAP REGUH Table Availability

SAP product	Verified release/system	Table availability	Verified on
SAP S/4HANA	2023 - On-Premise	Available	2026-10-13

Related SAP Tables

Table	Description	Common Key Fields with REGUH
BKPF	Accounting Document Header	MANDT
T012K	House Bank Accounts	MANDT
T012	House Banks	MANDT
REGUP	Processed items from payment program	MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR
PAYR	Payment Medium File	MANDT, ZBUKR

Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.

Editorial and verification

Content editor: ERPSAP Content Team
Technical reviewer: ERPSAP Technical Review Team
Verified against: SAP S/4HANA 2023 On-Premise system
Last updated: October 14, 2026

The information on this SAP REGUH table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.