VBSEGS
Belegsegment Belegvorerfassung - Datenbank für Sachkonten
VBSEGS is an SAP database table in S/4HANA. Belegsegment Belegvorerfassung - Datenbank für Sachkonten. It contains 147 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Facvd_Wf_Set_Amount_Doc | view | left_outer | set amount to document | |
| FCLM_VBSEG_PRJK | view | from | VBSEG Projection | |
| FGL_LIB_P_DOC_ITEM | view | from | Parked Items: Document Item | |
| FISVD_DOCNR_GAP_PARK_GL | view | inner | G/L Park Document Data | |
| I_ParkedMCAJournalEntry | view | from | BASIC | Parked MCA Journal Entry details |
| I_ParkedOplAcctgDocGLItem | view_entity | from | BASIC | Parked General Ledger Item |
| P_VBSEGS_COM | view | from | BASIC |
Fields (147)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||||
| hwbas | hwbas | LC Base | ||||
| fwbas | fwbas | Base Amount | ||||
| mwart | mwart | Tax Type | ||||
| kursr | kursr | Hedged Ex.Rt | ||||
| gbetr | gbetr | Hedged | ||||
| zfbdt | dzfbdt | Baseline Date | ||||
| valut | valut | Value date | ||||
| zuonr | dzuonr | Assignment | ||||
| sgtxt | sgtxt | Text | ||||
| anbwa | anbwa | Ast Transaction Type | ||||
| zinkz | dzinkz | Interest Block | ||||
| rmvct | rmvct | Transact. Type | ||||
| fdlev | fdlev | Planning Level | ||||
| fdgrp | fdgrp | Planning group | ||||
| fdwbt | fdwbt | Planned Amount | ||||
| fdtag | fdtag | Planning Date | ||||
| kokrs | kokrs | CO Area | ||||
| kostl | kostl | Cost Center | ||||
| aufnr | aufnr | Order | ||||
| kdauf | kdauf | Sales Order | ||||
| kdpos | kdpos | Sales Ord. Item | ||||
| pprctr | pprctr | Partner PC | ||||
| imkey | imkey | Real Estate Key | ||||
| pernr | pernr_d | Personnel No. | ||||
| xumsw | xumsw | Sales-Related | ||||
| xskrl | xskrl | W/o CashDsc. | ||||
| saknr | saknr | G/L Account | ||||
| hzuon | hzuon | Sp.G/L Assgt | ||||
| lzbkz | lzbkz | SCB Ind. | ||||
| landl | landl | Supply C/R | ||||
| matnr | matnr | Material | ||||
| werks | werks_d | Plant | ||||
| menge | menge_d | Quantity | ||||
| meins | meins | Base Unit | ||||
| bpmng | bpmng | Qty in OPUn | ||||
| ebeln | ebeln | Purchasing Doc. | ||||
| ebelp | ebelp | Item | ||||
| rewrt | reewr | Invoice Value | ||||
| rewwr | rewwr | FC Invoice Amt | ||||
| zekkn | dzekkn | Account Assgmt No. | ||||
| lfbnr | webln | GR document | ||||
| lfpos | mblpo | Mat. Doc.Item | ||||
| lfgja | mjahr | Mat. Doc. Year | ||||
| bwkey | bwkey | Valuation Area | ||||
| bwtar | bwtar_d | Valuation Type | ||||
| tbtkz | tbtkz | Subseq. Dr/Cr | ||||
| stceg | stceg | VAT Reg. No. | ||||
| prctr | prctr | Profit Center | ||||
| vname | jv_name | Joint venture | ||||
| recid | jv_recind | Recovery Ind. | ||||
| egrup | jv_egroup | Equity group | ||||
| vptnr | jv_part | Partner | ||||
| vertt | rantyp | Contract Type | ||||
| vertn | ranl | Contract Number | ||||
| vbewa | sbewart | Flow Type | ||||
| txjcd | txjcd | Tax Jur. | ||||
| dabrz | dabrbez | Reference date | ||||
| kstrg | kstrg | Cost Object | ||||
| nplnr | nplnr | Network | ||||
| aufpl | co_aufpl | Plan No.f.Oper. | ||||
| ps_psp_pnr | ps_psp_pnr | WBS Element | ||||
| paobjnr | rkeobjnr | Profit. segment | ||||
| pasubnr | rkesubnr | Subnumber | ||||
| btype | jv_bilind | Billing ind. | ||||
| etype | jv_etype | Equity Type | ||||
| xegdr | xegdr | EU Triang. Deal | ||||
| hrkft | hrkft | Origin Group | ||||
| fipos | fipos | Commitment item | ||||
| koart | koart | Account type | ||||
| vprsv | vprsv | Price control | ||||
| peinh | peinh | Price unit | ||||
| kdein | etenr | Schedule Line | ||||
| anln1 | anln1 | Asset | ||||
| anln2 | anln2 | Sub-number | ||||
| smwsk | smwsk | Tax Category | ||||
| swaer | waers | Currency | ||||
| stunr | stunr | Step Number | ||||
| zaehk | dzaehk | Counter | ||||
| xfdis | xfdis | CM Activated | ||||
| kblnr | kblnr_fi | Earmarked funds | ||||
| kblpos | kblpos | Document Item | ||||
| sttax | sttax | Statistical Tax | ||||
| geber | bp_geber | Fund | ||||
| fistl | fistl | Funds Center | ||||
| vornr | vornr | Activity | ||||
| abper | abper_rf | Settl.Period | ||||
| erekz | erekz | Final Invoice | ||||
| fkber | fkber | Functional Area | ||||
| vbund | rassc | Trading Partner | ||||
| xref1 | xref1 | Reference Key 1 | ||||
| xref2 | xref2 | Reference Key 2 | ||||
| xref3 | xref3 | Reference Key 3 | ||||
| ccbtc | ccbtc | Settlement | ||||
| rstgr | rstgr | Reason Code | ||||
| gricd | j_1agicd_d | Activity Code | ||||
| grirg | regio | Region | ||||
| gityp | j_1adtyp_d | Distr. Type | ||||
| idxsp | j_1aindxsp | Inflation Index | ||||
| buzid | buzid | Line Item ID | ||||
| erlkz | kblerlkz | Item Completed | ||||
| bupla | bupla | Business place | ||||
| lstar | lstar | Activity Type | ||||
| pstyp | pstyp | Item Category | ||||
| prznr | co_prznr | Business Process | ||||
| kontt | kontt_fi | Acct Assmt Cat. | ||||
| kontl | kontl_fi | Acct assignment | ||||
| hbkid_s | hbkid | House Bank | ||||
| hktid_s | hktid | Account ID | ||||
| grant_nbr | gm_grant_nbr | Grant | ||||
| bzdat | bzdat | Asset Val. Date | ||||
| xnegp | xnegp | Negative Postg | ||||
| segment | fb_segment | Segment | ||||
| psegment | fb_psegment | Partner Segment | ||||
| uzawe | uzawe | Pmnt Meth. Sup. | ||||
| pgeber | fm_pfund | Partner Fund | ||||
| pgrant_nbr | gm_grant_partner | Partner Grant | ||||
| measure | fm_measure | Funded Program | ||||
| budget_pd | fm_budget_period | Budget Period | ||||
| pbudget_pd | fm_pbudget_period | Par. BudPer | ||||
| netdt | netdt | Due On | ||||
| service_doc_type | fco_srvdoc_type | Service Doc. Type | ||||
| service_doc_id | fco_srvdoc_id | Service Document | ||||
| service_doc_item_id | fco_srvdoc_item_id | Service Doc. Item | ||||
| fs_product_group | ffs_product_group | Product Group (FS) | ||||
| branch_id | ffs_branch_id | Branch (FS) | ||||
| datasource_id | ffs_datasource_id | Data Source | ||||
| sdm_version | fins_sdm_version_bseg | SDM Versioning |
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 Sachkonten
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBSEGS (
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]
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]
HWBAS, -- LC Base [hwbas]
FWBAS, -- Base Amount [fwbas]
MWART, -- Tax Type [mwart]
KURSR, -- Hedged Ex.Rt [kursr]
GBETR, -- Hedged [gbetr]
ZFBDT, -- Baseline Date [dzfbdt]
VALUT, -- Value date [valut]
ZUONR, -- Assignment [dzuonr]
SGTXT, -- Text [sgtxt]
ANBWA, -- Ast Transaction Type [anbwa]
ZINKZ, -- Interest Block [dzinkz]
RMVCT, -- Transact. Type [rmvct]
FDLEV, -- Planning Level [fdlev]
FDGRP, -- Planning group [fdgrp]
FDWBT, -- Planned Amount [fdwbt]
FDTAG, -- Planning Date [fdtag]
KOKRS, -- CO Area [kokrs]
KOSTL, -- Cost Center [kostl]
AUFNR, -- Order [aufnr]
KDAUF, -- Sales Order [kdauf]
KDPOS, -- Sales Ord. Item [kdpos]
PPRCTR, -- Partner PC [pprctr]
IMKEY, -- Real Estate Key [imkey]
PERNR, -- Personnel No. [pernr_d]
XUMSW, -- Sales-Related [xumsw]
XSKRL, -- W/o CashDsc. [xskrl]
SAKNR, -- G/L Account [saknr]
HZUON, -- Sp.G/L Assgt [hzuon]
LZBKZ, -- SCB Ind. [lzbkz]
LANDL, -- Supply C/R [landl]
MATNR, -- Material [matnr]
WERKS, -- Plant [werks_d]
MENGE, -- Quantity [menge_d]
MEINS, -- Base Unit [meins]
BPMNG, -- Qty in OPUn [bpmng]
EBELN, -- Purchasing Doc. [ebeln]
EBELP, -- Item [ebelp]
REWRT, -- Invoice Value [reewr]
REWWR, -- FC Invoice Amt [rewwr]
ZEKKN, -- Account Assgmt No. [dzekkn]
LFBNR, -- GR document [webln]
LFPOS, -- Mat. Doc.Item [mblpo]
LFGJA, -- Mat. Doc. Year [mjahr]
BWKEY, -- Valuation Area [bwkey]
BWTAR, -- Valuation Type [bwtar_d]
TBTKZ, -- Subseq. Dr/Cr [tbtkz]
STCEG, -- VAT Reg. No. [stceg]
PRCTR, -- Profit Center [prctr]
VNAME, -- Joint venture [jv_name]
RECID, -- Recovery Ind. [jv_recind]
EGRUP, -- Equity group [jv_egroup]
VPTNR, -- Partner [jv_part]
VERTT, -- Contract Type [rantyp]
VERTN, -- Contract Number [ranl]
VBEWA, -- Flow Type [sbewart]
TXJCD, -- Tax Jur. [txjcd]
DABRZ, -- Reference date [dabrbez]
KSTRG, -- Cost Object [kstrg]
NPLNR, -- Network [nplnr]
AUFPL, -- Plan No.f.Oper. [co_aufpl]
PS_PSP_PNR, -- WBS Element [ps_psp_pnr]
PAOBJNR, -- Profit. segment [rkeobjnr]
PASUBNR, -- Subnumber [rkesubnr]
BTYPE, -- Billing ind. [jv_bilind]
ETYPE, -- Equity Type [jv_etype]
XEGDR, -- EU Triang. Deal [xegdr]
HRKFT, -- Origin Group [hrkft]
FIPOS, -- Commitment item [fipos]
KOART, -- Account type [koart]
VPRSV, -- Price control [vprsv]
PEINH, -- Price unit [peinh]
KDEIN, -- Schedule Line [etenr]
ANLN1, -- Asset [anln1]
ANLN2, -- Sub-number [anln2]
SMWSK, -- Tax Category [smwsk]
SWAER, -- Currency [waers]
STUNR, -- Step Number [stunr]
ZAEHK, -- Counter [dzaehk]
XFDIS, -- CM Activated [xfdis]
KBLNR, -- Earmarked funds [kblnr_fi]
KBLPOS, -- Document Item [kblpos]
STTAX, -- Statistical Tax [sttax]
GEBER, -- Fund [bp_geber]
FISTL, -- Funds Center [fistl]
VORNR, -- Activity [vornr]
ABPER, -- Settl.Period [abper_rf]
EREKZ, -- Final Invoice [erekz]
FKBER, -- Functional Area [fkber]
VBUND, -- Trading Partner [rassc]
XREF1, -- Reference Key 1 [xref1]
XREF2, -- Reference Key 2 [xref2]
XREF3, -- Reference Key 3 [xref3]
CCBTC, -- Settlement [ccbtc]
RSTGR, -- Reason Code [rstgr]
GRICD, -- Activity Code [j_1agicd_d]
GRIRG, -- Region [regio]
GITYP, -- Distr. Type [j_1adtyp_d]
IDXSP, -- Inflation Index [j_1aindxsp]
BUZID, -- Line Item ID [buzid]
ERLKZ, -- Item Completed [kblerlkz]
BUPLA, -- Business place [bupla]
LSTAR, -- Activity Type [lstar]
PSTYP, -- Item Category [pstyp]
PRZNR, -- Business Process [co_prznr]
KONTT, -- Acct Assmt Cat. [kontt_fi]
KONTL, -- Acct assignment [kontl_fi]
HBKID_S, -- House Bank [hbkid]
HKTID_S, -- Account ID [hktid]
GRANT_NBR, -- Grant [gm_grant_nbr]
BZDAT, -- Asset Val. Date [bzdat]
XNEGP, -- Negative Postg [xnegp]
SEGMENT, -- Segment [fb_segment]
PSEGMENT, -- Partner Segment [fb_psegment]
UZAWE, -- Pmnt Meth. Sup. [uzawe]
PGEBER, -- Partner Fund [fm_pfund]
PGRANT_NBR, -- Partner Grant [gm_grant_partner]
MEASURE, -- Funded Program [fm_measure]
BUDGET_PD, -- Budget Period [fm_budget_period]
PBUDGET_PD, -- Par. BudPer [fm_pbudget_period]
NETDT, -- Due On [netdt]
SERVICE_DOC_TYPE, -- Service Doc. Type [fco_srvdoc_type]
SERVICE_DOC_ID, -- Service Document [fco_srvdoc_id]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [fco_srvdoc_item_id]
FS_PRODUCT_GROUP, -- Product Group (FS) [ffs_product_group]
BRANCH_ID, -- Branch (FS) [ffs_branch_id]
DATASOURCE_ID, -- Data Source [ffs_datasource_id]
SDM_VERSION, -- SDM Versioning [fins_sdm_version_bseg]
PRIMARY KEY (MANDT, AUSBK, BELNR, GJAHR, BZKEY)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA