VBSEGA SAP (Document Segment for Document Parking - Asset Database) Table details
Dictionary Type: Table
Description: Document Segment for Document Parking - Asset Database
Description: Document Segment for Document Parking - Asset Database
Table field list including key, data, relationships and ABAP select examples
VBSEGA is a standard SAP Table which is used to store Document Segment for Document Parking - Asset Database data and is available within R/3 SAP systems depending on the version and release level.
The VBSEGA table consists of various fields, each holding specific information or linking keys about Document Segment for Document Parking - Asset Database data available in SAP. These include AUSBK (Source Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BZKEY (Number of Line Item Within Accounting Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBSEGA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUSBK | Source Company Code | AUSBK | CHAR | 4 | T001 | BUKRS | |||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | VBKPF | GJAHR | GJAHR | GJR | |
BZKEY | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
HWMET | Method with Which the Local Currency Amount Was Determined | HWMET | CHAR | 1 | HWMET | ||||
HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR | 13(2) | WERT7 | ||||
FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
MWART | Tax Type | MWART | CHAR | 1 | MWART | ||||
KURSR | Hedged Exchange Rate | KURSR | DEC | 9(5) | KURSP | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | Assigned to domain | BWASL | |||
BZDAT | Asset value date | BZDAT | DATS | 8 | DATUM | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | KBLK | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLP | KBLPOS | KBP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
RECID | Rules for Issuing an Invoice | RECID | CHAR | 4 | TEXT4 | ||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
GRIRG | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
VPTNR | Partner account number | JV_PART | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
ERLKZ | Completion indicator for line item | KBLERLKZ | CHAR | 1 | CHAR1_X | ||||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | KONTT_FI | ||||
KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | CHAR50 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
PGRANT_NBR | Partner Grant | GM_GRANT_PARTNER | CHAR | 20 | ALPHA | GM_GRANT_NBR | GRANTS_GENERIC | ||
PGEBER | Partner Fund | FM_PFUND | CHAR | 10 | Assigned to domain | BP_GEBER | PARTNER_FUND | ||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
.INCLU--AP | 0 | ||||||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
.INCLU--AP | 0 | ||||||||
CHWRB | Document Parking: Amount not Modifiable | CHWRB | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table VBSEGA using ABAP code
The following ABAP code Example will allow you to do a basic selection on VBSEGA to SELECT all data from the tableDATA: WA_VBSEGA TYPE VBSEGA.
SELECT SINGLE *
FROM VBSEGA
INTO CORRESPONDING FIELDS OF WA_VBSEGA
WHERE...
How to access SAP table VBSEGA
Within an ECC or HANA version of SAP you can also view further information about VBSEGA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects