VBSEGA

Transparent Table Application Table
82 Fields 4 CDS Views

Belegsegment Belegvorerfassung - Datenbank für Anlagen -

VBSEGA is an SAP database table in S/4HANA. Belegsegment Belegvorerfassung - Datenbank für Anlagen -. It contains 82 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FISVD_DOCNR_GAP_PARK_AA view inner Asset Park Document Data
I_ParkedAssetItem view_entity from BASIC Parked Asset Item
I_ParkedOplAcctgDocAssetItem view_entity from BASIC Parked Asset Item
P_VBSEGA_COM view from BASIC Private view on VBSEGA

Fields (82)

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
shkzg shkzg Debit/Credit
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
hwbas hwbas LC Base
fwbas fwbas Base Amount
mwart mwart Tax Type
kursr kursr Hedged Ex.Rt
zuonr dzuonr Assignment
sgtxt sgtxt Text
anln1 anln1 Asset
anln2 anln2 Sub-number
anbwa anbwa Ast Transaction Type
bzdat bzdat Asset Val. Date
xskrl xskrl W/o CashDsc.
hkont hkont G/L Acct
hzuon hzuon Sp.G/L Assgt
menge menge_d Quantity
meins meins Base Unit
txjcd txjcd Tax Jur.
ps_psp_pnr ps_psp_pnr WBS Element
aufnr aufnr Order
fipos fipos Commitment item
kblnr kblnr_fi Earmarked funds
kblpos kblpos Document Item
fistl fistl Funds Center
geber bp_geber Fund
recid recid Inv.issue rule
gricd j_1agicd_d Activity Code
grirg regio Region
gityp j_1adtyp_d Distr. Type
matnr matnr Material
kostl kostl Cost Center
kdauf kdauf Sales Order
kdein kdein SOrder schedule
kdpos kdpos Sales Ord. Item
pernr pernr_d Personnel No.
nplnr nplnr Network
vornr vornr Activity
werks werks_d Plant
paobjnr rkeobjnr Profit. segment
kstrg kstrg Cost Object
egrup jv_egroup Equity group
vname jv_name Joint venture
imkey imkey Real Estate Key
vptnr jv_part Partner
pprctr pprctr Partner PC
erlkz kblerlkz Item Completed
fkber fkber Functional Area
lstar lstar Activity Type
kontt kontt_fi Acct Assmt Cat.
kontl kontl_fi Acct assignment
bupla bupla Business place
secco secco Section Code
xref2 xref2 Reference Key 2
xref3 xref3 Reference Key 3
gsber gsber Business Area
prctr prctr Profit Center
segment fb_segment Segment
psegment fb_psegment Partner Segment
xnegp xnegp Negative Postg
grant_nbr gm_grant_nbr Grant
pgrant_nbr gm_grant_partner Partner Grant
pgeber fm_pfund Partner Fund
measure fm_measure Funded Program
budget_pd fm_budget_period Budget Period
pbudget_pd fm_pbudget_period Par. BudPer

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 - Datenbank für Anlagen -
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBSEGA (
    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]
    SHKZG,        -- Debit/Credit [shkzg]
    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]
    HWBAS,        -- LC Base [hwbas]
    FWBAS,        -- Base Amount [fwbas]
    MWART,        -- Tax Type [mwart]
    KURSR,        -- Hedged Ex.Rt [kursr]
    ZUONR,        -- Assignment [dzuonr]
    SGTXT,        -- Text [sgtxt]
    ANLN1,        -- Asset [anln1]
    ANLN2,        -- Sub-number [anln2]
    ANBWA,        -- Ast Transaction Type [anbwa]
    BZDAT,        -- Asset Val. Date [bzdat]
    XSKRL,        -- W/o CashDsc. [xskrl]
    HKONT,        -- G/L Acct [hkont]
    HZUON,        -- Sp.G/L Assgt [hzuon]
    MENGE,        -- Quantity [menge_d]
    MEINS,        -- Base Unit [meins]
    TXJCD,        -- Tax Jur. [txjcd]
    PS_PSP_PNR,   -- WBS Element [ps_psp_pnr]
    AUFNR,        -- Order [aufnr]
    FIPOS,        -- Commitment item [fipos]
    KBLNR,        -- Earmarked funds [kblnr_fi]
    KBLPOS,       -- Document Item [kblpos]
    FISTL,        -- Funds Center [fistl]
    GEBER,        -- Fund [bp_geber]
    RECID,        -- Inv.issue rule [recid]
    GRICD,        -- Activity Code [j_1agicd_d]
    GRIRG,        -- Region [regio]
    GITYP,        -- Distr. Type [j_1adtyp_d]
    MATNR,        -- Material [matnr]
    KOSTL,        -- Cost Center [kostl]
    KDAUF,        -- Sales Order [kdauf]
    KDEIN,        -- SOrder schedule [kdein]
    KDPOS,        -- Sales Ord. Item [kdpos]
    PERNR,        -- Personnel No. [pernr_d]
    NPLNR,        -- Network [nplnr]
    VORNR,        -- Activity [vornr]
    WERKS,        -- Plant [werks_d]
    PAOBJNR,      -- Profit. segment [rkeobjnr]
    KSTRG,        -- Cost Object [kstrg]
    EGRUP,        -- Equity group [jv_egroup]
    VNAME,        -- Joint venture [jv_name]
    IMKEY,        -- Real Estate Key [imkey]
    VPTNR,        -- Partner [jv_part]
    PPRCTR,       -- Partner PC [pprctr]
    ERLKZ,        -- Item Completed [kblerlkz]
    FKBER,        -- Functional Area [fkber]
    LSTAR,        -- Activity Type [lstar]
    KONTT,        -- Acct Assmt Cat. [kontt_fi]
    KONTL,        -- Acct assignment [kontl_fi]
    BUPLA,        -- Business place [bupla]
    SECCO,        -- Section Code [secco]
    XREF2,        -- Reference Key 2 [xref2]
    XREF3,        -- Reference Key 3 [xref3]
    GSBER,        -- Business Area [gsber]
    PRCTR,        -- Profit Center [prctr]
    SEGMENT,      -- Segment [fb_segment]
    PSEGMENT,     -- Partner Segment [fb_psegment]
    XNEGP,        -- Negative Postg [xnegp]
    GRANT_NBR,    -- Grant [gm_grant_nbr]
    PGRANT_NBR,   -- Partner Grant [gm_grant_partner]
    PGEBER,       -- Partner Fund [fm_pfund]
    MEASURE,      -- Funded Program [fm_measure]
    BUDGET_PD,    -- Budget Period [fm_budget_period]
    PBUDGET_PD,   -- Par. BudPer [fm_pbudget_period]
    PRIMARY KEY (MANDT, AUSBK, BELNR, GJAHR, BZKEY)
);

Learn More