REGUP

Transparent Table Application Table
207 Fields 8 CDS Views

Processed items from payment program

REGUP is an SAP database table in S/4HANA. Processed items from payment program. It contains 207 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
FACVD_CLRIT_05 view from Open items of incoming payment for manual clearing
FACVD_CLRIT_06 view from Open items of outgoing payment for manual clearing
FACVD_CLROI_03 view from Open items which are locked by the payment process
FACVD_CLROI_03 view union_all Open items which are locked by the payment process
I_PrepaymentSettlementItem view from BASIC Prepayment Settlement Item
P_PaymentProposalItem view from BASIC
R_PaymentProposalItem view from BASIC Payment Proposal Item
TSI_BAT_STATUS_entry view inner

Fields (207)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY laufd LAUFD Run On
KEY laufi LAUFI Identification
KEY xvorl XVORL Indicator: Only Proposal Run?
KEY zbukr DZBUKR Paying co. code
KEY lifnr LIFNR Supplier
KEY kunnr KUNNR Customer
KEY empfg EMPFG Pmnt Recipient
KEY vblnr VBLNR Payment Doc.No.
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY buzei BUZEI Item
filkd FILKD Branch
zlsch DZLSCH Pymt Meth.
waers WAERS Currency
hbkid HBKID House Bank
bvtyp BVTYP Part.bank type
poken POKEN Item Indicator
xblnr XBLNR1 Reference
blart BLART Document Type
budat BUDAT Posting Date
bldat BLDAT Document Date
koart KOART Account type
bschl BSCHL Posting Key
hkont HKONT G/L Acct
saknr SAKNR G/L Account
umskz UMSKZ Special G/L Ind
umsks UMSKS Transact.Type
zumsk DZUMSK Trg.Sp.G/L Ind.
shkzg SHKZG Debit/Credit
dmbtr DMBTR Amount in LC
wrbtr WRBTR Amount
bdiff BDIFF Valuation Diff.
gsber GSBER Business Area
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
mwskz MWSKZ Tax Code
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
mwsts MWSTS LC Tax
wmwst WMWST Tax Amount
lwsts LWSTS RC Tax
hist_tax_factor FOT_HIST_FACTOR_FOR_TAX_AMOUNT CrcyCnvrsnFctrTaxAmt
mwsk1 MWSKX Tax Code
txdat_from1 FOT_TXDAT_FROMX Tax Rate Valid-From
tax_country1 FOT_TAX_COUNTRYX Tax Breakdown C/R
dmbt1 DMBTX Amount
wrbt1 WRBTX Amount
hist_tax_factor1 FOT_HIST_FACTOR_FOR_TAX_AMOUNT CrcyCnvrsnFctrTaxAmt
mwsk2 MWSKX Tax Code
txdat_from2 FOT_TXDAT_FROMX Tax Rate Valid-From
tax_country2 FOT_TAX_COUNTRYX Tax Breakdown C/R
dmbt2 DMBTX Amount
wrbt2 WRBTX Amount
hist_tax_factor2 FOT_HIST_FACTOR_FOR_TAX_AMOUNT CrcyCnvrsnFctrTaxAmt
mwsk3 MWSKX Tax Code
txdat_from3 FOT_TXDAT_FROMX Tax Rate Valid-From
tax_country3 FOT_TAX_COUNTRYX Tax Breakdown C/R
dmbt3 DMBTX Amount
wrbt3 WRBTX Amount
hist_tax_factor3 FOT_HIST_FACTOR_FOR_TAX_AMOUNT CrcyCnvrsnFctrTaxAmt
sgtxt SGTXT Text
zfbdt DZFBDT Baseline Date
zterm DZTERM Pyt Terms
zbd1t DZBD1T Days 1
zbd2t DZBD2T Days 2
zbd3t DZBD3T Days Net
zbd1p DZBD1P CD Percentage 1
zbd2p DZBD2P CD Percentage 2
skfbt SKFBT CD Base
sknto SKNTO Discount Amt
wskto WSKTO CD Amount
zbfix DZBFIX Fixed
zlspr DZLSPR Pmnt block
splev SPLEV Block Level
xrebz XREBZ Invoice Refer.
zollt DZOLLT Cust.Tariff No.
zolld DZOLLD Customs Date
lzbkz LZBKZ SCB Ind.
landl LANDL Supply C/R
diekz DIEKZ Service Ind.
qsskz QSSKZ WTax Code
qsshb QSSHB WTax Base
qbshb QBSHB Withholding Tax
qbshh QBSHH Withholding Tax
esrnr ESRNR ISR Number
esrre ESRRE ISR/QR Ref.
esrpz ESRPZ Check digit
zbdxt DZBDXT Cash Disc.Days
zbdxp DZBDXP Cash Discount %
mshbt MSHBT Maximum Cash Discount Amount in Local Currency
msfbt MSFBT Maximum Cash Discount Amount in Foreign Currency
projn PROJN not in use
aufnr AUFNR Order
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
xanet XANET Indicator: Down Payment in Net Procedure?
xnetb XNETB Net document type
xnach XNACH Indicator: Document Data Must be Reread
zwels DZWELS Payment Methods
vbund RASSC Trading Partner
stceg STCEG VAT Reg. No.
egbld EGBLD Dest. C/R
eglld EGLLD Supplying C/R
qsznr QSZNR Exemption No.
bdif2 BDIF2 Valuation Diff. 2
dskvh DSKVH Imp. Lost Disc.
pokla POKLA Item Class
fipos FIPOS Commitment item
projk PS_PSP_PNR WBS Element
nplnr NPLNR Network
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter
xegdr XEGDR EU Triang. Deal
bdif3 BDIF3 Valuation Diff. 3
dmbe2 DMBE2 LC2 Amount
dmbe3 DMBE3 LC3 Amount
mwst2 MWST2 LC2 Tax
sknt2 SKNT2 CD Amt LC2
sknt3 SKNT3 CD Amt LC3
qbsh2 QBSH2 LC2 WTax
qbsh3 QBSH3 LC3 WTax
dmb21 DMB2X Amount
dmb22 DMB2X Amount
dmb23 DMB2X Amount
dmb31 DMB3X Amount
dmb32 DMB3X Amount
dmb33 DMB3X Amount
uzawe UZAWE Pmnt Meth. Sup.
mwst3 MWST3 LC3 Tax
zuonr DZUONR Assignment
oskto SKNTO Discount Amt
vertn RANL Contract Number
imkey IMKEY Real Estate Key
rebzt REBZT Follow-On Doc. Type
rebzg REBZG Invoice Ref.
rebzj REBZJ Fiscal Year
rebzz REBZZ Item
kostl KOSTL Cost Center
xinve XINVE Invest.ID
vbel2 VBELN_VA Sales Document
vpos2 NUM06 Number
zekkn DZEKKN Account Assgmt No.
posn2 POSNR_VA Item
eten2 ETENR Schedule Line
fistl FISTL Funds Center
geber BP_GEBER Fund
dabrz DABRBEZ Reference date
kkber KKBER Cred.Contr.Area
empfb EMPFB Payer
prctr PRCTR Profit Center
xref1 XREF1 Reference Key 1
xref2 XREF2 Reference Key 2
xref3 XREF3 Reference Key 3
zinkz DZINKZ Interest Block
dtws1 DTAT16 Instruct. Key 1
dtws2 DTAT17 Instruct. Key 2
dtws3 DTAT18 Instruct. key 3
dtws4 DTAT19 Instruct. key 4
payt_rsn FARP_PAYT_RSN Payment Reason
mansp MANSP Dunn. Block
kidno KIDNO Payment Ref.
xcpdd XCPDD Individ. Set
vertt RANTYP Contract Type
vbewa SBEWART Flow Type
agzei AGZEI Clearing Item
pswsl PSWSL G/L Currency
pswbt PSWBT G/L Amount
psskt PSSKT G/L Discount
xpyam XPYAM Predef.Pmnt Amt
gdiff GDIFF Exch.Rate Diff.
gdif2 GDIFF Exch.Rate Diff.
gdif3 GDIFF Exch.Rate Diff.
bupla BUPLA Business place
secco SECCO Section Code
xsaen XSAEN Unconfirm.Chnge
kblnr KBLNR_FI Earmarked funds
kblpos KBLPOS Document Item
cession_kz CESSION_KZ AR Pledging Ind
keyno PRQ_KEYNO Key Number
pamtf PRQ_AMTFC PC Amount
origin FIBL_ORIGIN Origin
penlc1 PENALTY1 Penalty Chge LC
penlc2 PENALTY2 Pen.Charge LC2
penlc3 PENALTY3 Pen.Charge LC3
penfc PENALTY Penalty Charge
pendays PDAYS Days in Arrears
pprct PPRCTR Partner PC
grant_nbr GM_GRANT_NBR Grant
fkber FKBER Functional Area
sname1 NAME1_GP Name
sort01 ORT01_GP City
sland1 LAND1_GP Country/Region Key
samnr SAMNR Collect.Inv.
maber MABER Dunning Area
budget_pd FM_BUDGET_PERIOD Budget Period
sname2 NAME2_GP Name 2
sname3 NAME3_GP Name 3
sname4 NAME4_GP Name 4
sstras STRAS_GP Street
sstrs2 STRAS_GP Street
spstlz PSTLZ_BAS Postal Code
sid SENDER_ID Payer of a Payment
rstgr RSTGR Reason Code
j_1tpbupl BCODE Branch Code
extaccount TPM_EXT_ACCOUNT External Account

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Processed items from payment program
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REGUP (
    MANDT,             -- Client [MANDT]
    LAUFD,             -- Run On [LAUFD]
    LAUFI,             -- Identification [LAUFI]
    XVORL,             -- Indicator: Only Proposal Run? [XVORL]
    ZBUKR,             -- Paying co. code [DZBUKR]
    LIFNR,             -- Supplier [LIFNR]
    KUNNR,             -- Customer [KUNNR]
    EMPFG,             -- Pmnt Recipient [EMPFG]
    VBLNR,             -- Payment Doc.No. [VBLNR]
    BUKRS,             -- Company Code [BUKRS]
    BELNR,             -- Document Number [BELNR_D]
    GJAHR,             -- Fiscal Year [GJAHR]
    BUZEI,             -- Item [BUZEI]
    FILKD,             -- Branch [FILKD]
    ZLSCH,             -- Pymt Meth. [DZLSCH]
    WAERS,             -- Currency [WAERS]
    HBKID,             -- House Bank [HBKID]
    BVTYP,             -- Part.bank type [BVTYP]
    POKEN,             -- Item Indicator [POKEN]
    XBLNR,             -- Reference [XBLNR1]
    BLART,             -- Document Type [BLART]
    BUDAT,             -- Posting Date [BUDAT]
    BLDAT,             -- Document Date [BLDAT]
    KOART,             -- Account type [KOART]
    BSCHL,             -- Posting Key [BSCHL]
    HKONT,             -- G/L Acct [HKONT]
    SAKNR,             -- G/L Account [SAKNR]
    UMSKZ,             -- Special G/L Ind [UMSKZ]
    UMSKS,             -- Transact.Type [UMSKS]
    ZUMSK,             -- Trg.Sp.G/L Ind. [DZUMSK]
    SHKZG,             -- Debit/Credit [SHKZG]
    DMBTR,             -- Amount in LC [DMBTR]
    WRBTR,             -- Amount [WRBTR]
    BDIFF,             -- Valuation Diff. [BDIFF]
    GSBER,             -- Business Area [GSBER]
    TAX_COUNTRY,       -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    MWSKZ,             -- Tax Code [MWSKZ]
    TXDAT_FROM,        -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    MWSTS,             -- LC Tax [MWSTS]
    WMWST,             -- Tax Amount [WMWST]
    LWSTS,             -- RC Tax [LWSTS]
    HIST_TAX_FACTOR,   -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
    MWSK1,             -- Tax Code [MWSKX]
    TXDAT_FROM1,       -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
    TAX_COUNTRY1,      -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
    DMBT1,             -- Amount [DMBTX]
    WRBT1,             -- Amount [WRBTX]
    HIST_TAX_FACTOR1,  -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
    MWSK2,             -- Tax Code [MWSKX]
    TXDAT_FROM2,       -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
    TAX_COUNTRY2,      -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
    DMBT2,             -- Amount [DMBTX]
    WRBT2,             -- Amount [WRBTX]
    HIST_TAX_FACTOR2,  -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
    MWSK3,             -- Tax Code [MWSKX]
    TXDAT_FROM3,       -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
    TAX_COUNTRY3,      -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
    DMBT3,             -- Amount [DMBTX]
    WRBT3,             -- Amount [WRBTX]
    HIST_TAX_FACTOR3,  -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
    SGTXT,             -- Text [SGTXT]
    ZFBDT,             -- Baseline Date [DZFBDT]
    ZTERM,             -- Pyt Terms [DZTERM]
    ZBD1T,             -- Days 1 [DZBD1T]
    ZBD2T,             -- Days 2 [DZBD2T]
    ZBD3T,             -- Days Net [DZBD3T]
    ZBD1P,             -- CD Percentage 1 [DZBD1P]
    ZBD2P,             -- CD Percentage 2 [DZBD2P]
    SKFBT,             -- CD Base [SKFBT]
    SKNTO,             -- Discount Amt [SKNTO]
    WSKTO,             -- CD Amount [WSKTO]
    ZBFIX,             -- Fixed [DZBFIX]
    ZLSPR,             -- Pmnt block [DZLSPR]
    SPLEV,             -- Block Level [SPLEV]
    XREBZ,             -- Invoice Refer. [XREBZ]
    ZOLLT,             -- Cust.Tariff No. [DZOLLT]
    ZOLLD,             -- Customs Date [DZOLLD]
    LZBKZ,             -- SCB Ind. [LZBKZ]
    LANDL,             -- Supply C/R [LANDL]
    DIEKZ,             -- Service Ind. [DIEKZ]
    QSSKZ,             -- WTax Code [QSSKZ]
    QSSHB,             -- WTax Base [QSSHB]
    QBSHB,             -- Withholding Tax [QBSHB]
    QBSHH,             -- Withholding Tax [QBSHH]
    ESRNR,             -- ISR Number [ESRNR]
    ESRRE,             -- ISR/QR Ref. [ESRRE]
    ESRPZ,             -- Check digit [ESRPZ]
    ZBDXT,             -- Cash Disc.Days [DZBDXT]
    ZBDXP,             -- Cash Discount % [DZBDXP]
    MSHBT,             -- Maximum Cash Discount Amount in Local Currency [MSHBT]
    MSFBT,             -- Maximum Cash Discount Amount in Foreign Currency [MSFBT]
    PROJN,             -- not in use [PROJN]
    AUFNR,             -- Order [AUFNR]
    ANLN1,             -- Asset [ANLN1]
    ANLN2,             -- Sub-number [ANLN2]
    EBELN,             -- Purchasing Doc. [EBELN]
    EBELP,             -- Item [EBELP]
    XANET,             -- Indicator: Down Payment in Net Procedure? [XANET]
    XNETB,             -- Net document type [XNETB]
    XNACH,             -- Indicator: Document Data Must be Reread [XNACH]
    ZWELS,             -- Payment Methods [DZWELS]
    VBUND,             -- Trading Partner [RASSC]
    STCEG,             -- VAT Reg. No. [STCEG]
    EGBLD,             -- Dest. C/R [EGBLD]
    EGLLD,             -- Supplying C/R [EGLLD]
    QSZNR,             -- Exemption No. [QSZNR]
    BDIF2,             -- Valuation Diff. 2 [BDIF2]
    DSKVH,             -- Imp. Lost Disc. [DSKVH]
    POKLA,             -- Item Class [POKLA]
    FIPOS,             -- Commitment item [FIPOS]
    PROJK,             -- WBS Element [PS_PSP_PNR]
    NPLNR,             -- Network [NPLNR]
    AUFPL,             -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,             -- Counter [CIM_COUNT]
    XEGDR,             -- EU Triang. Deal [XEGDR]
    BDIF3,             -- Valuation Diff. 3 [BDIF3]
    DMBE2,             -- LC2 Amount [DMBE2]
    DMBE3,             -- LC3 Amount [DMBE3]
    MWST2,             -- LC2 Tax [MWST2]
    SKNT2,             -- CD Amt LC2 [SKNT2]
    SKNT3,             -- CD Amt LC3 [SKNT3]
    QBSH2,             -- LC2 WTax [QBSH2]
    QBSH3,             -- LC3 WTax [QBSH3]
    DMB21,             -- Amount [DMB2X]
    DMB22,             -- Amount [DMB2X]
    DMB23,             -- Amount [DMB2X]
    DMB31,             -- Amount [DMB3X]
    DMB32,             -- Amount [DMB3X]
    DMB33,             -- Amount [DMB3X]
    UZAWE,             -- Pmnt Meth. Sup. [UZAWE]
    MWST3,             -- LC3 Tax [MWST3]
    ZUONR,             -- Assignment [DZUONR]
    OSKTO,             -- Discount Amt [SKNTO]
    VERTN,             -- Contract Number [RANL]
    IMKEY,             -- Real Estate Key [IMKEY]
    REBZT,             -- Follow-On Doc. Type [REBZT]
    REBZG,             -- Invoice Ref. [REBZG]
    REBZJ,             -- Fiscal Year [REBZJ]
    REBZZ,             -- Item [REBZZ]
    KOSTL,             -- Cost Center [KOSTL]
    XINVE,             -- Invest.ID [XINVE]
    VBEL2,             -- Sales Document [VBELN_VA]
    VPOS2,             -- Number [NUM06]
    ZEKKN,             -- Account Assgmt No. [DZEKKN]
    POSN2,             -- Item [POSNR_VA]
    ETEN2,             -- Schedule Line [ETENR]
    FISTL,             -- Funds Center [FISTL]
    GEBER,             -- Fund [BP_GEBER]
    DABRZ,             -- Reference date [DABRBEZ]
    KKBER,             -- Cred.Contr.Area [KKBER]
    EMPFB,             -- Payer [EMPFB]
    PRCTR,             -- Profit Center [PRCTR]
    XREF1,             -- Reference Key 1 [XREF1]
    XREF2,             -- Reference Key 2 [XREF2]
    XREF3,             -- Reference Key 3 [XREF3]
    ZINKZ,             -- Interest Block [DZINKZ]
    DTWS1,             -- Instruct. Key 1 [DTAT16]
    DTWS2,             -- Instruct. Key 2 [DTAT17]
    DTWS3,             -- Instruct. key 3 [DTAT18]
    DTWS4,             -- Instruct. key 4 [DTAT19]
    PAYT_RSN,          -- Payment Reason [FARP_PAYT_RSN]
    MANSP,             -- Dunn. Block [MANSP]
    KIDNO,             -- Payment Ref. [KIDNO]
    XCPDD,             -- Individ. Set [XCPDD]
    VERTT,             -- Contract Type [RANTYP]
    VBEWA,             -- Flow Type [SBEWART]
    AGZEI,             -- Clearing Item [AGZEI]
    PSWSL,             -- G/L Currency [PSWSL]
    PSWBT,             -- G/L Amount [PSWBT]
    PSSKT,             -- G/L Discount [PSSKT]
    XPYAM,             -- Predef.Pmnt Amt [XPYAM]
    GDIFF,             -- Exch.Rate Diff. [GDIFF]
    GDIF2,             -- Exch.Rate Diff. [GDIFF]
    GDIF3,             -- Exch.Rate Diff. [GDIFF]
    BUPLA,             -- Business place [BUPLA]
    SECCO,             -- Section Code [SECCO]
    XSAEN,             -- Unconfirm.Chnge [XSAEN]
    KBLNR,             -- Earmarked funds [KBLNR_FI]
    KBLPOS,            -- Document Item [KBLPOS]
    CESSION_KZ,        -- AR Pledging Ind [CESSION_KZ]
    KEYNO,             -- Key Number [PRQ_KEYNO]
    PAMTF,             -- PC Amount [PRQ_AMTFC]
    ORIGIN,            -- Origin [FIBL_ORIGIN]
    PENLC1,            -- Penalty Chge LC [PENALTY1]
    PENLC2,            -- Pen.Charge LC2 [PENALTY2]
    PENLC3,            -- Pen.Charge LC3 [PENALTY3]
    PENFC,             -- Penalty Charge [PENALTY]
    PENDAYS,           -- Days in Arrears [PDAYS]
    PPRCT,             -- Partner PC [PPRCTR]
    GRANT_NBR,         -- Grant [GM_GRANT_NBR]
    FKBER,             -- Functional Area [FKBER]
    SNAME1,            -- Name [NAME1_GP]
    SORT01,            -- City [ORT01_GP]
    SLAND1,            -- Country/Region Key [LAND1_GP]
    SAMNR,             -- Collect.Inv. [SAMNR]
    MABER,             -- Dunning Area [MABER]
    BUDGET_PD,         -- Budget Period [FM_BUDGET_PERIOD]
    SNAME2,            -- Name 2 [NAME2_GP]
    SNAME3,            -- Name 3 [NAME3_GP]
    SNAME4,            -- Name 4 [NAME4_GP]
    SSTRAS,            -- Street [STRAS_GP]
    SSTRS2,            -- Street [STRAS_GP]
    SPSTLZ,            -- Postal Code [PSTLZ_BAS]
    SID,               -- Payer of a Payment [SENDER_ID]
    RSTGR,             -- Reason Code [RSTGR]
    J_1TPBUPL,         -- Branch Code [BCODE]
    EXTACCOUNT,        -- External Account [TPM_EXT_ACCOUNT]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR, BUKRS, BELNR, GJAHR, BUZEI)
);

Learn More