VBSEGA
Document Segment for Document Parking - Asset Database
VBSEGA is an SAP database table in S/4HANA. Document Segment for Document Parking - Asset Database. It contains 85 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FISVD_DOCNR_GAP_PARK_AA | view | inner | Asset Park Document Data | |
| I_ParkedOplAcctgDocAssetItem | view_entity | from | BASIC | Parked Asset Item |
| P_VBSEGA_COM | view | from | BASIC |
Fields (85)
| 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 | ||||
| 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 | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| 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 | ||||
| xref1 | XREF1 | Reference Key 1 | ||||
| chwrb | CHWRB | Fixed amount |
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.
-- Document Segment for Document Parking - Asset Database
-- 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]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
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]
XREF1, -- Reference Key 1 [XREF1]
CHWRB, -- Fixed amount [CHWRB]
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