REGUH

Settlement data from payment program | #transactional | Component: Payment Progam / Payment transfer (DE, JP, US)
Column Name Description
MANDT FK Client
LAUFD Date on Which the Program Is to Be Run
LAUFI Additional Identification
XVORL Indicator: Only Proposal Run? Show values
ZBUKR FK Paying company code
LIFNR FK Account Number of Supplier
KUNNR FK Customer Number
EMPFG Payment Recipient Code
VBLNR Document Number of the Payment Document
Column Name Description
💲 Currency Key (T001.WAERS):
RBETR Amount in Local Currency
RSKON Total Cash Discount for the Payment Trans. (Local Currency)
RWBTR Amount Paid in the Payment Currency
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency
RSPE1 Form Charges
RSPE2 Form Charges
RSPM1 Form Charges for Bill of Exchange with Maximum Amount
RSPM2 Form Charges for Bill of Exchange with Maximum Amount
WEHMX Maximum Amount per Bill of Exchange in Local Currency
WEFMX Maximum Amount per Bill of Exchange in Payment Currency
WEHRS Remaining Amount in Local Crcy for Last Bill of Exchange
WEFRS Remaining Amount in Payment Crcy for Last Bill of Exchange
SKVHW Lost Cash Discount in Local Currency
SKVFW Lost Cash Discount in Payment Currency
DSKVH Impending Lost Cash Discount in Local Currency
💲 Currency Key of Second Local Currency (BKPF.HWAE2):
RBET2 Amount Paid in Second Local Currency
RSKO2 Payment Transaction Total Discount in Second Local Currency
💲 Currency Key of Third Local Currency (BKPF.HWAE3):
RBET3 Amount Paid in Third Local Currency
RSKO3 Payment Transaction Total Discount in Third Local Currency
Column Name Description
Column Name Description
LAUFD Date on Which the Program Is to Be Run
ZALDT Posting Date of Payment Document
VALUT Value date
CRVAL Value Date at Payee's Bank
ANFAE Bill of Exchange Payment Request Due Date
WEFAE Bill of Exchange Due Date
WDATE Bill of Exchange Issue Date
AUSFD Due date of the paid items
AUGDT Clearing Date
Column Name Description
XVORL Indicator: Only Proposal Run? Show values
AVISG Reason for Printing Payment Advice Show values
WEVWV Planned Usage of the Bill of Exchange Show values
XEZER Indicator: Is there collection authorization ? Show values
XINVE Indicator: Capital Goods Affected? Show values
XAEND Indicator: Payment Proposal was Changed Afterwards Show values
DTAMS Report key for data medium exchange Show values
XSIWE Indicator: Bill on Demand Show values
EDIAV EDI Payment Advice Status Show values
EDIBN EDI Payment Order Status Show values
BTYP1 Type of bank in a bank chain (correspondent, intermediary) Show values
BTYP2 Type of bank in a bank chain (correspondent, intermediary) Show values
BTYP3 Type of bank in a bank chain (correspondent, intermediary) Show values
ALEBN ALE IDoc Distribution Status of Payment Data Show values
XKDFB Do not Post any Exchange Rate Differences Show values
GRPNO Grouping Criterium for Payments Show values
XCORR Indicator: Payment Correspondence Show values
XAVIS Indicator: Separate Payment Advice Show values
XCOPM Payment Medium for Business Partner (Correspondence) Show values
SEQ_TYPE SEPA: Sequence Type Show values
INST_CODE Local Instrument Code (Direct Debit Type) Show values
XMLST Status of XML Payment Advice Show values
FM_STATUS Availability Status for a Payment Show values
Column Name Description Domain name
ANRED Title TEXT15
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
STCD1 Tax Number 1 STCD1
ZANRE Title of the payee TEXT15
ZNME1 Name of the payee TEXT35
ZNME2 Name of the payee TEXT35
ZNME3 Name of the payee TEXT35
ZNME4 Name of the payee TEXT35
ZPSTL Postal Code of the Payee PSTLZ
ZORT1 City of the payee TEXT35
ZSTRA Street and house number of the payee TEXT35
ZPFAC P.O. box of the payee PFACH
ZBNKN Bank account number of the payee BANKN
ZBNKN_LONG Bank Account Number of the Payee BANKN35
ZBNKL Bank number of the payee's bank BANKL
ZBKON Bank Control Key of the Payee's Bank BKONT
ZBVTY Bank Data Indicator for the Payee BVTYP
ZSWIF SWIFT/BIC for International Payments SWIFT
RUMSK Special G/L Indicator of the Payment Transaction UMSKZ
RZUMS Target Special G/L Indicator of the Payment Transaction UMSKZ
BVTYP Partner bank type BVTYP
UBKON Bank control key at our bank BKONT
UBKNT Our account number at the bank BANKN
UBKNT_LONG Our Account Number at the Bank BANKN35
UBNKL Bank number of our bank BANKL
UIBAN IBAN at Our House Bank IBAN
RPOST Number of Items Paid PACK3
RTEXT Number of Text Lines for the Items Paid PACK3
WEAMX Number of Bills of Exchange with Maximum Amount PACK2
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR12
DTAWS Instruction Key for Data Medium Exchange DTAWS
KURSF Exchange rate KURSF
ZPST2 P.O. box postal code of the payee PSTLZ
PAYGR Grouping Field for Automatic Payments CHAR20
ZBNKY Bank key of the payee's bank BANKK
UBNKY Bank Key of Our Bank BANKK
PSTL2 P.O. Box Postal Code PSTLZ
KURS2 Exchange Rate for the Second Local Currency KURSF
KURS3 Exchange Rate for the Third Local Currency KURSF
BKREF Reference Details for Bank Details CHAR20
ZORT2 Location from payee's address TEXT35
ZTLFX Payee's telefax number TEXT31
ZPFOR City of payee's PO box TEXT35
PERNR Personnel Number PERNR
SEQNR Sequence Number CHAR5
BTZNR Assignment of Transfers RAW1
IDOC_NUM_AVIS IDoc number EDI_DOCNUM
IDOC_NUM IDoc number EDI_DOCNUM
ZTELF Payee telephone number TEXT20
ZTELX Payee telex number TEXT30
KOINH Account Holder Name KOINH
DTWS1 Instruction Key 1 DTWSX
DTWS2 Instruction Key 2 DTWSX
DTWS3 Instruction key 3 DTWSX
DTWS4 Instruction key 4 DTWSX
ZSTC1 Payee's tax number 1 STCD1
KIDNO Payment Reference CHAR30
PYORD Payment Order PYORD
REGIO Region (State, Province, County) REGIO
TEXT Text field FL_TEXT
BNKS1 Country/Region Key of Bank LAND1
BNKL1 Bank Keys BANKK
BNKN1 Bank account number BANKN
BKON1 Bank Control Key BKONT
BKRF1 Reference Details for Bank Details CHAR20
IBAN1 IBAN (International Bank Account Number) IBAN
BNKS2 Country/Region Key of Bank LAND1
BNKL2 Bank Keys BANKK
BNKN2 Bank account number BANKN
BKON2 Bank Control Key BKONT
BKRF2 Reference Details for Bank Details CHAR20
IBAN2 IBAN (International Bank Account Number) IBAN
BNKS3 Country/Region Key of Bank LAND1
BNKL3 Bank Keys BANKK
BNKN3 Bank account number BANKN
BKON3 Bank Control Key BKONT
BKRF3 Reference Details for Bank Details CHAR20
IBAN3 IBAN (International Bank Account Number) IBAN
SAKNR G/L Account Number SAKNR
HKONT General Ledger Account SAKNR
SRTBP Business Place J_1BBRANCH
FPM_KEY Rundate, ID, and Default Indicator Concatenated
SRTF1 Format-Specific Sorting of Payments incl. Sequence Number CHAR38
SRTF2 User-Defined Sorting of Payments incl. Sequence Number CHAR56
SRTF3 Format-Specific Sorting of Payments incl. Sequence Number CHAR38
DORIGIN Grouping Origin FIBL_ORIGIN
RFTTRN Payment code RFTTRN_BF
ZADNR Payee's Address Number AD_ADDRNUM
ADRNR Address Number AD_ADDRNUM
ZIBAN IBAN of the Payee IBAN
MGUID SEPA Mandate: GUID of Mandate
PURP_CODE SEPA Purpose Code: Classification of a Payment/Debit Memo CHAR4
TIMESTAMP_AVIS Time Stamp for Sending XML Payment Advice FI_TIMESTAMP
UETR Unique Transaction Reference (UETR) SMUM_C36
FILE_NBR Key for multiple files from single Payment Program Print
Master Data Relations Join Conditions
Sending company code
  • REGUH.MANDT == T001.MANDT
  • REGUH.ABSBU == T001.BUKRS
