REGUP SAP (Processed items from payment program) Cluster Table details
Dictionary Type: Cluster Table
Description: Processed items from payment program
Description: Processed items from payment program
Cluster Table field list including key, data, relationships and ABAP select examples
REGUP is a standard SAP Cluster Table which is used to store Processed items from payment program data and is available within R/3 SAP systems depending on the version and release level.
The REGUP table consists of various fields, each holding specific information or linking keys about Processed items from payment program data available in SAP. These include LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), XVORL (Indicator: Only Proposal Run?), ZBUKR (Paying company code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP REGUP cluster table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | DATUM | ||||
LAUFI | Additional Identification | LAUFI | CHAR | 6 | LAUFI | ||||
XVORL | Indicator: Only Proposal Run? | XVORL | CHAR | 1 | XFELD | ||||
ZBUKR | Paying company code | DZBUKR | CHAR | 4 | T001 | BUKRS | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
EMPFG | Payee code | EMPFG | CHAR | 16 | EMPFG | ||||
VBLNR | Document Number of the Payment Document | VBLNR | CHAR | 10 | ALPHA | BELNR | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
POKEN | Item Indicator | POKEN | CHAR | 3 | CHAR3 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | T074U | UMSKZ | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
BDIFF | Valuation Difference | BDIFF | CURR | 13(2) | WRTV7 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
MWSK1 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBT1 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT1 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK2 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBT2 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT2 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK3 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBT3 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT3 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
SPLEV | Level on Which a Payment Block has Taken Place | SPLEV | CHAR | 1 | SPLEV | ||||
XREBZ | Indicator: Item is an Invoice-Related Credit Memo | XREBZ | CHAR | 1 | XFELD | ||||
ZOLLT | Customs Tariff Number | DZOLLT | CHAR | 8 | ZOLLT | ||||
ZOLLD | Customs Date | DZOLLD | DATS | 8 | DATUM | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | CURR | 13(2) | WERT7 | ||||
QBSHH | Withholding Tax Amount (in Local Currency) | QBSHH | CURR | 13(2) | WERT7 | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
ZBDXT | Selected cash discount days | DZBDXT | DEC | 3 | ZBDXT | ||||
ZBDXP | Selected cash discount percentage rate | DZBDXP | DEC | 5(3) | PRZ23 | ||||
MSHBT | Maximum Cash Discount Amount in Local Currency | MSHBT | CURR | 13(2) | WERT7 | ||||
MSFBT | Maximum Cash Discount Amount in Foreign Currency | MSFBT | CURR | 13(2) | WERT7 | ||||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
XANET | Indicator: Down payment in net procedure ? | XANET | CHAR | 1 | XFELD | ||||
XNETB | Indicator: Document posted net ? | XNETB | CHAR | 1 | XFELD | ||||
XNACH | Indicator: Document Data Must be Reread | XNACH | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | Assigned to domain | LAND1 | |||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | Assigned to domain | LAND1 | |||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
BDIF2 | Valuation Difference for the Second Local Currency | BDIF2 | CURR | 13(2) | WRTV7 | ||||
DSKVH | Impending Lost Cash Discount in Local Currency | DSKVH | CURR | 13(2) | WERT7 | ||||
POKLA | Item Classification for Online Check Printing | POKLA | CHAR | 1 | CHAR1 | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
BDIF3 | Valuation Difference for the Third Local Currency | BDIF3 | CURR | 13(2) | WRTV7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
MWST2 | Tax Amount in Second Local Currency | MWST2 | CURR | 13(2) | WERT7 | ||||
SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13(2) | WERT7 | ||||
SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13(2) | WERT7 | ||||
QBSH2 | Withholding Tax Amount in Second Local Currency | QBSH2 | CURR | 13(2) | WERT7 | ||||
QBSH3 | Withholding Tax Amount in Third Local Currency | QBSH3 | CURR | 13(2) | WERT7 | ||||
DMB21 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB22 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB23 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB31 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB32 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB33 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
MWST3 | Tax Amount in Third Local Currency | MWST3 | CURR | 13(2) | WERT7 | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
OSKTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VPOS2 | Numeric field: Length 6 | NUM06 | NUMC | 6 | NUM06 | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | Assigned to domain | WAERS | |||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
PSSKT | Cash Discount Deduction for the Item | PSSKT | CURR | 13(2) | WRTV7 | ||||
XPYAM | Indicator: Payment Amount Predefined | XPYAM | CHAR | 1 | XFELD | ||||
GDIFF | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
GDIF2 | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
GDIF3 | Total Exchange Rate Difference | GDIFF | CURR | 13(2) | WRTV7 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
XSAEN | Indicator: Unconfirmed master data change | XSAEN | CHAR | 1 | XFELD | ||||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | TCESSION | CESSION_KZ | |||
KEYNO | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | Assigned to domain | ALPHA | PRQ_KEYNO | ||
PAMTF | Payment Request Amount in Payment Currency | PRQ_AMTFC | CURR | 13(2) | WERT7 | ||||
ORIGIN | Origin Indicator | FIBL_ORIGIN | CHAR | 8 | TFIBLORIGIN | FIBL_ORIGIN | |||
PENLC1 | Penalty charge amount in first local currency | PENALTY1 | CURR | 13(2) | WERT13 | ||||
PENLC2 | Penalty charge amount in second local currency | PENALTY2 | CURR | 13(2) | WERT13 | ||||
PENLC3 | Penalty Charge Amount in Third Local Currency | PENALTY3 | CURR | 13(2) | WERT13 | ||||
PENFC | Penalty charge amount in document currency | PENALTY | CURR | 13(2) | WERT13 | ||||
PENDAYS | Number of days for penalty charge calculation | PDAYS | INT4 | 10 | INT4 | ||||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
SNAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
SORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SLAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SNAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
SNAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
SNAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
SSTRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SSTRS2 | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SPSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
SID | Original Payer of a Payment (ID) | SENDER_ID | CHAR | 35 | CHAR35 | ||||
.INCLU--AP | 0 | ||||||||
EXTACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT |
Key field | Non-key field |
How do I retrieve data from SAP table REGUP using ABAP code
The following ABAP code Example will allow you to do a basic selection on REGUP to SELECT all data from the tableDATA: WA_REGUP TYPE REGUP.
SELECT SINGLE *
FROM REGUP
INTO CORRESPONDING FIELDS OF WA_REGUP
WHERE...
How to access SAP table REGUP
Within an ECC or HANA version of SAP you can also view further information about REGUP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects