1. Home
  2. Resources
  3. SAP Tables
  4. REGUE - Line items from the settlement in the payment proposal

SAP Table REGUE

Line items from the settlement in the payment proposal

REGUE (Line items from the settlement in the payment proposal) 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 REGUE to other SAP tables.

Source: REGUE (Line items from the settlement in the payment proposal)

REGUE table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
FILKD Account Number of the Branch FILKD CHAR 10 0
ZLSCH Payment Method DZLSCH CHAR 1 0
WAERS Currency Key WAERS CUKY 5 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
POKEN Item Indicator POKEN CHAR 3 0
SRID Shared Services Center: CRM Service Request SSC_OBJECT_ID CHAR 10 0
XCLOSED service request is closed SSC_SRCLOSED CHAR 1 0
X TRUE
NULL FALSE
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART CHAR 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BSCHL Posting Key BSCHL CHAR 2 0
HKONT General Ledger Account HKONT CHAR 10 0
SAKNR G/L Account Number SAKNR CHAR 10 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
ZUMSK Target Special G/L Indicator DZUMSK CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
BDIFF Valuation Difference BDIFF CURR 13 2
GSBER Business Area GSBER CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
SGTXT Item Text SGTXT CHAR 50 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
WSKTO Cash discount amount in document currency WSKTO 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
DSKVH Impending Lost Cash Discount in Local Currency DSKVH CURR 13 2
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
XNETB Indicator: Document posted net ? XNETB CHAR 1 0
X Yes
NULL No
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
SPLEV Level on Which a Payment Block has Taken Place SPLEV CHAR 1 0
1 Blocked by customer or vendor master record
2 Blocked by master record of alternative payee
3 Unconfirmed master record change for vendor/customer
4 Unconfirmed master record change for payee
5 Refused master record change for vendor/customer
6 Refused master record change for payee
XREBZ Indicator: Item is an Invoice-Related Credit Memo XREBZ CHAR 1 0
X Yes
NULL No
ZOLLT Customs Tariff Number DZOLLT CHAR 8 0
ZOLLD Customs Date DZOLLD DATS 8 0
LZBKZ State Central Bank Indicator LZBKZ CHAR 3 0
LANDL Supplying Country LANDL CHAR 3 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
QBSHH Withholding Tax Amount (in Local Currency) QBSHH CURR 13 2
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
ZBDXT Selected cash discount days DZBDXT DEC 3 0
ZBDXP Selected cash discount percentage rate DZBDXP DEC 5 3
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
VBEL2 Sales Document VBELN_VA CHAR 10 0
POSN2 Sales Document Item POSNR_VA NUMC 6 0
ETEN2 Delivery Schedule Line Number ETENR NUMC 4 0
AUFNR Order Number AUFNR CHAR 12 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
VBUND Company ID of trading partner RASSC CHAR 6 0
XANET Indicator: Down payment in net procedure ? XANET CHAR 1 0
X Yes
NULL No
INSEL Indicator: Partial Selection of Postings INSEL NUMC 1 0
VBLNR Document Number of the Payment Document VBLNR CHAR 10 0
TYPAE Type of Change TYPAE CHAR 1 0
FIPOS Commitment Item FIPOS CHAR 14 0
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
SKNT2 Cash Discount Amount in Second Local Currency SKNT2 CURR 13 2
SKNT3 Cash Discount Amount in Third Local Currency SKNT3 CURR 13 2
QBSH2 Withholding Tax Amount in Second Local Currency QBSH2 CURR 13 2
QBSH3 Withholding Tax Amount in Third Local Currency QBSH3 CURR 13 2
UZAWE Payment Method Supplement UZAWE CHAR 2 0
VERTN Contract Number RANL CHAR 13 0
EMPFB Payee/Payer EMPFB CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
XREF3 Reference key for line item XREF3 CHAR 20 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
KIDNO Payment Reference KIDNO CHAR 30 0
VBEWA Flow Type SBEWART CHAR 4 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
REBZT Follow-On Document Type REBZT CHAR 1 0
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
XSAEN Indicator: Unconfirmed master data change XSAEN CHAR 1 0
X Yes
NULL No
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
PSSKT Cash Discount Deduction for the Item PSSKT CURR 13 2
KEYNO Key Number for Payment Request PRQ_KEYNO CHAR 10 0
PENLC1 Penalty charge amount in first local currency PENALTY1 CURR 13 2
PENLC2 Penalty charge amount in second local currency PENALTY2 CURR 13 2
PENLC3 Penalty Charge Amount in Third Local Currency PENALTY3 CURR 13 2
PENFC Penalty charge amount in document currency PENALTY CURR 13 2
PENDAYS Number of days for penalty charge calculation PDAYS INT4 10 0
EXTACCOUNT External Account TPM_EXT_ACCOUNT CHAR 10 0

REGUE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REGUE ZLSPR REGUH MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
REGUE ZLSPR REGUE ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS