Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

REGUH SAP (Settlement data from payment program) Table details

Dictionary Type: Table
Description: Settlement data from payment program

ABAP Code to SELECT data from REGUH
Related tables to REGUH
Access table REGUH

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Table field list including key, data, relationships and ABAP select examples

REGUH is a standard SAP Table which is used to store Settlement data from payment program data and is available within R/3 SAP systems depending on the version and release level.

The REGUH table consists of various fields, each holding specific information or linking keys about Settlement data from payment program data available in SAP. These include LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), XVORL (Indicator: Only Proposal Run?), ZBUKR (Paying company code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP REGUH table fields - Full list of fields found in SAP data dictionary

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

Key field

Non-key field

How do I retrieve data from SAP table REGUH using ABAP code

The following ABAP code Example will allow you to do a basic selection on REGUH to SELECT all data from the table
DATA: WA_REGUH TYPE REGUH.

SELECT SINGLE *
FROM REGUH
INTO CORRESPONDING FIELDS OF WA_REGUH
WHERE...

How to access SAP table REGUH

Within an ECC or HANA version of SAP you can also view further information about REGUH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!