SAP VBSEGS Document Segment for Document Parking - G/L Account Database Table
Overview
VBSEGS is a standard SAP S/4HANA table that stores Document Segment for Document Parking - G/L Account Database data. There are total 170 fields in the VBSEGS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBSEGS belongs to Financial Accounting (FI) module and is located in the package Financial Accounting "Basis" (FBAS).
In addition, following links provide an overview of foreign key relationships, if any, that link VBSEGS to other SAP tables and standard CDS views available based on VBSEGS table in S/4HANA 2020.
Techincal Settings of VBSEGS
Below are technical details of the table VBSEGS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBSEGS Fields
The following table gives you an overview of the fields available in VBSEGS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUSBK | Source Company Code | AUSBK | T001 | CHAR | 4 |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | VBKPF | NUMC | 4 |
| BZKEY | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| BSCHL | Posting Key | BSCHL | CHAR | 2 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| GSBER | Business Area | GSBER | CHAR | 4 | |
| PARGB | Trading partner's business area | PARGB | CHAR | 4 | |
| TAX_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | CHAR | 3 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | |
| TXDAT | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| DMBTR | Amount in local currency | DMBTR | CURR | 23 | |
| DMBE2 | Amount in Second Local Currency or General Currency | DMBE2 | CURR | 23 | |
| DMBE3 | Amount in Third Local Currency or First Freely-Def. Currency | DMBE3 | CURR | 23 | |
| WRBTR | Amount in document currency | WRBTR | CURR | 23 | |
| HWMET | Method with Which the Local Currency Amount Was Determined | HWMET | CHAR | 1 | |
| HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR | 23 | |
| FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 23 | |
| MWART | Tax Type | MWART | CHAR | 1 | |
| KURSR | Hedged Exchange Rate | KURSR | DEC | 9 | |
| GBETR | Hedged Amount in Foreign Currency | GBETR | CURR | 23 | |
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| VALUT | Value date | VALUT | DATS | 8 | |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | |
| ZINKZ | Exempted from Interest Calculation | DZINKZ | CHAR | 2 | |
| RMVCT | Transaction type | RMVCT | CHAR | 3 | |
| FDLEV | Planning Level | FDLEV | CHAR | 2 | |
| FDGRP | Planning Group | FDGRP | CHAR | 10 | |
| FDWBT | Planned Amount in Document or G/L Account Currency | FDWBT | CURR | 23 | |
| FDTAG | Planning Date | FDTAG | DATS | 8 | |
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | |
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC | 6 | |
| PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| XUMSW | Indicator: Sales-Related Item ? | XUMSW | CHAR | 1 | |
| XSKRL | Indicator: Line Item Not Liable to Cash Discount? | XSKRL | CHAR | 1 | |
| SAKNR | G/L Account Number | SAKNR | CHAR | 10 | |
| HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | |
| LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | |
| LANDL | Supplying Country | LANDL | CHAR | 3 | |
| MATNR | Material Number | MATNR | CHAR | 40 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | |
| BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13 | |
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | |
| REWRT | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13 | |
| REWWR | Invoice Amount in Foreign Currency | REWWR | CURR | 23 | |
| ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | |
| LFBNR | Number of goods receipt document | WEBLN | CHAR | 10 | |
| LFPOS | Item in Material Document | MBLPO | NUMC | 4 | |
| LFGJA | Material Document Year | MJAHR | NUMC | 4 | |
| BWKEY | Valuation area | BWKEY | CHAR | 4 | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | |
| TBTKZ | Indicator: Subsequent Debit/Credit | TBTKZ | CHAR | 1 | |
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| VNAME | Joint venture | JV_NAME | CHAR | 6 | |
| RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | |
| EGRUP | Equity group | JV_EGROUP | CHAR | 3 | |
| VPTNR | Partner account number | JV_PART | CHAR | 10 | |
| VERTT | Contract Type | RANTYP | CHAR | 1 | |
| VERTN | Contract Number | RANL | CHAR | 13 | |
| VBEWA | Flow Type | SBEWART | CHAR | 4 | |
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | |
| DABRZ | Reference date for settlement | DABRBEZ | DATS | 8 | |
| KSTRG | Cost Object | KSTRG | CHAR | 12 | |
| NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| PASUBNR | Profitability Segment Changes (CO-PA) | RKESUBNR | NUMC | 4 | |
| BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | |
| ETYPE | Equity type | JV_ETYPE | CHAR | 3 | |
| XEGDR | Indicator: Triangular Deal Within the EU | XEGDR | CHAR | 1 | |
| HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | |
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | |
| KOART | Account type | KOART | CHAR | 1 | |
| VPRSV | Price control indicator | VPRSV | CHAR | 1 | |
| PEINH | Price unit | PEINH | DEC | 5 | |
| KDEIN | Schedule Line Number | ETENR | NUMC | 4 | |
| ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | |
| ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | |
| SMWSK | Tax Category in Account Master Record | SMWSK | CHAR | 2 | |
| SWAER | Currency Key | WAERS | CUKY | 5 | |
| STUNR | Step Number | STUNR | NUMC | 3 | |
| ZAEHK | Condition Counter | DZAEHK | NUMC | 3 | |
| XFDIS | Indicator: Cash Management Activated? | XFDIS | CHAR | 1 | |
| KBLNR | Document number for earmarked funds | KBLNR_FI | KBLK | CHAR | 10 |
| KBLPOS | Earmarked Funds: Document Item | KBLPOS | KBLP | NUMC | 3 |
| STTAX | Tax Amount as Statistical Information in Document Currency | STTAX | CURR | 13 | |
| GEBER | Fund | BP_GEBER | CHAR | 10 | |
| FISTL | Funds Center | FISTL | CHAR | 16 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| ABPER | Settlement Period | ABPER_RF | ACCP | 6 | |
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | |
| FKBER | Functional Area | FKBER | TFKB | CHAR | 16 |
| VBUND | Company ID of Trading Partner | RASSC | CHAR | 6 | |
| XREF1 | Business Partner Reference Key | XREF1 | CHAR | 12 | |
| XREF2 | Business Partner Reference Key | XREF2 | CHAR | 12 | |
| XREF3 | Reference key for line item | XREF3 | CHAR | 20 | |
| CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | |
| RSTGR | Reason Code for Payments | RSTGR | T053R | CHAR | 3 |
| GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | J_1AGICD | CHAR | 2 |
| GRIRG | Region (State Province County) | REGIO | T005S | CHAR | 3 |
| GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | J_1ADTYP | CHAR | 2 |
| IDXSP | Inflation Index | J_1AINDXSP | J_1AINFT20 | CHAR | 5 |
| BUZID | Identification of the Line Item | BUZID | CHAR | 1 | |
| ERLKZ | Completion indicator for line item | KBLERLKZ | CHAR | 1 | |
| BUPLA | Business Place | BUPLA | CHAR | 4 | |
| LSTAR | Activity Type | LSTAR | CHAR | 6 | |
| PSTYP | Item category in purchasing document | PSTYP | CHAR | 1 | |
| PRZNR | Business Process | CO_PRZNR | CHAR | 12 | |
| KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | |
| KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | |
| HBKID_S | Short Key for a House Bank | HBKID | CHAR | 5 | |
| HKTID_S | ID for Account Details | HKTID | CHAR | 5 | |
| ZTEST98765 | ABCDEFG - Change | ZTEST98765 | CHAR | 80 | |
| ZDIRECT | Test 456 | ZTEST456 | CHAR | 2 | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| BZDAT | Asset Value Date | BZDAT | DATS | 8 | |
| XNEGP | Indicator: Negative Posting | XNEGP | CHAR | 1 | |
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | |
| PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | |
| UZAWE | Payment method supplement | UZAWE | CHAR | 2 | |
| PGEBER | Partner Fund | FM_PFUND | CHAR | 10 | |
| PGRANT_NBR | Partner Grant | GM_GRANT_PARTNER | CHAR | 20 | |
| MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | |
| PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | |
| NETDT | Net Due Date | NETDT | DATS | 8 | |
| SERVICE_DOC_TYPE | Service Document Type | FCO_SRVDOC_TYPE | CHAR | 4 | |
| SERVICE_DOC_ID | Service Document ID | FCO_SRVDOC_ID | CHAR | 10 | |
| SERVICE_DOC_ITEM_ID | Service Document Item ID | FCO_SRVDOC_ITEM_ID | NUMC | 6 | |
| ACROBJTYPE | Type of the Accrual Object | ACR_OBJ_TYPE | TACR_OBJ_TYPE | CHAR | 4 |
| ACRLOGSYS | Logical System of the Accrual Object | ACR_LOGSYS | CHAR | 10 | |
| ACROBJ_ID | Identifier of the Accrual Object | ACR_OBJ_ID | CHAR | 32 | |
| ACRSOBJ_ID | Identifier of the Accrual Subobject | ACR_SUBOBJ_ID | CHAR | 32 | |
| ACRITMTYPE | Type of the Item of the Accrual Subobject | ACR_ITEM_TYPE | CHAR | 11 | |
| ACRVALDAT | Accrual Value Date | ACR_VALUE_DATE | DATS | 8 | |
| SDM_VERSION | SDM: Version field for BSEG | FINS_SDM_VERSION_BSEG | CHAR | 2 | |
| ANLN2_PN | Asset Subnumber | ANLN2 | * | CHAR | 4 |
| BWASL_PN | Asset Transaction Type | BWASL | * | CHAR | 3 |
| BZDAT_PN | Asset Value Date | BZDAT | DATS | 8 | |
| XVABG_PN | Indicator: Post Complete Retirement | XVABG | CHAR | 1 | |
| ANBTR_PN | Amount Posted | ANBTR | CURR | 23 | |
| PROZS_PN | Asset retirement: Percentage rate | PROZS | DEC | 5 | |
| FIPEX | Commitment item - Do not use field - see note 447805 | FM_FIPEX_DONT_USE | * | CHAR | 24 |
| PEROP_BEG | Billing Period of Performance Start Date | FM_PEROP_FI_LOW | DATS | 8 | |
| PEROP_END | Billing Period of Performance End Date | FM_PEROP_FI_HIGH | DATS | 8 | |
| FASTPAY | PPA Fast Pay Indicator | FMFG_FASTPAY_FLG | CHAR | 1 | |
| PPA_EX_IND | PPA Exclude Indicator | EXCLUDE_FLG | CHAR | 1 | |
| FMFGUS_KEY | United States Federal Government Fields | FMFG_US_KEY | CHAR | 22 | |
| PRODPER | Production Month (Date to find period and year) | JV_PRODPER | DATS | 8 | |
| HSN_SAC | HSN or SAC Code | J_1IG_HSN_SAC | CHAR | 16 | |
| INWARD_DT | Incoming Document Date | SAFM_AP_INWARD_DT | DATS | 8 | |
| GROUND_NO | Payment Basis Document Number | SAFM_AP_PYBSNO | CHAR | 16 | |
| GROUND_DT | Payment Basis Document Date | SAFM_AP_PYBSDAT | DATS | 8 | |
| GROUND_TYP | Type of Payment Basis Document | SAFM_AP_PYBSTYP | CHAR | 2 | |
| CHWRB | Document Parking: Amount not Modifiable | CHWRB | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBSEGS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBSEGS | ACROBJTYPE | : | TACR_OBJ_TYPE |
| VBSEGS | AUSBK | 1: CN | T001 |
| VBSEGS | BUKRS | 1: CN | T001 |
| VBSEGS | FKBER | 1: CN | TFKB |
| VBSEGS | GITYP | 1: CN | J_1ADTYP |
| VBSEGS | GJAHR | 1: CN | VBKPF |
| VBSEGS | GRICD | 1: CN | J_1AGICD |
| VBSEGS | GRIRG | 1: CN | T005S |
| VBSEGS | IDXSP | 1: CN | J_1AINFT20 |
| VBSEGS | KBLNR | C: CN | KBLK |
| VBSEGS | KBLPOS | C: C | KBLP |
| VBSEGS | MANDT | 1: CN | T000 |
| VBSEGS | RSTGR | C: CN | T053R |
| VBSEGS | ZZBRAND1 | : | ZTBRAND |
| VBSEGS | ZZCHECK1 | : | YTESTV1 |