V_VBSEGS SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_VBSEGS is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_VBSEGS table consists of various fields, each holding specific information or linking keys about Generated Table for View 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP V_VBSEGS table view 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 | BSCHL | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | GSBER | GSB | |||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | GSBER | GSB | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | 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 | ||||
GBETR | Hedged Amount in Foreign Currency | GBETR | CURR | 13(2) | WERT7 | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
RMVCT | Transaction Type | RMVCT | CHAR | 3 | RMVCT | ||||
FDLEV | Planning level | FDLEV | CHAR | 2 | FDLEV | FFE | |||
FDGRP | Planning Group | FDGRP | CHAR | 10 | ALPHA | FDGRP | FFG | ||
FDWBT | Planning amount in document currency | FDWBT | CURR | 13(2) | WERTV7 | ||||
FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | CACCD | CAC | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | ALPHA | VBELN | AUN | ||
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | ALPHA | PRCTR | PPC | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
XUMSW | Indicator: Sales-related item ? | XUMSW | CHAR | 1 | XFELD | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | ALPHA | SAKNR | SAK | C_SAKNR | |
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | CUNIT | MEINS | |||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | ALPHA | EBELN | BES | MEKK_C | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EBELP | BSP | |||
REWRT | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13(2) | WRTV7 | ||||
REWWR | Invoice value in foreign currency | REFWR | CURR | 13(2) | WRTV7 | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
LFBNR | Number of goods receipt document | WEBLN | CHAR | 10 | ALPHA | BELNR | |||
LFPOS | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
LFGJA | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | BWKEY | BWK | |||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | BWTAR | BWT | |||
TBTKZ | Indicator: subsequent debit/credit | TBTKZ | CHAR | 1 | TBTKZ | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | ALPHA | JV_NAME | JVV | ||
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | ALPHA | JV_RECIND | |||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | ALPHA | JV_EGROUP | GJE | ||
VPTNR | Partner account number | JV_PART | CHAR | 10 | ALPHA | KUNNR | |||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VBEWA | Flow Type | SBEWART | CHAR | 4 | SBEWART | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | KSTRG | KTR | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | ALPHA | AUFNR | NET | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | ALPHA | JV_BILIND | |||
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | ALPHA | JV_ETYPE | |||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | HRKFT | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FIPOS | FIP | |||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
VPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
KDEIN | Delivery Schedule Line Number | ETENR | NUMC | 4 | ETENR | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ALPHA | ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ALPHA | ANLN2 | AN2 | ||
SMWSK | Tax Category in Account Master Record | SMWSK | CHAR | 2 | SMWSK | ||||
SWAER | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
STUNR | Step number | STUNR | NUMC | 3 | STUNR | ||||
ZAEHK | Condition counter | DZAEHK | NUMC | 2 | ZAEHK | ||||
XFDIS | Indicator: Cash Management activated? | XFDIS | CHAR | 1 | XFELD | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
AEDAT | Date of the Last Document Change | AEDT_VBKPF | DATS | 8 | DATUM | ||||
UPDDT | Date of the Last Document Update | UPDDT | DATS | 8 | DATUM | ||||
USNAM | User Name | USNM_VBKPF | CHAR | 12 | USNAM | USR | |||
TCODE | Transaction Code | TCODE | CHAR | 20 | TCODE | TCD | |||
BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 16 | BVORG | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FIKRS | FIK | |||
KOARS | Account Types Allowed | KOARS_003 | CHAR | 5 | CHAR5 | ||||
XBSET | Tax information exists in the document | XBSET | CHAR | 1 | XFELD | ||||
XSNET | G/L account amounts entered exclude tax | XSNET | CHAR | 1 | XFELD | ||||
XBWAE | Only transfer document in document currency when posting | XBWAE | CHAR | 1 | XFELD | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
HWAER | Local Currency | HWAER | CUKY | 5 | WAERS | ||||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | WAERS | ||||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | WAERS | ||||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
KURS2 | Exchange Rate for the Second Local Currency | KURS2 | DEC | 9(5) | KURSF | ||||
KURS3 | Exchange Rate for the Third Local Currency | KURS3 | DEC | 9(5) | KURSF | ||||
BASW2 | Source Currency for Currency Translation | CURSR | CHAR | 1 | CURSR | ||||
BASW3 | Source Currency for Currency Translation | CURSR | CHAR | 1 | CURSR | ||||
UMRD2 | Translation Date Type for Second Local Currency | UMRD2 | CHAR | 1 | CURDT | ||||
UMRD3 | Translation Date Type for Third Local Currency | UMRD3 | CHAR | 1 | CURDT | ||||
CURT2 | Currency Type of Second Local Currency | CURT2 | CHAR | 2 | CURTP | ||||
CURT3 | Currency Type of Third Local Currency | CURT3 | CHAR | 2 | CURTP | ||||
KUTY2 | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
KUTY3 | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
XMWST | Calculate tax automatically | XMWST | CHAR | 1 | XFELD | XTX | |||
PARGB_BKPF | Partner Business Area Default Value | PGBVW | CHAR | 4 | TGSB | GSBER | |||
VBLNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
VGJHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
XFRGE | Released | XFRGE | CHAR | 1 | XFELD | ||||
XPRFG | Document complete | XPRFG | CHAR | 1 | XFELD | ||||
FRATH | Unplanned delivery costs | FRATH | CURR | 13(2) | WERT7 | ||||
XWFFR | Release necessary | XWFFR | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS |
Key field | Non-key field |
How do I retrieve data from SAP table V_VBSEGS using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_VBSEGS to SELECT all data from the tableDATA: WA_V_VBSEGS TYPE V_VBSEGS.
SELECT SINGLE *
FROM V_VBSEGS
INTO CORRESPONDING FIELDS OF WA_V_VBSEGS
WHERE...
How to access SAP table V_VBSEGS
Within an ECC or HANA version of SAP you can also view further information about V_VBSEGS 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