SAP table REGUP (Processed items from payment program)

SAP table REGUP has 13 primary key fields being MANDT,LAUFD,LAUFI,XVORL,ZBUKR,LIFNR,KUNNR,EMPFG,VBLNR,BUKRS,BELNR,GJAHR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAUFD Date on Which the Program Is to Be Run DATS 8 0 LAUFD
LAUFI Additional Identification CHAR 6 0 LAUFI
XVORL Indicator: Only Proposal Run? CHAR 1 0 XVORL
ZBUKR Paying company code CHAR 4 0 T001 DZBUKR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
EMPFG Payment Recipient Code CHAR 16 0 EMPFG
VBLNR Document Number of the Payment Document CHAR 10 0 VBLNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
FILKD Account Number of the Branch CHAR 10 0 FILKD
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
WAERS Currency Key CUKY 5 0 TCURC WAERS
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
BVTYP Partner bank type CHAR 4 0 BVTYP
POKEN Item Indicator CHAR 3 0 POKEN
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BLART Document Type CHAR 2 0 T003 BLART
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
HKONT General Ledger Account CHAR 10 0 SKB1 HKONT
SAKNR G/L Account Number CHAR 10 0 SKB1 SAKNR
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
ZUMSK Target Special G/L Indicator CHAR 1 0 T074U DZUMSK
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
BDIFF Valuation Difference CURR 23 2 BDIFF
GSBER Business Area CHAR 4 0 TGSB GSBER
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
LWSTS Tax amount in Reporting Currency CURR 23 2 LWSTS
HIST_TAX_FACTOR Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK1 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY1 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT1 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR1 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK2 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY2 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT2 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR2 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK3 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY3 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT3 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR3 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
SGTXT Item Text CHAR 50 0 SGTXT
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
ZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
SPLEV Level on Which a Payment Block has Taken Place CHAR 1 0 SPLEV
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 CHAR 1 0 XREBZ
ZOLLT Customs Tariff Number CHAR 8 0 DZOLLT
ZOLLD Customs Date DATS 8 0 DZOLLD
LZBKZ State Central Bank Indicator CHAR 3 0 T015L LZBKZ
LANDL Supplying Country/Region CHAR 3 0 T005 LANDL
DIEKZ Service Indicator (Foreign Payment) CHAR 1 0 DIEKZ
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
QSSHB Withholding Tax Base Amount CURR 23 2 QSSHB
QBSHB Withholding Tax Amount (in Document Currency) CURR 23 2 QBSHB
QBSHH Withholding Tax Amount (in Local Currency) CURR 23 2 QBSHH
ESRNR ISR subscriber number CHAR 11 0 ESRNR
ESRRE ISR/QR Reference Number CHAR 27 0 ESRRE
ESRPZ POR check digit CHAR 2 0 ESRPZ
ZBDXT Selected cash discount days DEC 3 0 DZBDXT
ZBDXP Selected Cash Discount Percentage Rate DEC 5 3 DZBDXP
MSHBT Maximum Cash Discount Amount in Local Currency CURR 23 2 MSHBT
MSFBT Maximum Cash Discount Amount in Foreign Currency CURR 23 2 MSFBT
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
AUFNR Order Number CHAR 12 0 AUFK AUFNR
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
XANET Indicator: Down Payment in Net Procedure? CHAR 1 0 XANET
XNETB Indicator: Document posted net ? CHAR 1 0 XNETB
XNACH Indicator: Document Data Must be Reread CHAR 1 0 XNACH
ZWELS List of Respected Payment Methods CHAR 10 0 DZWELS
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
STCEG VAT Registration Number CHAR 20 0 STCEG
EGBLD Country/Region of Destination for Delivery of Goods CHAR 3 0 EGBLD
EGLLD Supplying Country/Region for Delivery of Goods CHAR 3 0 EGLLD
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
DSKVH Impending Lost Cash Discount in Local Currency CURR 23 2 DSKVH
POKLA Item Classification for Online Check Printing CHAR 1 0 POKLA
FIPOS Commitment Item CHAR 14 0 FIPOS
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
DMBE2 Amount in Second Local Currency or Global Currency CURR 23 2 DMBE2
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency CURR 23 2 DMBE3
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
SKNT2 Cash Discount Amount in Second Local Currency CURR 23 2 SKNT2
SKNT3 Cash Discount Amount in Third Local Currency CURR 23 2 SKNT3
QBSH2 Withholding Tax Amount in Second Local Currency CURR 23 2 QBSH2
QBSH3 Withholding Tax Amount in Third Local Currency CURR 23 2 QBSH3
DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
UZAWE Payment method supplement CHAR 2 0 T042F UZAWE
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
ZUONR Assignment number CHAR 18 0 DZUONR
OSKTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
VERTN Contract Number CHAR 13 0 RANL
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
REBZT Follow-On Document Type CHAR 1 0 REBZT
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
KOSTL Cost Center CHAR 10 0 KOSTL
XINVE Indicator: Capital Goods Affected? CHAR 1 0 XINVE
VBEL2 Sales Document CHAR 10 0 VBELN_VA
VPOS2 Numeric field: Length 6 NUMC 6 0 NUM06
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
ETEN2 Schedule Line Number NUMC 4 0 ETENR
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
KKBER Credit control area CHAR 4 0 T014 KKBER
EMPFB Payee/Payer CHAR 10 0 EMPFB
PRCTR Profit Center CHAR 10 0 PRCTR
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
XREF3 Reference key for line item CHAR 20 0 XREF3
ZINKZ Exempted from Interest Calculation CHAR 2 0 DZINKZ
DTWS1 Instruction Key 1 NUMC 2 0 DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 DTAT17
DTWS3 Instruction key 3 NUMC 2 0 DTAT18
DTWS4 Instruction key 4 NUMC 2 0 DTAT19
PAYT_RSN Payment Reason CHAR 4 0 FARP_PAYT_RSN
MANSP Dunning Block CHAR 1 0 MANSP
KIDNO Payment Reference CHAR 30 0 KIDNO
XCPDD Indicator: Address and Bank Data Set Individually CHAR 1 0 XCPDD
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VBEWA Flow Type CHAR 4 0 SBEWART
AGZEI Clearing Item DEC 5 0 AGZEI
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
PSSKT Cash Discount Deduction for the Item CURR 23 2 PSSKT
XPYAM Indicator: Payment Amount Predefined CHAR 1 0 XPYAM
GDIFF Total Exchange Rate Difference CURR 23 2 GDIFF
GDIF2 Total Exchange Rate Difference CURR 23 2 GDIFF
GDIF3 Total Exchange Rate Difference CURR 23 2 GDIFF
BUPLA Business Place CHAR 4 0 BUPLA
SECCO Section Code CHAR 4 0 SECCO
XSAEN Indicator: Unconfirmed Master Data Change CHAR 1 0 XSAEN
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLPOS
CESSION_KZ Accounts Receivable Pledging Indicator CHAR 2 0 TCESSION CESSION_KZ
KEYNO Key Number for Payment Request CHAR 10 0 PRQ_KEYNO
PAMTF Payment Request Amount in Payment Currency CURR 23 2 PRQ_AMTFC
ORIGIN Origin Indicator CHAR 8 0 TFIBLORIGIN FIBL_ORIGIN
PENLC1 Penalty Charge Amount in First Local Currency CURR 23 2 PENALTY1
PENLC2 Penalty Charge Amount in Second Local Currency CURR 23 2 PENALTY2
PENLC3 Penalty Charge Amount in Third Local Currency CURR 23 2 PENALTY3
PENFC Penalty Charge Amount in Document Currency CURR 23 2 PENALTY
PENDAYS Number of Days for Penalty Charge Calculation INT4 10 0 PDAYS
PPRCT Partner Profit Center CHAR 10 0 PPRCTR
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
FKBER Functional Area CHAR 16 0 FKBER
SNAME1 Name 1 CHAR 35 0 NAME1_GP
SORT01 City CHAR 35 0 ORT01_GP
SLAND1 Country/Region Key CHAR 3 0 LAND1_GP
SAMNR Invoice List Number NUMC 8 0 SAMNR
MABER Dunning Area CHAR 2 0 MABER
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
SNAME2 Name 2 CHAR 35 0 NAME2_GP
SNAME3 Name 3 CHAR 35 0 NAME3_GP
SNAME4 Name 4 CHAR 35 0 NAME4_GP
SSTRAS Street and House Number CHAR 35 0 STRAS_GP
SSTRS2 Street and House Number CHAR 35 0 STRAS_GP
SPSTLZ Postal code CHAR 10 0 PSTLZ_BAS
SID Original Payer of a Payment (ID) CHAR 35 0 SENDER_ID
RSTGR Reason Code for Payments CHAR 3 0 RSTGR
EXTACCOUNT External Account CHAR 10 0 TPM_EXT_ACCOUNT

