VBSEGD

Transparent Table Application Table
133 Fields 4 CDS Views

Belegsegment Belegvorerfassung Debitoren

VBSEGD is an SAP database table in S/4HANA. Belegsegment Belegvorerfassung Debitoren. It contains 133 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FGL_LIB_P_DOC_ITEM view union_all Parked Items: Document Item
FISVD_DOCNR_GAP_PARK_CUSTOMER view inner Customer Park Document Data
I_ParkedOplAcctgDocRblsItem view_entity from BASIC Parked Accounts Receivable Item
I_ParkedReceivablesItem view from BASIC Parked Receivables Item

Fields (133)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ausbk ausbk Source CoCode
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY bzkey buzei Item
bukrs bukrs Company Code
buzei buzei Item
bschl bschl Posting Key
umskz umskz Special G/L Ind
umsks umsks Transact.Type
shkzg shkzg Debit/Credit
gsber gsber Business Area
pargb pargb Trdg Part.BA
tax_country fot_tax_country Tax Ctry/Reg.
mwskz mwskz Tax Code
txdat txdat Tax Date
txdat_from fot_txdat_from Tax Rate Valid-From
dmbtr dmbtr Amount in LC
dmbe2 dmbe2 LC2 Amount
dmbe3 dmbe3 LC3 Amount
wrbtr wrbtr Amount
hwmet hwmet Calculation Method
mwsts mwsts LC Tax
mwst2 mwst2 LC2 Tax
mwst3 mwst3 LC3 Tax
wmwst wmwst Tax Amount
hwbas hwbas LC Base
fwbas fwbas Base Amount
mwart mwart Tax Type
kursr kursr Hedged Ex.Rt
gbetr gbetr Hedged
valut valut Value date
zuonr dzuonr Assignment
sgtxt sgtxt Text
zinkz dzinkz Interest Block
fdlev fdlev Planning Level
fdgrp fdgrp Planning group
fdwbt fdwbt Planned Amount
fdtag fdtag Planning Date
geber bp_geber Fund
fistl fistl Funds Center
vname jv_name Joint venture
egrup jv_egroup Equity group
btype jv_bilind Billing ind.
xumsw xumsw Sales-Related
xcpdd xcpdd Individ. Set
xzemp xzemp Payee in doc.
hkont hkont G/L Acct
kunnr kunnr Customer
filkd filkd Branch
hzuon hzuon Sp.G/L Assgt
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
xskfb xskfb Indicator: Calculate Amounts Qualifying for Cash Discount?
skfbt skfbt CD Base
sknto sknto Discount Amt
wskto wskto CD Amount
zlsch schzw_bseg Payt Method
zlspr dzlspr Pmnt block
uzawe uzawe Pmnt Meth. Sup.
hbkid hbkid House Bank
bvtyp bvtyp Part.bank type
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
diekz diekz Service Ind.
vrskz vrskz Insurance Ind.
vrsdt vrsdt Insurance Date
blnbt blnbt Preference Amt
blnkz blnkz Subs.ind.
blnpz blnpz Pref. % Rate
mschl mschl Dunning key
mansp mansp Dunn. Block
maber maber Dunning Area
stceg stceg VAT Reg. No.
xhkom xhkom Manual G/L Acct
vertt rantyp Contract Type
vertn ranl Contract Number
vbewa sbewart Flow Type
xegdr xegdr EU Triang. Deal
fipos fipos Commitment item
swaer waers Currency
madat madat Last Dunned
manst mahns_d Dunning Level
samnr samnr Collect.Inv.
anfbn anfbn BoE Payt Req.
anfbj anfbj Fisc. Year
anfbu anfbu Company Code
anfae anfae Return Bef.
egmld egmld_bsez Reporting C/R
xegmd xegmd EU Reporting Country/Region Deleted
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
xzanf xzanf Payment Request
xfdis xfdis CM Activated
rstgr rstgr Reason Code
kkber kkber Cred.Contr.Area
xref3 xref3 Reference Key 3
dtws1 dtat16 Instruct. Key 1
dtws2 dtat17 Instruct. Key 2
dtws3 dtat18 Instruct. key 3
dtws4 dtat19 Instruct. key 4
empfb empfb Payer
kidno kidno Payment Ref.
idxsp j_1aindxsp Inflation Index
pycur pycur Paymnt Crcy
pyamt pyamt Pt Crcy Amt
bupla bupla Business place
secco secco Section Code
grant_nbr gm_grant_nbr Grant
fkber fkber Functional Area
gmvkz fm_gmvkz Execution
srtype fm_srtype Addit.Receivab.
anbwa anbwa Ast Transaction Type
xnegp xnegp Negative Postg
kblnr kblnr_fi Earmarked funds
kblpos kblpos Document Item
erlkz kblerlkz Item Completed
hktid hktid Account ID
bewar rmvct Transact. Type
budget_pd fm_budget_period Budget Period
netdt netdt Due On
sk1dt sk1dt Cash Discount 1
sk2dt sk2dt Cash Discount 2
payt_rsn farp_payt_rsn Payment Reason

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.

