SAP TABLES | Financial Accounting | Accounts Payable | Payment Transactions(FI-AP-AP-PT) SAP FI

REGUH SAP Settlement data from payment program Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP REGUH Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP REGUH Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
LAUFDLAUFDDATS8 Date on Which the Program Is to Be Run
LAUFILAUFICHAR6 Additional Identification
XVORLXVORLCHAR1 Indicator: Only Proposal Run?
ZBUKRDZBUKRCHAR4 T001Paying company code
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
EMPFGEMPFGCHAR16 Payee code
VBLNRVBLNRCHAR10 Document Number of the Payment DocumentALPHA
AVISGAVISGCHAR1 Reason for Printing Payment Advice
WAERSWAERSCUKY5 TCURCCurrency Key
SRTGBGSBERCHAR4 TGSBBusiness Area
ANREDANREDCHAR15 Title
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
NAME3NAME3_GPCHAR35 Name 3
NAME4NAME4_GPCHAR35 Name 4
PSTLZPSTLZCHAR10 Postal Code
ORT01ORT01_GPCHAR35 City
STRASSTRAS_GPCHAR35 House number and street
PFACHPFACHCHAR10 PO Box
LAND1LAND1CHAR3 T005Country Key
STCD1STCD1CHAR16 Tax Number 1
WEVWVWEVWVCHAR1 Planned usage of the bill of exchange
ZANREDZANRECHAR15 Title of the payee
ZNME1DZNME1CHAR35 Name of the payee
ZNME2DZNME1CHAR35 Name of the payee
ZNME3DZNME1CHAR35 Name of the payee
ZNME4DZNME1CHAR35 Name of the payee
ZPSTLDZPSTLCHAR10 Postal code of the payee
ZORT1DZORT1CHAR35 City of the payee
ZSTRADZSTRACHAR35 Street and house number of the payee
ZPFACDZPFACCHAR10 P.O. box of the payee
ZLANDDZLANDCHAR3 T005Country Key
ZREGIDZREGICHAR3 T005SRegional code of the payee
ZBNKSDZBNKSCHAR3 T005Country Key
ZBNKNDZBNKNCHAR18 Bank account number of the payee
ZBNKLDZBNKLCHAR15 Bank number of the payee's bank
ZBKONDZBKONCHAR2 Bank Control Key of the Payee's Bank


ZBVTYDZBVTYCHAR4 Bank Data Indicator for the Payee
ZSWIFSWIFTCHAR11 SWIFT/BIC for International Payments
XEZERXEZERCHAR1 Indicator: Is there collection authorization ?
ZSPRADZSPRALANG1 T002Language key of the payeeISOLA
ZALDTDZALDT_ZHLDATS8 Posting date of the payment document
RZAWERZAWECHAR1 T042ZPayment Method for This Payment
RUMSKRUMSKCHAR1
*
Special G/L Indicator of the Payment Transaction
RZUMSRZUMSCHAR1
*
Target Special G/L Indicator of the Payment Transaction
HKTIDHKTIDCHAR5 T012KID for account details
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
HKTIWHKTIWCHAR5 T012KShort Key of the Account Data for the Bill of Exchange
HBKIWHBKIWCHAR5 T012Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.
BVTYPBVTYPCHAR4 Partner Bank Type
UBKONUBKONCHAR2 Bank control key at our bank
UBKNTUBKNTCHAR18 Our account number at the bank
UBNKSBANKSCHAR3 T005Bank country key
UBNKLUBNKLCHAR15 Bank number of our bank
UIBANUIBANCHAR34 IBAN at our House Bank
UBHKTUBHKTCHAR10 SKB1G/L Account Number for Our Bank Account / Bank Sub-AccountALPHA
VALUTVALUTDATS8 Value date
CRVALPRQ_CRVALDATS8 Value Date at Payee's Bank
ANFAEANFAEDATS8 Bill of Exchange Payment Request Due Date
WEFAEWEFAEDATS8 Bill of Exchange Due Date
RBETRRBETRCURR13(2) Amount in Local Currency
RSKONRSKONCURR13(2) Total Cash Discount for the Payment Trans. (Local Currency)
RWBTRRWBTRCURR13(2) Amount Paid in the Payment Currency
RWSKTRWSKTCURR13(2) Total Cash Discount for the Pmnt Transactn in Pmnt Currency
RSPE1SPES1CURR11(2) Form Charges
RSPE2SPES2CURR11(2) Form Charges
RPOSTRPOSTDEC5 Number of Items Paid
RTEXTRTEXT_DDEC5 Number of Text Lines for the Items Paid
RSPM1SPEM1CURR11(2) Form Charges for Bill of Exchange with Maximum Amount
RSPM2SPEM2CURR11(2) Form Charges for Bill of Exchange with Maximum Amount
WEHMXWEHMXCURR13(2) Maximum Amount per Bill of Exchange in Local Currency
WEFMXWEFMXCURR13(2) Maximum Amount per Bill of Exchange in Payment Currency
WEHRSWEHRSCURR13(2) Remaining Amount in Local Crcy for Last Bill of Exchange
WEFRSWEFRSCURR13(2) Remaining Amount in Payment Crcy for Last Bill of Exchange
WEAMXWEAMXDEC3 Number of Bills of Exchange with Maximum Amount
BUSABBUSABCHAR2 T001SAccounting clerk


EIKTOEIKTOCHAR12 Shipper's (Our) Account Number at the Customer or Vendor
XINVEXINVECHAR1 Indicator: Capital Goods Affected?
WDATEWDATEDATS8 Bill of Exchange Issue Date
XAENDXAEND_REGUCHAR1 Indicator: Payment Proposal was Changed Afterwards
ZLSPRDZLSPRCHAR1 T008Payment Block Key
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
KURSFKURSFDEC9(5) Exchange rateEXCRT
ABWAEABWAECUKY5 TCURCSettlement currency for bank transfers
SKVHWSKVHWCURR13(2) Lost Cash Discount in Local Currency
SKVFWSKVFWCURR13(2) Lost Cash Discount in Payment Currency
DSKVHDSKVHCURR13(2) Impending Lost Cash Discount in Local Currency
ZPST2DZPST2CHAR10 P.O. box postal code of the payee
PAYGRPAYGRCHAR20 Grouping Field for Automatic Payments
ZBNKYDZBNKYCHAR15 Bank key of the payee's bank
UBNKYUBNKYCHAR15 Bank key of our bank
PSTL2PSTL2CHAR10 P.O. Box Postal Code
ABSBUABSBUCHAR4 T001Sending company code
RBET2RBET2CURR13(2) Amount Paid in Second Local Currency
RBET3RBET3CURR13(2) Amount Paid in Third Local Currency
RSKO2RSKO2CURR13(2) Payment Transaction Total Discount in Second Local Currency
RSKO3RSKO3CURR13(2) Payment Transaction Total Discount in Third Local Currency
KURS2KURS2DEC9(5) Exchange Rate for the Second Local CurrencyEXCRT
KURS3KURS3DEC9(5) Exchange Rate for the Third Local CurrencyEXCRT
BKREFBKREFCHAR20 Reference specifications for bank details
UZAWEUZAWECHAR2 T042FPayment Method Supplement
ZORT2ORT02_ZCHAR35 Location from payee's address
ZTLFXTELFX_ZCHAR31 Payee's telefax number
XSIWEXSIWECHAR1 Indicator: Bill on demand
ZPFORPFORT_ZCHAR35 City of payee's PO box
PERNRPERNR_DNUMC8 Personnel Number
SEQNRSEQC5CHAR5 Sequence Number
BTZNRBTZNRRAW1 Assignment of Transfers
AUSFDAUSFDDATS8 Due date of the paid items
AUGDTAUGDTDATS8 Clearing Date
EDIAVEDIAVCHAR1 EDI Payment Advice Status
IDOC_NUM_AVISEDI_DOCNUMNUMC16 IDoc number
EDIBNEDIBNCHAR1 EDI Payment Order Status
IDOC_NUMEDI_DOCNUMNUMC16 IDoc number

