VDBEPI

Transparent Table Application Table
156 Fields 2 CDS Views

Posted line items for document header

VDBEPI is an SAP database table in S/4HANA. Posted line items for document header. It contains 156 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LoanContrActlDocItm view from BASIC Actual Document Item for Loan Contract
I_LoanContrActlDocItmData view from BASIC Actual Document Item for Loan Contract

Fields (156)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY rbelkpfd rbelkpfd Doc no. Header
KEY rposnr nvorgang Activity no.
sbewart sbewart Flow Type
srefbew srefbew Refer.flow
sbewziti sbewziti Flow Category
bnwhr bnwhr Nominal amnt
snwhr snwhr Nominal currency
bbwhr bbwhr Amount in PC
sbwhr sbwhr Position Currency
bcwhr bcwhr Settlement Amount
scwhr scwhr Settlement Currency
bhwhr bhwhr Amount in LC
pkkurs pkkurs Purchase Price
pruck pruck Repayment rate
kurs1 vvkursf Exchange rate
kurs2 vvkursf Exchange rate
dvalut dvalut Calculat. date
dfaell dfaell Due Date
ddispo ddispo Payment date
dbestand dbestand Position Value Date
dbervon dbervon CalculationFrom
umskz umskz Special G/L Ind
kostl kostl Cost Center
sspesen sspesen Expen.key
ssolhab vvssolhab Debit/Credit
rsoll rsoll Debit account
rhaben rhaben Credit a/c
rzksoll rzksoll Debit.inter.act
rzkhabe rzkhabe Cred.inter.acct
sbslsoll bschl Posting Key
sbslzkso bschl Posting Key
sbslzkha bschl Posting Key
shslhaben bschl Posting Key
buchtxt sgtxt Text
rbankk rbankk Int. bank acct
sfdlev fdlev Planning Level
jfdupd jfdupd CMF flag
jonlaen jonlaen Flow fixing
jzinsbas jzinsbas Interest base
jzinszpt jzinszpt Interest date
pkond pkond Percentage Rate
bbasis bbasis Base Amount
ssortzit ssortzit Sort indicator
swoher swoher Source of flow
kunnr kunnr Customer
bvtyp bvtyp Part.bank type
zlsch dzlsch Pymt Meth.
maber maber Dunning Area
zahls dzahls Payment Block
rpartnr bp_partnr_new BusPartner
srolext dummy_3 Dummy
jeinbehalt jeinbehalt Withhold.Disb.
jfirueck jfirueck FI Confirmation
mwskz mwskz Tax Code
mwart mwart Tax Type
dberbis dberbis Calculation To
atage vvatage Number of Days
abastage abastage No. base days
szbmeth szbmeth Int.calc.method
jstock vvjstock Relev.to PRF
sbust vvsbust Posting Control
dtrans vvdtrans Flow date
ttrans vvttrans Time trans.
ntrans vvntrans Consec.tr.
gsber gsber Business Area
skoart skoart Condition Type
sexclvon vvsexclvon Exclusive Start
sultvon vvsultvon Mth-End StartDt
sinclbis vvsinclbis Incl. End Date
sultbis vvsultbis Month-End EndDt
sincl vvsincl Inclusive Ind.
dverrech vvdverrech Settlem. date
dpkond vvdpkond Perc Fixing Dte
sbucha vvsbucha A/D acct postng
zinkz tb_zinkz Interest Block
svult vvsvult Mon-End Val.Dte
jsofverr jsofverr Immed.settlemnt
sinclverr vvsinclver Incl. Clrg Date
sultverr vvsultverr MnthEndClearing
srefziti vvsrefziti RefFlwCat-A/D
stgbasis vvstgbasis Base Days Meth.
stgmeth vvstgmeth Daily Method
sbasis vvsbasis Base reference
sgtxt sgtxt Text
sberfima sbewfima Calc. Category
svorgkz vvsvorgkz Activity ID
mansp mansp Dunn. Block
dguel_kp dguel_kp Item Eff. From
nstufe nstufe Level Number
dbperiod vvdbperiod Period start
spaexcl tfmspaexcl Exclusive Start
spault tfmspault MonEndIndStPer
deperiod vvdeperiod Period end
speincl tfmspeincl InclusiveEndPer
speult tfmspeult MthEndPerEnd
sstckkz sstckkz Acc.int.meth.
norder norder Order Number
rkont rkont Quota
dausz vvdausz Lead withh.amts
ssolist ssolist Act.princip.
rdarnehm rdarnehm_new Borrower
bkond bkond Condition Amnt
sberech sberech Grace int.meth
bkarzins tfmbkazins Interest
btitalk tfmbtikalk Imp_Ann_Rep_Amount
rerf rerf Entered By
derf derf First Enterd On
terf terf Time
reher reher Source.In.Entry
rbear rbear Last Changed By
dbear dbear Last Edited On
tbear tbear Last Edited At
rbher rbher Editing Source
hdn_kunnr hdn_kunnr MainBorrCust.
szart tb_szart Pmnt Transact.
ruzbel belnr_d Document Number
rebzj rebzj Fiscal Year
rebzg rebzg Invoice Ref.
rebzz rebzz Item
s_ssdref vvs_ssdref RefFlwCat_BNL
pwkurs pwkurs Security price
dzfest tb_dzfest Int.Fixing Date
xpore prq_xpore Individual Payt
spayrq tb_spayrqk Payment Request
prkey prq_keyno Key Number
hbkid hbkid House Bank
hktid hktid Account ID
vorgtyp vorgtyp_lo Activity Cat.
acenv acenv_lo Source in post.area
ssign tb_ssign Direction
sprsng tb_sprsngk Individual Pmnt
uzawe uzawe Pmnt Meth. Sup.
sprgrd tb_sprgrd Group Determ.
scspay tb_scspay Same Direction
zwels dzwels Payment Methods
paygr paygr Grouping
jexpozins tfm_sintcomp Exponential
srevalexcl vvsrevalexcl Price gains w/o def.
sround tfm_sround Rounding Cat.
skalidwt tfmskalidwt Int. Calendar
jverf jverf Drawings
ppayment tfm_ppayment Payment Rate
ammrhyzv tfm_ammrhyzv Int.Sttlm.Freq
lc_capitals tb_lc_capitals Eff.CapAmntStat
lc_disburse tb_lc_disburse Eff.Disb.Status
dfaell_old_ext tb_extens_dfaell_old Old Due Date
ddispo_old_ext tb_extens_ddispo_old Old Payt Dt
rbo_ext rbo Bus.operat. no.
sbewegrp2 tb_flow_rec_grp Flow Rec.Grp IP
susp_reason_type tb_suspreason Overpayment Reason
bill_number tb_bill_number Bill Number
bill_due_date tb_bill_due_date Due Date
mndid sepa_mndid Mandate Ref.
sbewegrp sbewegrp Flow Group

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.