Settlement currency for bank transfers
  • REGUH.MANDT == TCURC.MANDT
  • REGUH.ABWAE == TCURC.WAERS
Accounting Clerk Abbreviation
  • Sending company code
  • Client
  • Accounting Clerk Abbreviation
  • REGUH.ABSBU == T001S.BUKRS
  • REGUH.MANDT == T001S.MANDT
  • REGUH.BUSAB == T001S.BUSAB
Short Key for a House Bank
  • Short Key for a House Bank
  • Paying company code
  • REGUH.MANDT == T012.MANDT
  • REGUH.HBKID == T012.HBKID
  • REGUH.ZBUKR == T012.BUKRS
Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.
  • Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.
  • Paying company code
  • REGUH.MANDT == T012.MANDT
  • REGUH.HBKIW == T012.HBKID
  • REGUH.ZBUKR == T012.BUKRS
ID for Account Details
  • Paying company code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • REGUH.ZBUKR == T012K.BUKRS
  • REGUH.HKTID == T012K.HKTID
  • REGUH.MANDT == T012K.MANDT
  • REGUH.HBKID == T012K.HBKID
Short Key of the Account Data for the Bill of Exchange
  • Paying company code
  • Short Key of the Account Data for the Bill of Exchange
  • Client
  • Short Key for a House Bank
  • REGUH.ZBUKR == T012K.BUKRS
  • REGUH.HKTIW == T012K.HKTID
  • REGUH.MANDT == T012K.MANDT
  • REGUH.HBKID == T012K.HBKID