REGUP foreign key relationships

Table Field Check Table Check Field
0 REGUP ANLN1 ANLH Main asset number BUKRS
0 REGUP ANLN1 ANLH Main asset number ANLN1
1 REGUP ANLN2 ANLA Asset Master Record Segment BUKRS
1 REGUP ANLN2 ANLA Asset Master Record Segment ANLN1
1 REGUP ANLN2 ANLA Asset Master Record Segment ANLN2
0 REGUP AUFNR AUFK Order master data AUFNR
1 REGUP BLART T003 Document Types MANDT
0 REGUP BSCHL TBSL Posting Key MANDT
0 REGUP BSCHL TBSL Posting Key BSCHL
1 REGUP BUKRS T001 Company Codes BUKRS
0 REGUP CESSION_KZ TCESSION Accounts Receivable Pledging CLIENT
0 REGUP CESSION_KZ TCESSION Accounts Receivable Pledging COMPANY
1 REGUP EBELN EKKO Purchasing Document Header EBELN
0 REGUP EBELP EKPO Purchasing Document Item MANDT
0 REGUP EBELP EKPO Purchasing Document Item EBELN
1 REGUP GSBER TGSB Business Areas MANDT
1 REGUP GSBER TGSB Business Areas GSBER
0 REGUP HBKID T012 House Banks BUKRS
1 REGUP HKONT SKB1 G/L account master (company code) MANDT
1 REGUP HKONT SKB1 G/L account master (company code) BUKRS
0 REGUP KKBER T014 Credit control areas KKBER
1 REGUP KUNNR KNA1 General Data in Customer Master MANDT
1 REGUP KUNNR KNA1 General Data in Customer Master KUNNR
0 REGUP LANDL T005 Countries MANDT
0 REGUP LANDL T005 Countries LAND1
1 REGUP LIFNR LFA1 Supplier Master (General Section) MANDT
1 REGUP LIFNR LFA1 Supplier Master (General Section) LIFNR
0 REGUP LZBKZ T015L SCB Ratios LZBKZ
1 REGUP ORIGIN TFIBLORIGIN Origin Indicator ORIGIN
0 REGUP SAKNR SKB1 G/L account master (company code) MANDT
0 REGUP SAKNR SKB1 G/L account master (company code) BUKRS
1 REGUP UMSKZ T074U Special G/L Indicator Properties MANDT
0 REGUP UZAWE T042F Payment method supplements MANDT
0 REGUP UZAWE T042F Payment method supplements UZAWE
1 REGUP VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 REGUP VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 REGUP WAERS TCURC Currency Codes MANDT
0 REGUP WAERS TCURC Currency Codes WAERS
1 REGUP ZBUKR T001 Company Codes BUKRS
0 REGUP ZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 REGUP ZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 REGUP ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
1 REGUP ZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
1 REGUP ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
0 REGUP ZUMSK T074U Special G/L Indicator Properties MANDT