VDBEPI

Transparent Table Application Table
190 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 190 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 (190)

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 DZINKZ 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
remit_info TB_REMIT_INFO Pay. Notes Info
dip_kukey FVD_DIP_KUKEY Short Key (DIP)
dip_esnum FVD_DIP_ESNUM Line Item Number
dip_id TB_DIP_ID ID (Diff. IP)
dip_date TB_DIP_DATE Date (Diff. IP)
flg_ip_cli_notice TB_FLG_IP_CLI_NOTICE Payment created by CLI notice
aavgdays TFM_AAVGDAYS Days AIR
pavginterest TFM_PAVGINTEREST Aver. Int. Rate
javgcap TFM_JAVGCAP Upper Limit
pavgcap TFM_PAVGCAP Upper Limit
javgfloor TFM_JAVGFLOOR Lower Limit
pavgfloor TFM_PAVGFLOOR Lower Limit
pavgspread TFM_PAVGSPREAD Spread
sroundavginterest TFM_SROUNDAVGINTEREST RC of AIR
rounddecavginterest TFM_ROUNDDECAVGINTEREST AIR Round. Dec.
aavgweight TFM_AWEIGHT Weighting of IR
aavgweightsum TFM_AWEIGHTSUM Cumul. Weight
jexpointfactor TFM_JEXPOINTFACTOR Expo Int Factor
flowfactor TFM_FLOWFACTOR Flow Factor
basefactor TFM_BASEFACTOR Base Factor
sfactorreset TFM_SFACTORRESET Reset
pnon_cumulative_rate TFM_NON_CUMULATIVE_RATE Non Cum. Rate
ca_dtrans VVDTRANS Flow date
ca_ttrans VVTTRANS Time trans.
ca_ntrans VVNTRANS Consec.tr.
ca_flg_org TB_FLG_CUST_ORG Original Flow
main_trans FVD_HVORG_KK Main Tr. (G/L)
sub_trans FVD_TVORG_KK Subtrans. (G/L)
bp_main_trans FVD_HVORG_KK_BP Main Tr. (BP)
bp_sub_trans FVD_TVORG_KK_BP Subtrans. (BP)
cust_ext1 TB_CUST_EXT1 Customer Field 1
cust_ext2 TB_CUST_EXT2 Customer Field 2
cust_ext3 TB_CUST_EXT3 Customer Field 3
broundunit TB_BROUNDUNIT_A Rounding Unit

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 [DZINKZ]
    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]
    REMIT_INFO,            -- Pay. Notes Info [TB_REMIT_INFO]
    DIP_KUKEY,             -- Short Key (DIP) [FVD_DIP_KUKEY]
    DIP_ESNUM,             -- Line Item Number [FVD_DIP_ESNUM]
    DIP_ID,                -- ID (Diff. IP) [TB_DIP_ID]
    DIP_DATE,              -- Date (Diff. IP) [TB_DIP_DATE]
    FLG_IP_CLI_NOTICE,     -- Payment created by CLI notice [TB_FLG_IP_CLI_NOTICE]
    AAVGDAYS,              -- Days AIR [TFM_AAVGDAYS]
    PAVGINTEREST,          -- Aver. Int. Rate [TFM_PAVGINTEREST]
    JAVGCAP,               -- Upper Limit [TFM_JAVGCAP]
    PAVGCAP,               -- Upper Limit [TFM_PAVGCAP]
    JAVGFLOOR,             -- Lower Limit [TFM_JAVGFLOOR]
    PAVGFLOOR,             -- Lower Limit [TFM_PAVGFLOOR]
    PAVGSPREAD,            -- Spread [TFM_PAVGSPREAD]
    SROUNDAVGINTEREST,     -- RC of AIR [TFM_SROUNDAVGINTEREST]
    ROUNDDECAVGINTEREST,   -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
    AAVGWEIGHT,            -- Weighting of IR [TFM_AWEIGHT]
    AAVGWEIGHTSUM,         -- Cumul. Weight [TFM_AWEIGHTSUM]
    JEXPOINTFACTOR,        -- Expo Int Factor [TFM_JEXPOINTFACTOR]
    FLOWFACTOR,            -- Flow Factor [TFM_FLOWFACTOR]
    BASEFACTOR,            -- Base Factor [TFM_BASEFACTOR]
    SFACTORRESET,          -- Reset [TFM_SFACTORRESET]
    PNON_CUMULATIVE_RATE,  -- Non Cum. Rate [TFM_NON_CUMULATIVE_RATE]
    CA_DTRANS,             -- Flow date [VVDTRANS]
    CA_TTRANS,             -- Time trans. [VVTTRANS]
    CA_NTRANS,             -- Consec.tr. [VVNTRANS]
    CA_FLG_ORG,            -- Original Flow [TB_FLG_CUST_ORG]
    MAIN_TRANS,            -- Main Tr. (G/L) [FVD_HVORG_KK]
    SUB_TRANS,             -- Subtrans. (G/L) [FVD_TVORG_KK]
    BP_MAIN_TRANS,         -- Main Tr. (BP) [FVD_HVORG_KK_BP]
    BP_SUB_TRANS,          -- Subtrans. (BP) [FVD_TVORG_KK_BP]
    CUST_EXT1,             -- Customer Field 1 [TB_CUST_EXT1]
    CUST_EXT2,             -- Customer Field 2 [TB_CUST_EXT2]
    CUST_EXT3,             -- Customer Field 3 [TB_CUST_EXT3]
    BROUNDUNIT,            -- Rounding Unit [TB_BROUNDUNIT_A]
    PRIMARY KEY (MANDT, BUKRS, RBELKPFD, RPOSNR)
);

Learn More