ZTELFTELFN_ZCHAR20 Payee telephone number
ZTELXTELEX_ZCHAR30 Payee telex number
KOINHKOINH_FICHAR60 Account Holder Name
DTWS1DTAT16NUMC2
*
Instruction key 1
DTWS2DTAT17NUMC2
*
Instruction key 2
DTWS3DTAT18NUMC2
*
Instruction key 3
DTWS4DTAT19NUMC2
*
Instruction key 4
ZSTC1STCD1_ZCHAR16 Payee's tax number 1
KIDNOKIDNOCHAR30 Payment Reference
PYORDPYORDCHAR10 Payment OrderALPHA
TEXTTEXTCHAR29 Text field
BTYP1BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS1BANKSCHAR3
*
Bank country key
BNKL1BANKKCHAR15 Bank Keys
BNKN1BANKNCHAR18 Bank account number
BKON1BKONTCHAR2 Bank Control Key
BKRF1BKREFCHAR20 Reference specifications for bank details
IBAN1IBANCHAR34 IBAN (International Bank Account Number)
BTYP2BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS2BANKSCHAR3
*
Bank country key
BNKL2BANKKCHAR15 Bank Keys
BNKN2BANKNCHAR18 Bank account number
BKON2BKONTCHAR2 Bank Control Key
BKRF2BKREFCHAR20 Reference specifications for bank details
IBAN2IBANCHAR34 IBAN (International Bank Account Number)
BTYP3BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS3BANKSCHAR3
*
Bank country key
BNKL3BANKKCHAR15 Bank Keys
BNKN3BANKNCHAR18 Bank account number
BKON3BKONTCHAR2 Bank Control Key
BKRF3BKREFCHAR20 Reference specifications for bank details
IBAN3IBANCHAR34 IBAN (International Bank Account Number)
SAKNRSAKNRCHAR10
*
G/L Account NumberALPHA
HKONTHKONTCHAR10
*
General Ledger AccountALPHA
ALEBNALEBNCHAR1 ALE IDoc Distribution Status of Payment Data
XKDFBXKDFB_042ECHAR1 Do not Post any Exchange Rate Differences
SRTBPBUPLACHAR4
*
Business Place
.INCLUDEIREGUH_FPM Redundant Key Fields from REGUH
FPM_KEYFPM_KEYCHAR15 Rundate, ID, and Default Indicator Concatenated
GRPNOGRPNO_FPMINT410 Grouping Criterium for Payments
SRTF1SRTF1N_FPMCHAR38 Format-specific sorting of payments incl. sequence nuber
SRTF2SRTF2N_FPMCHAR56 User-defined sorting of payments incl. sequence number
SRTF3SRTF1N_FPMCHAR38 Format-specific sorting of payments incl. sequence nuber
XCORRXCORR_FPMCHAR1 Indicator: Payment Correspondence
XAVISXAVIS_FPMCHAR1 Indicator: Separate Payment Advice
XCOPMXCOPM_FPMCHAR1 Payment Medium for Business Partner (Correspondence)
DORIGINFIBL_DORIGINCHAR8
*
Grouping Origin
RFTTRNRFTTRN_BFCHAR20 Payment code
ZADNRADRNR_ZCHAR10
*
Payee's Address NumberALPHA
ADRNRAD_ADDRNUMCHAR10
*
Address numberALPHA
ZIBANDZIBANCHAR34 IBAN of the Payee
MGUIDSEPA_MGUIDRAW16 SEPA Mandate: GUID of Mandate
SEQ_TYPESEPA_SEQ_TYPECHAR4 SEPA: Sequence Type
INST_CODEFSEPA_INST_CODECHAR4 Local Instrument Code (Direct Debit Type)
PURP_CODEFPM_PURP_CODECHAR4 SEPA Purpose Code: Classification of a Payment/Debit Memo
XMLSTXMLST_AVISCHAR1 Status of XML Payment Advice
TIMESTAMP_AVISTIMESTAMP_AVISDEC15 Time Stamp for Sending XML Payment AdviceTSTPS
.APPENDREGUH_FM Budget data section of payment data
FM_STATUSFM_PAY_STACHAR1 Availability Status for a Payment
.APPENDREGUH_FMFG U.S. Federal Government ISPS
FILE_NBRFMFG_FILE_NONUMC6 Key for multiple files from single Payment Program Print



Key field
Non-key field

REGUH relationships with other tables


REGUH-Settlement Data from Payment Program
     REGUP-Processed Items from Payment Program