1. Home
  2. Resources
  3. SAP Tables
  4. REGUH - Settlement data from payment program

SAP Table REGUH

Settlement data from payment program

REGUH (Settlement data from payment program) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REGUH to other SAP tables.

REGUH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAUFD Date on Which the Program Is to Be Run LAUFD DATS 8 0
LAUFI Additional Identification LAUFI CHAR 6 0
XVORL Indicator: Only Proposal Run? XVORL CHAR 1 0
X Yes
NULL No
ZBUKR Paying company code DZBUKR T001 CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
EMPFG Payee code EMPFG CHAR 16 0
VBLNR Document Number of the Payment Document VBLNR CHAR 10 0
AVISG Reason for Printing Payment Advice AVISG CHAR 1 0
A Zero balance notification
V Clearing (payment and notification already made)
WAERS Currency Key WAERS TCURC CUKY 5 0
SRTGB Business Area GSBER TGSB CHAR 4 0
ANRED Title ANRED CHAR 15 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
LAND1 Country Key LAND1 T005 CHAR 3 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
WEVWV Planned usage of the bill of exchange WEVWV CHAR 1 0
D Discounting
I Collection
F Forfeiting
ZANRE Title of the payee DZANRE CHAR 15 0
ZNME1 Name of the payee DZNME1 CHAR 35 0
ZNME2 Name of the payee DZNME1 CHAR 35 0
ZNME3 Name of the payee DZNME1 CHAR 35 0
ZNME4 Name of the payee DZNME1 CHAR 35 0
ZPSTL Postal code of the payee DZPSTL CHAR 10 0
ZORT1 City of the payee DZORT1 CHAR 35 0
ZSTRA Street and house number of the payee DZSTRA CHAR 35 0
ZPFAC P.O. box of the payee DZPFAC CHAR 10 0
ZLAND Country Key DZLAND T005 CHAR 3 0
ZREGI Regional code of the payee DZREGI T005S CHAR 3 0
ZBNKS Country Key DZBNKS T005 CHAR 3 0
ZBNKN Bank account number of the payee DZBNKN CHAR 18 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZBKON Bank Control Key of the Payee's Bank DZBKON CHAR 2 0
ZBVTY Bank Data Indicator for the Payee DZBVTY CHAR 4 0
ZSWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
XEZER Indicator: Is there collection authorization ? XEZER CHAR 1 0
X Yes
NULL No
ZSPRA Language key of the payee DZSPRA T002 LANG 1 0
ZALDT Posting date of the payment document DZALDT_ZHL DATS 8 0
RZAWE Payment Method for This Payment RZAWE T042Z CHAR 1 0
RUMSK Special G/L Indicator of the Payment Transaction RUMSK CHAR 1 0
RZUMS Target Special G/L Indicator of the Payment Transaction RZUMS CHAR 1 0
HKTID ID for account details HKTID T012K CHAR 5 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
HKTIW Short Key of the Account Data for the Bill of Exchange HKTIW T012K CHAR 5 0
HBKIW Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex. HBKIW T012 CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
UBKON Bank control key at our bank UBKON CHAR 2 0
UBKNT Our account number at the bank UBKNT CHAR 18 0
UBNKS Bank country key BANKS T005 CHAR 3 0
UBNKL Bank number of our bank UBNKL CHAR 15 0
UIBAN IBAN at our House Bank UIBAN CHAR 34 0
UBHKT G/L Account Number for Our Bank Account / Bank Sub-Account UBHKT SKB1 CHAR 10 0
VALUT Value date VALUT DATS 8 0
CRVAL Value Date at Payee's Bank PRQ_CRVAL DATS 8 0
ANFAE Bill of Exchange Payment Request Due Date ANFAE DATS 8 0
WEFAE Bill of Exchange Due Date WEFAE DATS 8 0
RBETR Amount in Local Currency RBETR CURR 13 2
RSKON Total Cash Discount for the Payment Trans. (Local Currency) RSKON CURR 13 2
RWBTR Amount Paid in the Payment Currency RWBTR CURR 13 2
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKT CURR 13 2
RSPE1 Form Charges SPES1 CURR 11 2
RSPE2 Form Charges SPES2 CURR 11 2
RPOST Number of Items Paid RPOST DEC 5 0
RTEXT Number of Text Lines for the Items Paid RTEXT_D DEC 5 0
RSPM1 Form Charges for Bill of Exchange with Maximum Amount SPEM1 CURR 11 2
RSPM2 Form Charges for Bill of Exchange with Maximum Amount SPEM2 CURR 11 2
WEHMX Maximum Amount per Bill of Exchange in Local Currency WEHMX CURR 13 2
WEFMX Maximum Amount per Bill of Exchange in Payment Currency WEFMX CURR 13 2
WEHRS Remaining Amount in Local Crcy for Last Bill of Exchange WEHRS CURR 13 2
WEFRS Remaining Amount in Payment Crcy for Last Bill of Exchange WEFRS CURR 13 2
WEAMX Number of Bills of Exchange with Maximum Amount WEAMX DEC 3 0
BUSAB Accounting clerk BUSAB T001S CHAR 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
WDATE Bill of Exchange Issue Date WDATE DATS 8 0
XAEND Indicator: Payment Proposal was Changed Afterwards XAEND_REGU CHAR 1 0
X Yes
NULL No
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
KURSF Exchange rate KURSF DEC 9 5
ABWAE Settlement currency for bank transfers ABWAE TCURC CUKY 5 0
SKVHW Lost Cash Discount in Local Currency SKVHW CURR 13 2
SKVFW Lost Cash Discount in Payment Currency SKVFW CURR 13 2
DSKVH Impending Lost Cash Discount in Local Currency DSKVH CURR 13 2
ZPST2 P.O. box postal code of the payee DZPST2 CHAR 10 0
PAYGR Grouping Field for Automatic Payments PAYGR CHAR 20 0
ZBNKY Bank key of the payee's bank DZBNKY CHAR 15 0
UBNKY Bank key of our bank UBNKY CHAR 15 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
ABSBU Sending company code ABSBU T001 CHAR 4 0
RBET2 Amount Paid in Second Local Currency RBET2 CURR 13 2
RBET3 Amount Paid in Third Local Currency RBET3 CURR 13 2
RSKO2 Payment Transaction Total Discount in Second Local Currency RSKO2 CURR 13 2
RSKO3 Payment Transaction Total Discount in Third Local Currency RSKO3 CURR 13 2
KURS2 Exchange Rate for the Second Local Currency KURS2 DEC 9 5
KURS3 Exchange Rate for the Third Local Currency KURS3 DEC 9 5
BKREF Reference specifications for bank details BKREF CHAR 20 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
ZORT2 Location from payee's address ORT02_Z CHAR 35 0
ZTLFX Payee's telefax number TELFX_Z CHAR 31 0
XSIWE Indicator: Bill on demand XSIWE CHAR 1 0
X Yes
NULL No
ZPFOR City of payee's PO box PFORT_Z CHAR 35 0
PERNR Personnel Number PERNR_D NUMC 8 0
SEQNR Sequence Number SEQC5 CHAR 5 0
BTZNR Assignment of Transfers BTZNR RAW 1 0
AUSFD Due date of the paid items AUSFD DATS 8 0
AUGDT Clearing Date AUGDT DATS 8 0
EDIAV EDI Payment Advice Status EDIAV CHAR 1 0
NULL Customer/vendor has no EDI connection
X Cust./vend.has EDI connection, pyt adv./pyt ord.not yet sent
V Payment advice/payment order sent
E Transmission error, pyt advice/pyt carrier was created
IDOC_NUM_AVIS IDoc number EDI_DOCNUM NUMC 16 0
EDIBN EDI Payment Order Status EDIBN CHAR 1 0
NULL Customer/vendor has no EDI connection
X Cust./vend.has EDI connection, pyt adv./pyt ord.not yet sent
V Payment advice/payment order sent
E Transmission error, pyt advice/pyt carrier was created
IDOC_NUM IDoc number EDI_DOCNUM NUMC 16 0
ZTELF Payee telephone number TELFN_Z CHAR 20 0
ZTELX Payee telex number TELEX_Z CHAR 30 0
KOINH Account Holder Name KOINH_FI CHAR 60 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
ZSTC1 Payee's tax number 1 STCD1_Z CHAR 16 0
KIDNO Payment Reference KIDNO CHAR 30 0
PYORD Payment Order PYORD CHAR 10 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
TEXT Text field TEXT CHAR 29 0
BTYP1 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS1 Bank country key BANKS CHAR 3 0
BNKL1 Bank Keys BANKK CHAR 15 0
BNKN1 Bank account number BANKN CHAR 18 0
BKON1 Bank Control Key BKONT CHAR 2 0
BKRF1 Reference specifications for bank details BKREF CHAR 20 0
IBAN1 IBAN (International Bank Account Number) IBAN CHAR 34 0
BTYP2 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS2 Bank country key BANKS CHAR 3 0
BNKL2 Bank Keys BANKK CHAR 15 0
BNKN2 Bank account number BANKN CHAR 18 0
BKON2 Bank Control Key BKONT CHAR 2 0
BKRF2 Reference specifications for bank details BKREF CHAR 20 0
IBAN2 IBAN (International Bank Account Number) IBAN CHAR 34 0
BTYP3 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS3 Bank country key BANKS CHAR 3 0
BNKL3 Bank Keys BANKK CHAR 15 0
BNKN3 Bank account number BANKN CHAR 18 0
BKON3 Bank Control Key BKONT CHAR 2 0
BKRF3 Reference specifications for bank details BKREF CHAR 20 0
IBAN3 IBAN (International Bank Account Number) IBAN CHAR 34 0
SAKNR G/L Account Number SAKNR CHAR 10 0
HKONT General Ledger Account HKONT CHAR 10 0
ALEBN ALE IDoc Distribution Status of Payment Data ALEBN CHAR 1 0
NULL ALE distribution not active
X ALE distribution active, IDoc not distributed
V Completed, IDoc distributed
E Error in IDoc distribution
W Completed, IDoc was not for distribution
XKDFB Do not Post any Exchange Rate Differences XKDFB_042E CHAR 1 0
X Yes
NULL No
SRTBP Business Place BUPLA CHAR 4 0
FPM_KEY Rundate, ID, and Default Indicator Concatenated FPM_KEY CHAR 15 0
GRPNO Grouping Criterium for Payments GRPNO_FPM INT4 10 0
1 Exceptions
2 Zero balance
3 Intercompany billing
100 Groups of payments
SRTF1 Format-specific sorting of payments incl. sequence nuber SRTF1N_FPM CHAR 38 0
SRTF2 User-defined sorting of payments incl. sequence number SRTF2N_FPM CHAR 56 0
SRTF3 Format-specific sorting of payments incl. sequence nuber SRTF1N_FPM CHAR 38 0
XCORR Indicator: Payment Correspondence XCORR_FPM CHAR 1 0
X Yes
NULL No
XAVIS Indicator: Separate Payment Advice XAVIS_FPM CHAR 1 0
X Yes
NULL No
XCOPM Payment Medium for Business Partner (Correspondence) XCOPM_FPM CHAR 1 0
NULL No payment medium for business partner
W Bills of exchange
S Check
DORIGIN Grouping Origin FIBL_DORIGIN CHAR 8 0
RFTTRN Payment code RFTTRN_BF CHAR 20 0
ZADNR Payee's Address Number ADRNR_Z CHAR 10 0
ADRNR Address number AD_ADDRNUM CHAR 10 0
ZIBAN IBAN of the Payee DZIBAN CHAR 34 0
MGUID SEPA Mandate: GUID of Mandate SEPA_MGUID RAW 16 0
SEQ_TYPE SEPA: Sequence Type SEPA_SEQ_TYPE CHAR 4 0
OOFF One-Time Collection
FRST First Recurring Collection
RCUR Recurring Collection
FNAL Last Recurring Collection
INST_CODE Local Instrument Code (Direct Debit Type) FSEPA_INST_CODE CHAR 4 0
CORE SEPA Core Direct Debit
COR1 SEPA Core Direct Debit with D 1 Agreement
B2B SEPA Business-to-Business Direct Debit
PURP_CODE SEPA Purpose Code: Classification of a Payment/Debit Memo FPM_PURP_CODE CHAR 4 0
XMLST Status of XML Payment Advice XMLST_AVIS CHAR 1 0
NULL No XML Payment Advice
X XML Payment Advice Not Yet Sent
V XML Payment Advice Sent
E Transmission error, pyt advice/pyt carrier was created
TIMESTAMP_AVIS Time Stamp for Sending XML Payment Advice TIMESTAMP_AVIS DEC 15 0
FM_STATUS Availability Status for a Payment FM_PAY_STA CHAR 1 0
NULL Availability not checked
1 Availability check failed; Objects blocked
2 Availability checked; Budget is not available
3 Availability checked; Budget is not available
0 Availability check not active during payment
FILE_NBR Key for multiple files from single Payment Program Print FMFG_FILE_NO NUMC 6 0

REGUH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REGUH ABSBU REGUH MANDT T001 Company Codes MANDT
REGUH ABSBU REGUH ABSBU T001 Company Codes BUKRS
REGUH ABWAE REGUH MANDT TCURC Currency Codes MANDT
REGUH ABWAE REGUH ABWAE TCURC Currency Codes WAERS
REGUH BUSAB REGUH BUSAB T001S Accounting Clerks BUSAB
REGUH BUSAB REGUH MANDT T001S Accounting Clerks MANDT
REGUH BUSAB REGUH ABSBU T001S Accounting Clerks BUKRS
REGUH HBKID REGUH ZBUKR T012 House Banks BUKRS
REGUH HBKID REGUH HBKID T012 House Banks HBKID
REGUH HBKID REGUH MANDT T012 House Banks MANDT
REGUH HBKIW REGUH MANDT T012 House Banks MANDT
REGUH HBKIW REGUH ZBUKR T012 House Banks BUKRS
REGUH HBKIW REGUH HBKIW T012 House Banks HBKID
REGUH HKTID REGUH MANDT T012K House Bank Accounts MANDT
REGUH HKTID REGUH ZBUKR T012K House Bank Accounts BUKRS
REGUH HKTID REGUH HBKID T012K House Bank Accounts HBKID
REGUH HKTID REGUH HKTID T012K House Bank Accounts HKTID
REGUH HKTIW REGUH ZBUKR T012K House Bank Accounts BUKRS
REGUH HKTIW REGUH HBKID T012K House Bank Accounts HBKID
REGUH HKTIW REGUH HKTIW T012K House Bank Accounts HKTID
REGUH HKTIW REGUH MANDT T012K House Bank Accounts MANDT
REGUH KUNNR REGUH MANDT KNA1 General Data in Customer Master MANDT
REGUH KUNNR REGUH KUNNR KNA1 General Data in Customer Master KUNNR
REGUH LAND1 REGUH MANDT T005 Countries MANDT
REGUH LAND1 REGUH LAND1 T005 Countries LAND1
REGUH LIFNR REGUH LIFNR LFA1 Vendor Master (General Section) LIFNR
REGUH LIFNR REGUH MANDT LFA1 Vendor Master (General Section) MANDT
REGUH MANDT REGUH MANDT T000 Clients MANDT
REGUH RZAWE T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
REGUH RZAWE REGUH RZAWE T042Z Payment Methods for Automatic Payment ZLSCH
REGUH RZAWE REGUH MANDT T042Z Payment Methods for Automatic Payment MANDT
REGUH SRTGB REGUH MANDT TGSB Business Areas MANDT
REGUH SRTGB REGUH SRTGB TGSB Business Areas GSBER
REGUH UBHKT REGUH MANDT SKB1 G/L account master (company code) MANDT
REGUH UBHKT REGUH ZBUKR SKB1 G/L account master (company code) BUKRS
REGUH UBHKT REGUH UBHKT SKB1 G/L account master (company code) SAKNR
REGUH UBNKS REGUH UBNKS T005 Countries LAND1
REGUH UBNKS REGUH MANDT T005 Countries MANDT
REGUH UZAWE REGUH MANDT T042F Payment method supplements MANDT
REGUH UZAWE REGUH UZAWE T042F Payment method supplements UZAWE
REGUH WAERS REGUH WAERS TCURC Currency Codes WAERS
REGUH WAERS REGUH MANDT TCURC Currency Codes MANDT
REGUH ZBNKS REGUH MANDT T005 Countries MANDT
REGUH ZBNKS REGUH ZBNKS T005 Countries LAND1
REGUH ZBUKR REGUH MANDT T001 Company Codes MANDT
REGUH ZBUKR REGUH ZBUKR T001 Company Codes BUKRS
REGUH ZLAND REGUH MANDT T005 Countries MANDT
REGUH ZLAND REGUH ZLAND T005 Countries LAND1
REGUH ZLSPR REGUH MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
REGUH ZLSPR REGUH ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
REGUH ZREGI REGUH MANDT T005S Taxes: Region (Province) Key MANDT
REGUH ZREGI REGUH ZLAND T005S Taxes: Region (Province) Key LAND1
REGUH ZREGI REGUH ZREGI T005S Taxes: Region (Province) Key BLAND
REGUH ZSPRA REGUH ZSPRA T002 Language Keys (Component BC-I18) SPRAS