-- Belegsegment Belegvorerfassung Debitoren
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBSEGD (
    MANDT,        -- Client [mandt]
    AUSBK,        -- Source CoCode [ausbk]
    BELNR,        -- Document Number [belnr_d]
    GJAHR,        -- Fiscal Year [gjahr]
    BZKEY,        -- Item [buzei]
    BUKRS,        -- Company Code [bukrs]
    BUZEI,        -- Item [buzei]
    BSCHL,        -- Posting Key [bschl]
    UMSKZ,        -- Special G/L Ind [umskz]
    UMSKS,        -- Transact.Type [umsks]
    SHKZG,        -- Debit/Credit [shkzg]
    GSBER,        -- Business Area [gsber]
    PARGB,        -- Trdg Part.BA [pargb]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [fot_tax_country]
    MWSKZ,        -- Tax Code [mwskz]
    TXDAT,        -- Tax Date [txdat]
    TXDAT_FROM,   -- Tax Rate Valid-From [fot_txdat_from]
    DMBTR,        -- Amount in LC [dmbtr]
    DMBE2,        -- LC2 Amount [dmbe2]
    DMBE3,        -- LC3 Amount [dmbe3]
    WRBTR,        -- Amount [wrbtr]
    HWMET,        -- Calculation Method [hwmet]
    MWSTS,        -- LC Tax [mwsts]
    MWST2,        -- LC2 Tax [mwst2]
    MWST3,        -- LC3 Tax [mwst3]
    WMWST,        -- Tax Amount [wmwst]
    HWBAS,        -- LC Base [hwbas]
    FWBAS,        -- Base Amount [fwbas]
    MWART,        -- Tax Type [mwart]
    KURSR,        -- Hedged Ex.Rt [kursr]
    GBETR,        -- Hedged [gbetr]
    VALUT,        -- Value date [valut]
    ZUONR,        -- Assignment [dzuonr]
    SGTXT,        -- Text [sgtxt]
    ZINKZ,        -- Interest Block [dzinkz]
    FDLEV,        -- Planning Level [fdlev]
    FDGRP,        -- Planning group [fdgrp]
    FDWBT,        -- Planned Amount [fdwbt]
    FDTAG,        -- Planning Date [fdtag]
    GEBER,        -- Fund [bp_geber]
    FISTL,        -- Funds Center [fistl]
    VNAME,        -- Joint venture [jv_name]
    EGRUP,        -- Equity group [jv_egroup]
    BTYPE,        -- Billing ind. [jv_bilind]
    XUMSW,        -- Sales-Related [xumsw]
    XCPDD,        -- Individ. Set [xcpdd]
    XZEMP,        -- Payee in doc. [xzemp]
    HKONT,        -- G/L Acct [hkont]
    KUNNR,        -- Customer [kunnr]
    FILKD,        -- Branch [filkd]
    HZUON,        -- Sp.G/L Assgt [hzuon]
    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]
    XSKFB,        -- Indicator: Calculate Amounts Qualifying for Cash Discount? [xskfb]
    SKFBT,        -- CD Base [skfbt]
    SKNTO,        -- Discount Amt [sknto]
    WSKTO,        -- CD Amount [wskto]
    ZLSCH,        -- Payt Method [schzw_bseg]
    ZLSPR,        -- Pmnt block [dzlspr]
    UZAWE,        -- Pmnt Meth. Sup. [uzawe]
    HBKID,        -- House Bank [hbkid]
    BVTYP,        -- Part.bank type [bvtyp]
    REBZG,        -- Invoice Ref. [rebzg]
    REBZJ,        -- Fiscal Year [rebzj]
    REBZZ,        -- Item [rebzz]
    REBZT,        -- Follow-On Doc. Type [rebzt]
    LZBKZ,        -- SCB Ind. [lzbkz]
    LANDL,        -- Supply C/R [landl]
    DIEKZ,        -- Service Ind. [diekz]
    VRSKZ,        -- Insurance Ind. [vrskz]
    VRSDT,        -- Insurance Date [vrsdt]
    BLNBT,        -- Preference Amt [blnbt]
    BLNKZ,        -- Subs.ind. [blnkz]
    BLNPZ,        -- Pref. % Rate [blnpz]
    MSCHL,        -- Dunning key [mschl]
    MANSP,        -- Dunn. Block [mansp]
    MABER,        -- Dunning Area [maber]
    STCEG,        -- VAT Reg. No. [stceg]
    XHKOM,        -- Manual G/L Acct [xhkom]
    VERTT,        -- Contract Type [rantyp]
    VERTN,        -- Contract Number [ranl]
    VBEWA,        -- Flow Type [sbewart]
    XEGDR,        -- EU Triang. Deal [xegdr]
    FIPOS,        -- Commitment item [fipos]
    SWAER,        -- Currency [waers]
    MADAT,        -- Last Dunned [madat]
    MANST,        -- Dunning Level [mahns_d]
    SAMNR,        -- Collect.Inv. [samnr]
    ANFBN,        -- BoE Payt Req. [anfbn]
    ANFBJ,        -- Fisc. Year [anfbj]
    ANFBU,        -- Company Code [anfbu]
    ANFAE,        -- Return Bef. [anfae]
    EGMLD,        -- Reporting C/R [egmld_bsez]
    XEGMD,        -- EU Reporting Country/Region Deleted [xegmd]
    XREF1,        -- Reference Key 1 [xref1]
    XREF2,        -- Reference Key 2 [xref2]
    XZANF,        -- Payment Request [xzanf]
    XFDIS,        -- CM Activated [xfdis]
    RSTGR,        -- Reason Code [rstgr]
    KKBER,        -- Cred.Contr.Area [kkber]
    XREF3,        -- Reference Key 3 [xref3]
    DTWS1,        -- Instruct. Key 1 [dtat16]
    DTWS2,        -- Instruct. Key 2 [dtat17]
    DTWS3,        -- Instruct. key 3 [dtat18]
    DTWS4,        -- Instruct. key 4 [dtat19]
    EMPFB,        -- Payer [empfb]
    KIDNO,        -- Payment Ref. [kidno]
    IDXSP,        -- Inflation Index [j_1aindxsp]
    PYCUR,        -- Paymnt Crcy [pycur]
    PYAMT,        -- Pt Crcy Amt [pyamt]
    BUPLA,        -- Business place [bupla]
    SECCO,        -- Section Code [secco]
    GRANT_NBR,    -- Grant [gm_grant_nbr]
    FKBER,        -- Functional Area [fkber]
    GMVKZ,        -- Execution [fm_gmvkz]
    SRTYPE,       -- Addit.Receivab. [fm_srtype]
    ANBWA,        -- Ast Transaction Type [anbwa]
    XNEGP,        -- Negative Postg [xnegp]
    KBLNR,        -- Earmarked funds [kblnr_fi]
    KBLPOS,       -- Document Item [kblpos]
    ERLKZ,        -- Item Completed [kblerlkz]
    HKTID,        -- Account ID [hktid]
    BEWAR,        -- Transact. Type [rmvct]
    BUDGET_PD,    -- Budget Period [fm_budget_period]
    NETDT,        -- Due On [netdt]
    SK1DT,        -- Cash Discount 1 [sk1dt]
    SK2DT,        -- Cash Discount 2 [sk2dt]
    PAYT_RSN,     -- Payment Reason [farp_payt_rsn]
    PRIMARY KEY (MANDT, AUSBK, BELNR, GJAHR, BZKEY)
);

Learn More