-- Posted line items for document header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VDBEPI (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    RBELKPFD,          -- Doc no. Header [rbelkpfd]
    RPOSNR,            -- Activity no. [nvorgang]
    SBEWART,           -- Flow Type [sbewart]
    SREFBEW,           -- Refer.flow [srefbew]
    SBEWZITI,          -- Flow Category [sbewziti]
    BNWHR,             -- Nominal amnt [bnwhr]
    SNWHR,             -- Nominal currency [snwhr]
    BBWHR,             -- Amount in PC [bbwhr]
    SBWHR,             -- Position Currency [sbwhr]
    BCWHR,             -- Settlement Amount [bcwhr]
    SCWHR,             -- Settlement Currency [scwhr]
    BHWHR,             -- Amount in LC [bhwhr]
    PKKURS,            -- Purchase Price [pkkurs]
    PRUCK,             -- Repayment rate [pruck]
    KURS1,             -- Exchange rate [vvkursf]
    KURS2,             -- Exchange rate [vvkursf]
    DVALUT,            -- Calculat. date [dvalut]
    DFAELL,            -- Due Date [dfaell]
    DDISPO,            -- Payment date [ddispo]
    DBESTAND,          -- Position Value Date [dbestand]
    DBERVON,           -- CalculationFrom [dbervon]
    UMSKZ,             -- Special G/L Ind [umskz]
    KOSTL,             -- Cost Center [kostl]
    SSPESEN,           -- Expen.key [sspesen]
    SSOLHAB,           -- Debit/Credit [vvssolhab]
    RSOLL,             -- Debit account [rsoll]
    RHABEN,            -- Credit a/c [rhaben]
    RZKSOLL,           -- Debit.inter.act [rzksoll]
    RZKHABE,           -- Cred.inter.acct [rzkhabe]
    SBSLSOLL,          -- Posting Key [bschl]
    SBSLZKSO,          -- Posting Key [bschl]
    SBSLZKHA,          -- Posting Key [bschl]
    SHSLHABEN,         -- Posting Key [bschl]
    BUCHTXT,           -- Text [sgtxt]
    RBANKK,            -- Int. bank acct [rbankk]
    SFDLEV,            -- Planning Level [fdlev]
    JFDUPD,            -- CMF flag [jfdupd]
    JONLAEN,           -- Flow fixing [jonlaen]
    JZINSBAS,          -- Interest base [jzinsbas]
    JZINSZPT,          -- Interest date [jzinszpt]
    PKOND,             -- Percentage Rate [pkond]
    BBASIS,            -- Base Amount [bbasis]
    SSORTZIT,          -- Sort indicator [ssortzit]
    SWOHER,            -- Source of flow [swoher]
    KUNNR,             -- Customer [kunnr]
    BVTYP,             -- Part.bank type [bvtyp]
    ZLSCH,             -- Pymt Meth. [dzlsch]
    MABER,             -- Dunning Area [maber]
    ZAHLS,             -- Payment Block [dzahls]
    RPARTNR,           -- BusPartner [bp_partnr_new]
    SROLEXT,           -- Dummy [dummy_3]
    JEINBEHALT,        -- Withhold.Disb. [jeinbehalt]
    JFIRUECK,          -- FI Confirmation [jfirueck]
    MWSKZ,             -- Tax Code [mwskz]
    MWART,             -- Tax Type [mwart]
    DBERBIS,           -- Calculation To [dberbis]
    ATAGE,             -- Number of Days [vvatage]
    ABASTAGE,          -- No. base days [abastage]
    SZBMETH,           -- Int.calc.method [szbmeth]
    JSTOCK,            -- Relev.to PRF [vvjstock]
    SBUST,             -- Posting Control [vvsbust]
    DTRANS,            -- Flow date [vvdtrans]
    TTRANS,            -- Time trans. [vvttrans]
    NTRANS,            -- Consec.tr. [vvntrans]
    GSBER,             -- Business Area [gsber]
    SKOART,            -- Condition Type [skoart]
    SEXCLVON,          -- Exclusive Start [vvsexclvon]
    SULTVON,           -- Mth-End StartDt [vvsultvon]
    SINCLBIS,          -- Incl. End Date [vvsinclbis]
    SULTBIS,           -- Month-End EndDt [vvsultbis]
    SINCL,             -- Inclusive Ind. [vvsincl]
    DVERRECH,          -- Settlem. date [vvdverrech]
    DPKOND,            -- Perc Fixing Dte [vvdpkond]
    SBUCHA,            -- A/D acct postng [vvsbucha]
    ZINKZ,             -- Interest Block [tb_zinkz]
    SVULT,             -- Mon-End Val.Dte [vvsvult]
    JSOFVERR,          -- Immed.settlemnt [jsofverr]
    SINCLVERR,         -- Incl. Clrg Date [vvsinclver]
    SULTVERR,          -- MnthEndClearing [vvsultverr]
    SREFZITI,          -- RefFlwCat-A/D [vvsrefziti]
    STGBASIS,          -- Base Days Meth. [vvstgbasis]
    STGMETH,           -- Daily Method [vvstgmeth]
    SBASIS,            -- Base reference [vvsbasis]
    SGTXT,             -- Text [sgtxt]
    SBERFIMA,          -- Calc. Category [sbewfima]
    SVORGKZ,           -- Activity ID [vvsvorgkz]
    MANSP,             -- Dunn. Block [mansp]
    DGUEL_KP,          -- Item Eff. From [dguel_kp]
    NSTUFE,            -- Level Number [nstufe]
    DBPERIOD,          -- Period start [vvdbperiod]
    SPAEXCL,           -- Exclusive Start [tfmspaexcl]
    SPAULT,            -- MonEndIndStPer [tfmspault]
    DEPERIOD,          -- Period end [vvdeperiod]
    SPEINCL,           -- InclusiveEndPer [tfmspeincl]
    SPEULT,            -- MthEndPerEnd [tfmspeult]
    SSTCKKZ,           -- Acc.int.meth. [sstckkz]
    NORDER,            -- Order Number [norder]
    RKONT,             -- Quota [rkont]
    DAUSZ,             -- Lead withh.amts [vvdausz]
    SSOLIST,           -- Act.princip. [ssolist]
    RDARNEHM,          -- Borrower [rdarnehm_new]
    BKOND,             -- Condition Amnt [bkond]
    SBERECH,           -- Grace int.meth [sberech]
    BKARZINS,          -- Interest [tfmbkazins]
    BTITALK,           -- Imp_Ann_Rep_Amount [tfmbtikalk]
    RERF,              -- Entered By [rerf]
    DERF,              -- First Enterd On [derf]
    TERF,              -- Time [terf]
    REHER,             -- Source.In.Entry [reher]
    RBEAR,             -- Last Changed By [rbear]
    DBEAR,             -- Last Edited On [dbear]
    TBEAR,             -- Last Edited At [tbear]
    RBHER,             -- Editing Source [rbher]
    HDN_KUNNR,         -- MainBorrCust. [hdn_kunnr]
    SZART,             -- Pmnt Transact. [tb_szart]
    RUZBEL,            -- Document Number [belnr_d]
    REBZJ,             -- Fiscal Year [rebzj]
    REBZG,             -- Invoice Ref. [rebzg]
    REBZZ,             -- Item [rebzz]
    S_SSDREF,          -- RefFlwCat_BNL [vvs_ssdref]
    PWKURS,            -- Security price [pwkurs]
    DZFEST,            -- Int.Fixing Date [tb_dzfest]
    XPORE,             -- Individual Payt [prq_xpore]
    SPAYRQ,            -- Payment Request [tb_spayrqk]
    PRKEY,             -- Key Number [prq_keyno]
    HBKID,             -- House Bank [hbkid]
    HKTID,             -- Account ID [hktid]
    VORGTYP,           -- Activity Cat. [vorgtyp_lo]
    ACENV,             -- Source in post.area [acenv_lo]
    SSIGN,             -- Direction [tb_ssign]
    SPRSNG,            -- Individual Pmnt [tb_sprsngk]
    UZAWE,             -- Pmnt Meth. Sup. [uzawe]
    SPRGRD,            -- Group Determ. [tb_sprgrd]
    SCSPAY,            -- Same Direction [tb_scspay]
    ZWELS,             -- Payment Methods [dzwels]
    PAYGR,             -- Grouping [paygr]
    JEXPOZINS,         -- Exponential [tfm_sintcomp]
    SREVALEXCL,        -- Price gains w/o def. [vvsrevalexcl]
    SROUND,            -- Rounding Cat. [tfm_sround]
    SKALIDWT,          -- Int. Calendar [tfmskalidwt]
    JVERF,             -- Drawings [jverf]
    PPAYMENT,          -- Payment Rate [tfm_ppayment]
    AMMRHYZV,          -- Int.Sttlm.Freq [tfm_ammrhyzv]
    LC_CAPITALS,       -- Eff.CapAmntStat [tb_lc_capitals]
    LC_DISBURSE,       -- Eff.Disb.Status [tb_lc_disburse]
    DFAELL_OLD_EXT,    -- Old Due Date [tb_extens_dfaell_old]
    DDISPO_OLD_EXT,    -- Old Payt Dt [tb_extens_ddispo_old]
    RBO_EXT,           -- Bus.operat. no. [rbo]
    SBEWEGRP2,         -- Flow Rec.Grp IP [tb_flow_rec_grp]
    SUSP_REASON_TYPE,  -- Overpayment Reason [tb_suspreason]
    BILL_NUMBER,       -- Bill Number [tb_bill_number]
    BILL_DUE_DATE,     -- Due Date [tb_bill_due_date]
    MNDID,             -- Mandate Ref. [sepa_mndid]
    SBEWEGRP,          -- Flow Group [sbewegrp]
    PRIMARY KEY (MANDT, BUKRS, RBELKPFD, RPOSNR)
);

Learn More