Customer Number
  • REGUH.MANDT == KNA1.MANDT
  • REGUH.KUNNR == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • REGUH.LAND1 == T005.LAND1
  • REGUH.MANDT == T005.MANDT
Account Number of Supplier
  • REGUH.MANDT == LFA1.MANDT
  • REGUH.LIFNR == LFA1.LIFNR
Client REGUH.MANDT == T000.MANDT
Payment Reason
Payment Method for This Payment
  • Payment Method for This Payment
  • Country/Region Key
  • REGUH.MANDT == T042Z.MANDT
  • REGUH.RZAWE == T042Z.ZLSCH
  • REGUH.LAND1 == T042Z.LAND1
Business Area
  • REGUH.MANDT == TGSB.MANDT
  • REGUH.SRTGB == TGSB.GSBER
G/L Account Number for Our Bank Account / Bank Subaccount
  • Paying company code
  • Client
  • G/L Account Number for Our Bank Account / Bank Subaccount
  • REGUH.ZBUKR == SKB1.BUKRS
  • REGUH.MANDT == SKB1.MANDT
  • REGUH.UBHKT == SKB1.SAKNR
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • REGUH.UBNKS == T005.LAND1
  • REGUH.MANDT == T005.MANDT
Payment method supplement
  • REGUH.MANDT == T042F.MANDT
  • REGUH.UZAWE == T042F.UZAWE
Currency Key
  • REGUH.MANDT == TCURC.MANDT
  • REGUH.WAERS == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • REGUH.ZBNKS == T005.LAND1
  • REGUH.MANDT == T005.MANDT
Paying company code
  • REGUH.MANDT == T001.MANDT
  • REGUH.ZBUKR == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • REGUH.ZLAND == T005.LAND1
  • REGUH.MANDT == T005.MANDT
Payment Block Key
  • Payment Block Key
  • Client
  • REGUH.ZLSPR == T008.ZAHLS
  • REGUH.MANDT == T008.MANDT
Regional code of the payee
  • Country/Region Key
  • Regional code of the payee
  • REGUH.MANDT == T005S.MANDT
  • REGUH.ZLAND == T005S.LAND1
  • REGUH.ZREGI == T005S.BLAND
Language key of the payee REGUH.ZSPRA == T002.SPRAS