VBSEGS

Transparent Table Application Table
179 Fields 7 CDS Views

Document Segment for Document Parking - G/L Account Database

VBSEGS is an SAP database table in S/4HANA. Document Segment for Document Parking - G/L Account Database. It contains 179 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
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 (179)

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
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
dummy_incl_eew_cobl CFD_DUMMY Dummy
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
kdgrp KDGRP Customer Group
land1 COBL_LAND1_GP Country/Region
brsch BRSCH Industry
acrobjtype ACR_OBJ_TYPE Accrual Object Type
acrlogsys ACR_LOGSYS Logical Syst. AcrObj
acrobj_id ACR_OBJ_ID Accrual Object
acrsobj_id ACR_SUBOBJ_ID Accrual Subobject
acritmtype ACR_ITEM_TYPE Accrual Item Type
acrrefobj_id ACR_REFOBJ_ID Acr. Reference ID
acrvaldat ACR_VALUE_DATE Accrual Value Date
sdm_version FINS_SDM_VERSION_BSEG SDM Versioning
anln2_pn ANLN2 Sub-number
bwasl_pn BWASL Trans. Type
bzdat_pn BZDAT Asset Val. Date
xvabg_pn XVABG Compl.Retiremnt
anbtr_pn ANBTR Amount Posted
prozs_pn PROZS Percentage Rate
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
fipex FM_FIPEX_DONT_USE Commitment Item
perop_beg FM_PEROP_FI_LOW Per. of Perf. Start
perop_end FM_PEROP_FI_HIGH Per. of Perf. End
fastpay FMFG_FASTPAY_FLG Fast Pay
ppa_ex_ind EXCLUDE_FLG PPA Exclude
fmfgus_key FMFG_US_KEY US Govt
prodper JV_PRODPER Prod.Month
hsn_sac J_1IG_HSN_SAC HSN/SAC Code
inward_no SAFM_AP_INWARD_NO Incg Doc. Nmbr
inward_dt SAFM_AP_INWARD_DT Incg Doc. Date
ground_no SAFM_AP_PYBSNO Payt. Ground No.
ground_dt SAFM_AP_PYBSDAT Payt. Ground Date
ground_typ SAFM_AP_PYBSTYP Payt. Against
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 - G/L Account Database
-- 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]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    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]
    KDGRP,                -- Customer Group [KDGRP]
    LAND1,                -- Country/Region [COBL_LAND1_GP]
    BRSCH,                -- Industry [BRSCH]
    ACROBJTYPE,           -- Accrual Object Type [ACR_OBJ_TYPE]
    ACRLOGSYS,            -- Logical Syst. AcrObj [ACR_LOGSYS]
    ACROBJ_ID,            -- Accrual Object [ACR_OBJ_ID]
    ACRSOBJ_ID,           -- Accrual Subobject [ACR_SUBOBJ_ID]
    ACRITMTYPE,           -- Accrual Item Type [ACR_ITEM_TYPE]
    ACRREFOBJ_ID,         -- Acr. Reference ID [ACR_REFOBJ_ID]
    ACRVALDAT,            -- Accrual Value Date [ACR_VALUE_DATE]
    SDM_VERSION,          -- SDM Versioning [FINS_SDM_VERSION_BSEG]
    ANLN2_PN,             -- Sub-number [ANLN2]
    BWASL_PN,             -- Trans. Type [BWASL]
    BZDAT_PN,             -- Asset Val. Date [BZDAT]
    XVABG_PN,             -- Compl.Retiremnt [XVABG]
    ANBTR_PN,             -- Amount Posted [ANBTR]
    PROZS_PN,             -- Percentage Rate [PROZS]
    WORK_ITEM_ID,         -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    FIPEX,                -- Commitment Item [FM_FIPEX_DONT_USE]
    PEROP_BEG,            -- Per. of Perf. Start [FM_PEROP_FI_LOW]
    PEROP_END,            -- Per. of Perf. End [FM_PEROP_FI_HIGH]
    FASTPAY,              -- Fast Pay [FMFG_FASTPAY_FLG]
    PPA_EX_IND,           -- PPA Exclude [EXCLUDE_FLG]
    FMFGUS_KEY,           -- US Govt [FMFG_US_KEY]
    PRODPER,              -- Prod.Month [JV_PRODPER]
    HSN_SAC,              -- HSN/SAC Code [J_1IG_HSN_SAC]
    INWARD_NO,            -- Incg Doc. Nmbr [SAFM_AP_INWARD_NO]
    INWARD_DT,            -- Incg Doc. Date [SAFM_AP_INWARD_DT]
    GROUND_NO,            -- Payt. Ground No. [SAFM_AP_PYBSNO]
    GROUND_DT,            -- Payt. Ground Date [SAFM_AP_PYBSDAT]
    GROUND_TYP,           -- Payt. Against [SAFM_AP_PYBSTYP]
    CHWRB,                -- Fixed amount [CHWRB]
    PRIMARY KEY (MANDT, AUSBK, BELNR, GJAHR, BZKEY)
);

Learn More