REGUH - Settlement data from payment program

Settlement data from payment program information is stored in SAP table REGUH.
It is part of development package FBZ in software component FI-AP-AP-B. This development package consists of objects that can be grouped under "Payments".

Fields for table REGUH

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
LAUFD	Date on Which the Program Is to Be Run	X	LAUFD	DATS	16
LAUFI	Additional Identification	X	LAUFI	CHAR	12
XVORL	Indicator: Only Proposal Run?	X	XVORL	CHAR	2
LIFNR	Account Number of Supplier	X	LIFNR	CHAR	20	LFA1
KUNNR	Customer Number	X	KUNNR	CHAR	20	KNA1
EMPFG	Payment Recipient Code	X	EMPFG	CHAR	32
VBLNR	Document Number of the Payment Document	X	VBLNR	CHAR	20
AVISG	Reason for Printing Payment Advice		AVISG	CHAR	2
WAERS	Currency Key		WAERS	CUKY	10	TCURC
SRTGB	Business Area		GSBER	CHAR	8	TGSB
ANRED	Title		ANRED	CHAR	30
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
NAME3	Name 3		NAME3_GP	CHAR	70
NAME4	Name 4		NAME4_GP	CHAR	70
PSTLZ	Postal Code		PSTLZ	CHAR	20
ORT01	City		ORT01_GP	CHAR	70
STRAS	Street and House Number		STRAS_GP	CHAR	70
PFACH	PO Box		PFACH	CHAR	20
LAND1	Country/Region Key		LAND1	CHAR	6	T005
STCD1	Tax Number 1		STCD1	CHAR	32
WEVWV	Planned Usage of the Bill of Exchange		WEVWV	CHAR	2
XEZER	Indicator: Is there collection authorization ?		XEZER	CHAR	2
RZAWE	Payment Method for This Payment		RZAWE	CHAR	2	T042Z
RUMSK	Special G/L Indicator of the Payment Transaction		RUMSK	CHAR	2
RZUMS	Target Special G/L Indicator of the Payment Transaction		RZUMS	CHAR	2
HKTID	ID for Account Details		HKTID	CHAR	10	T012K
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
HKTIW	Short Key of the Account Data for the Bill of Exchange		HKTIW	CHAR	10	T012K
HBKIW	Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.		HBKIW	CHAR	10	T012
BVTYP	Partner bank type		BVTYP	CHAR	8
UBKON	Bank control key at our bank		UBKON	CHAR	4
UBKNT	Our account number at the bank		UBKNT	CHAR	36
UBKNT_LONG	Our Account Number at the Bank		UBKNT35	CHAR	70
UBNKS	Country/Region Key of Bank		BANKS	CHAR	6	T005
UBNKL	Bank number of our bank		UBNKL	CHAR	30
UIBAN	IBAN at Our House Bank		UIBAN	CHAR	68
UBHKT	G/L Account Number for Our Bank Account / Bank Subaccount		UBHKT	CHAR	20	SKB1
VALUT	Value date		VALUT	DATS	16
CRVAL	Value Date at Payee's Bank		PRQ_CRVAL	DATS	16
ANFAE	Bill of Exchange Payment Request Due Date		ANFAE	DATS	16
WEFAE	Bill of Exchange Due Date		WEFAE	DATS	16
RBETR	Amount in Local Currency		RBETR	CURR	12
RSKON	Total Cash Discount for the Payment Trans. (Local Currency)		RSKON	CURR	12
RWBTR	Amount Paid in the Payment Currency		RWBTR	CURR	12
RWSKT	Total Cash Discount for the Pmnt Transactn in Pmnt Currency		RWSKT	CURR	12
RSPE1	Form Charges		SPES1	CURR	12
RSPE2	Form Charges		SPES2	CURR	12
RPOST	Number of Items Paid		RPOST	DEC	3
RTEXT	Number of Text Lines for the Items Paid		RTEXT_D	DEC	3
RSPM1	Form Charges for Bill of Exchange with Maximum Amount		SPEM1	CURR	12
RSPM2	Form Charges for Bill of Exchange with Maximum Amount		SPEM2	CURR	12
WEHMX	Maximum Amount per Bill of Exchange in Local Currency		WEHMX	CURR	12
WEFMX	Maximum Amount per Bill of Exchange in Payment Currency		WEFMX	CURR	12
WEHRS	Remaining Amount in Local Crcy for Last Bill of Exchange		WEHRS	CURR	12
WEFRS	Remaining Amount in Payment Crcy for Last Bill of Exchange		WEFRS	CURR	12
WEAMX	Number of Bills of Exchange with Maximum Amount		WEAMX	DEC	2
BUSAB	Accounting Clerk Abbreviation		BUSAB	CHAR	4	T001S
EIKTO	Shipper's (Our) Account Number at the Customer or Vendor		EIKTO	CHAR	24
XINVE	Indicator: Capital Goods Affected?		XINVE	CHAR	2
WDATE	Bill of Exchange Issue Date		WDATE	DATS	16
XAEND	Indicator: Payment Proposal was Changed Afterwards		XAEND_REGU	CHAR	2
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
KURSF	Exchange rate		KURSF	DEC	5
ABWAE	Settlement currency for bank transfers		ABWAE	CUKY	10	TCURC
SKVHW	Lost Cash Discount in Local Currency		SKVHW	CURR	12
SKVFW	Lost Cash Discount in Payment Currency		SKVFW	CURR	12
DSKVH	Impending Lost Cash Discount in Local Currency		DSKVH	CURR	12
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
UBNKY	Bank Key of Our Bank		UBNKY	CHAR	30
PSTL2	P.O. Box Postal Code		PSTL2	CHAR	20
ABSBU	Sending company code		ABSBU	CHAR	8	T001
RBET2	Amount Paid in Second Local Currency		RBET2	CURR	12
RBET3	Amount Paid in Third Local Currency		RBET3	CURR	12
RSKO2	Payment Transaction Total Discount in Second Local Currency		RSKO2	CURR	12
RSKO3	Payment Transaction Total Discount in Third Local Currency		RSKO3	CURR	12
KURS2	Exchange Rate for the Second Local Currency		KURS2	DEC	5
KURS3	Exchange Rate for the Third Local Currency		KURS3	DEC	5
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
XSIWE	Indicator: Bill on Demand		XSIWE	CHAR	2
PERNR	Personnel Number		PERNR_D	NUMC	16
SEQNR	Sequence Number		SEQC5	CHAR	10
BTZNR	Assignment of Transfers		BTZNR	RAW	1
AUSFD	Due date of the paid items		AUSFD	DATS	16
AUGDT	Clearing Date		AUGDT	DATS	16
EDIAV	EDI Payment Advice Status		EDIAV	CHAR	2
IDOC_NUM_AVIS	IDoc number		EDI_DOCNUM	NUMC	32
EDIBN	EDI Payment Order Status		EDIBN	CHAR	2
IDOC_NUM	IDoc number		EDI_DOCNUM	NUMC	32
KOINH	Account Holder Name		KOINH_FI	CHAR	120
DTWS1	Instruction Key 1		DTAT16	NUMC	4
DTWS2	Instruction Key 2		DTAT17	NUMC	4
DTWS3	Instruction key 3		DTAT18	NUMC	4
DTWS4	Instruction key 4		DTAT19	NUMC	4
PAYT_RSN	Payment Reason		FARP_PAYT_RSN	CHAR	8	FARP_PAYT_RSN_T
KIDNO	Payment Reference		KIDNO	CHAR	60
PYORD	Payment Order		PYORD	CHAR	20
REGIO	Region (State, Province, County)		REGIO	CHAR	6
TEXT	Text field		TEXT	CHAR	58
BTYP1	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS1	Country/Region Key of Bank		BANKS	CHAR	6
BNKL1	Bank Keys		BANKK	CHAR	30
BNKN1	Bank account number		BANKN	CHAR	36
BKON1	Bank Control Key		BKONT	CHAR	4
BKRF1	Reference Details for Bank Details		BKREF	CHAR	40
IBAN1	IBAN (International Bank Account Number)		IBAN	CHAR	68
BTYP2	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS2	Country/Region Key of Bank		BANKS	CHAR	6
BNKL2	Bank Keys		BANKK	CHAR	30
BNKN2	Bank account number		BANKN	CHAR	36
BKON2	Bank Control Key		BKONT	CHAR	4
BKRF2	Reference Details for Bank Details		BKREF	CHAR	40
IBAN2	IBAN (International Bank Account Number)		IBAN	CHAR	68
BTYP3	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS3	Country/Region Key of Bank		BANKS	CHAR	6
BNKL3	Bank Keys		BANKK	CHAR	30
BNKN3	Bank account number		BANKN	CHAR	36
BKON3	Bank Control Key		BKONT	CHAR	4
BKRF3	Reference Details for Bank Details		BKREF	CHAR	40
IBAN3	IBAN (International Bank Account Number)		IBAN	CHAR	68
SAKNR	G/L Account Number		SAKNR	CHAR	20
HKONT	General Ledger Account		HKONT	CHAR	20
ALEBN	ALE IDoc Distribution Status of Payment Data		ALEBN	CHAR	2
XKDFB	Do not Post any Exchange Rate Differences		XKDFB_042E	CHAR	2
SRTBP	Business Place		BUPLA	CHAR	8
.INCLUDE				IREGUH_FPM	0
FPM_KEY	Rundate, ID, and Default Indicator Concatenated		FPM_KEY	CHAR	30
GRPNO	Grouping Criterium for Payments		GRPNO_FPM	INT4	4
SRTF1	Format-Specific Sorting of Payments incl. Sequence Number		SRTF1N_FPM	CHAR	76
SRTF2	User-Defined Sorting of Payments incl. Sequence Number		SRTF2N_FPM	CHAR	112
SRTF3	Format-Specific Sorting of Payments incl. Sequence Number		SRTF1N_FPM	CHAR	76
XCORR	Indicator: Payment Correspondence		XCORR_FPM	CHAR	2
XAVIS	Indicator: Separate Payment Advice		XAVIS_FPM	CHAR	2
XCOPM	Payment Medium for Business Partner (Correspondence)		XCOPM_FPM	CHAR	2
DORIGIN	Grouping Origin		FIBL_DORIGIN	CHAR	16
RFTTRN	Payment code		RFTTRN_BF	CHAR	40
ADRNR	Address Number		AD_ADDRNUM	CHAR	20
MGUID	SEPA Mandate: GUID of Mandate		SEPA_MGUID	RAW	16
SEQ_TYPE	SEPA: Sequence Type		SEPA_SEQ_TYPE	CHAR	8
INST_CODE	Local Instrument Code (Direct Debit Type)		FSEPA_INST_CODE	CHAR	8
PURP_CODE	SEPA Purpose Code: Classification of a Payment/Debit Memo		FPM_PURP_CODE	CHAR	8
XMLST	Status of XML Payment Advice		XMLST_AVIS	CHAR	2
TIMESTAMP_AVIS	Time Stamp for Sending XML Payment Advice		TIMESTAMP_AVIS	DEC	8
UETR	Unique Transaction Reference (UETR)		FPM_UETR	CHAR	72
.INCLU--AP				REGUH_FM	0
FM_STATUS	Availability Status for a Payment		FM_PAY_STA	CHAR	2
.INCLU--AP				REGUH_FMFG	0
FILE_NBR	Key for multiple files from single Payment Program Print		FMFG_FILE_NO	NUMC	12