SAP Table REGUH_LST

Payment data (neutral communication structure)

REGUH_LST (Payment data (neutral communication structure)) 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_LST to other SAP tables.

REGUH_LST table fields

Field Data element Checktable Datatype Length Decimals
ZBUKR Paying company code DZBUKR T001 CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
EMPFG Payee code EMPFG CHAR 16 0
VBLNR Document Number of the Payment Document VBLNR CHAR 10 0
WAERS Currency Key WAERS TCURC CUKY 5 0
SRTGB Business Area GSBER CHAR 4 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 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
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
ZNME1 Name of the payee DZNME1 CHAR 35 0
ZNME2 Name of the payee DZNME1 CHAR 35 0
ZPSTL Postal code of the payee DZPSTL CHAR 10 0
ZPST2 P.O. box postal code of the payee DZPST2 CHAR 10 0
ZORT1 City of the payee DZORT1 CHAR 35 0
ZORT2 Location from payee's address ORT02_Z CHAR 35 0
ZPFOR City of payee's PO box PFORT_Z 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
ZBNKY Bank key of the payee's bank DZBNKY CHAR 15 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZBNKN Bank account number of the payee DZBNKN CHAR 18 0
ZBKON Bank Control Key of the Payee's Bank DZBKON CHAR 2 0
BKREF Reference specifications for bank details BKREF CHAR 20 0
ZIBAN IBAN of the Payee DZIBAN CHAR 34 0
ZBNKA Name of the Payee's Bank DZBNKA CHAR 60 0
ZBORT City of the Payee's Bank DZBORT CHAR 35 0
KOINH Account Holder Name KOINH_FI CHAR 60 0
ZSPRA Language key of the payee DZSPRA T002 LANG 1 0
ABSBU Sending company code ABSBU CHAR 4 0
HKTID ID for account details HKTID T012K CHAR 5 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
UBNKS Bank country key BANKS T005 CHAR 3 0
UBNKY Bank key of our bank UBNKY CHAR 15 0
UBNKL Bank number of our bank UBNKL CHAR 15 0
UBKON Bank control key at our bank UBKON CHAR 2 0
UBKNT Our account number at the bank UBKNT CHAR 18 0
UIBAN IBAN at our House Bank UIBAN CHAR 34 0
RZAWE Payment Method for This Payment RZAWE T042Z CHAR 1 0
RZAWX Name of Payment Method in Language of the Country TEXT1_042Z CHAR 30 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
UZAWX Meaning of Payment Method Supplement TEXT1_042H CHAR 30 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
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
ZALDT Posting date of the payment document DZALDT_ZHL DATS 8 0
VALUT Value date VALUT DATS 8 0
AUSFD Due date of the paid items AUSFD DATS 8 0
RBETR Amount in Local Currency RBETR CURR 13 2
RWBTR Amount Paid in the Payment Currency RWBTR CURR 13 2
RSKON Total Cash Discount for the Payment Trans. (Local Currency) RSKON CURR 13 2
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKT CURR 13 2
SKVHW Lost Cash Discount in Local Currency SKVHW CURR 13 2
SKVFW Lost Cash Discount in Payment Currency SKVFW CURR 13 2
QSTEU Withholding Tax Amount (+/-) in Local Currency QSTEV CURR 13 2
WQSTE Withholding Tax Amount (+/-) in Foreign Currency WQSTV CURR 13 2
ABZUG Total Deductions (+/-) in Local Currency ABZGV CURR 13 2
WABZG Total Deductions (+/-) in Foreign Currency WABZV CURR 13 2
BRUTT Gross Amount in Local Currency with +/- Sign DMBTV CURR 13 2
WBRUT Gross Amount in Foreign Currency with +/- Signs WRBTV CURR 13 2
NETTO Net Amount in Local Currency with +/- Signs NETTV CURR 13 2
WNETT Net Amount in Foreign Currency with +/- Signs WNETV CURR 13 2
PAYGR Grouping Field for Automatic Payments PAYGR CHAR 20 0
RPOST Number of Items Paid RPOST DEC 5 0
RTEXT Number of Text Lines for the Items Paid RTEXT_D DEC 5 0
BUSAB Accounting clerk BUSAB CHAR 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
KIDNO Payment Reference KIDNO CHAR 30 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 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
PERNR Personnel Number PERNR_D NUMC 8 0
PFORT City of payee's PO box PFORT_Z CHAR 35 0
ZSWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
ZBRCH Bank Branch BRNCH CHAR 40 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0

REGUH_LST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REGUH_LST HBKID SYST MANDT T012 House Banks MANDT
REGUH_LST HBKID REGUH_LST ZBUKR T012 House Banks BUKRS
REGUH_LST HBKID REGUH_LST HBKID T012 House Banks HBKID
REGUH_LST HKTID SYST MANDT T012K House Bank Accounts MANDT
REGUH_LST HKTID REGUH_LST ZBUKR T012K House Bank Accounts BUKRS
REGUH_LST HKTID REGUH_LST HBKID T012K House Bank Accounts HBKID
REGUH_LST HKTID REGUH_LST HKTID T012K House Bank Accounts HKTID
REGUH_LST LAND1 REGUH_LST LAND1 T005 Countries LAND1
REGUH_LST LAND1 SYST MANDT T005 Countries MANDT
REGUH_LST REGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
REGUH_LST REGIO REGUH_LST LAND1 T005S Taxes: Region (Province) Key LAND1
REGUH_LST REGIO REGUH_LST REGIO T005S Taxes: Region (Province) Key BLAND
REGUH_LST RZAWE SYST MANDT T042Z Payment Methods for Automatic Payment MANDT
REGUH_LST RZAWE T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
REGUH_LST RZAWE REGUH_LST RZAWE T042Z Payment Methods for Automatic Payment ZLSCH
REGUH_LST UBNKS SYST MANDT T005 Countries MANDT
REGUH_LST UBNKS REGUH_LST UBNKS T005 Countries LAND1
REGUH_LST UZAWE REGUH_LST UZAWE T042F Payment method supplements UZAWE
REGUH_LST UZAWE SYST MANDT T042F Payment method supplements MANDT
REGUH_LST WAERS REGUH_LST WAERS TCURC Currency Codes WAERS
REGUH_LST WAERS SYST MANDT TCURC Currency Codes MANDT
REGUH_LST ZBNKS SYST MANDT T005 Countries MANDT
REGUH_LST ZBNKS REGUH_LST ZBNKS T005 Countries LAND1
REGUH_LST ZBUKR SYST MANDT T001 Company Codes MANDT
REGUH_LST ZBUKR REGUH_LST ZBUKR T001 Company Codes BUKRS
REGUH_LST ZLAND SYST MANDT T005 Countries MANDT
REGUH_LST ZLAND REGUH_LST ZLAND T005 Countries LAND1
REGUH_LST ZREGI SYST MANDT T005S Taxes: Region (Province) Key MANDT
REGUH_LST ZREGI REGUH_LST LAND1 T005S Taxes: Region (Province) Key LAND1
REGUH_LST ZREGI REGUH_LST ZREGI T005S Taxes: Region (Province) Key BLAND
REGUH_LST ZSPRA REGUH_LST ZSPRA T002 Language Keys (Component BC-I18) SPRAS