SAP ABAP View V_VBSEGS (View of VBKPF and VBSEGK)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

View Type	D	Database View
Database View	V_VBSEGS
Short Description	View of VBKPF and VBSEGK
Root table	VBSEGS	Document Segment for Document Parking - G/L Account Database

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBSEGS	VBSEGS
2	VBKPF

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBKPF	MANDT	JL	EQ				0	0
2	VBSEGS	MANDT	JR	EQ			AND	0	0
3	VBKPF	AUSBK	JL	EQ				0	0
4	VBSEGS	AUSBK	JR	EQ			AND	0	0
5	VBKPF	BUKRS	JL	EQ				0	0
6	VBSEGS	BUKRS	JR	EQ			AND	0	0
7	VBKPF	BELNR	JL	EQ				0	0
8	VBSEGS	BELNR	JR	EQ			AND	0	0
9	VBKPF	GJAHR	JL	EQ				0	0
10	VBSEGS	GJAHR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBSEGS	MANDT		☐	MANDT	☐	Client
2	AUSBK	VBSEGS	AUSBK		☐	AUSBK	☐	Source Company Code
3	BELNR	VBSEGS	BELNR		☐	BELNR_D	☐	Accounting Document Number
4	GJAHR	VBSEGS	GJAHR		☐	GJAHR	☐	Fiscal Year
5	BZKEY	VBSEGS	BZKEY		☐	BUZEI	☐	Number of Line Item Within Accounting Document
6	BUKRS	VBSEGS	BUKRS		☐	BUKRS	☐	Company Code
7	BUZEI	VBSEGS	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
8	BSCHL	VBSEGS	BSCHL		☐	BSCHL	☐	Posting Key
9	SHKZG	VBSEGS	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
10	GSBER	VBSEGS	GSBER		☐	GSBER	☐	Business Area
11	PARGB	VBSEGS	PARGB		☐	PARGB	☐	Trading partner's business area
12	MWSKZ	VBSEGS	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
13	DMBTR	VBSEGS	DMBTR		☐	DMBTR	☐	Amount in local currency
14	DMBE2	VBSEGS	DMBE2		☐	DMBE2	☐	Amount in Second Local Currency
15	DMBE3	VBSEGS	DMBE3		☐	DMBE3	☐	Amount in Third Local Currency
16	WRBTR	VBSEGS	WRBTR		☐	WRBTR	☐	Amount in document currency
17	HWMET	VBSEGS	HWMET		☐	HWMET	☐	Method with Which the Local Currency Amount Was Determined
18	HWBAS	VBSEGS	HWBAS		☐	HWBAS	☐	Tax Base Amount in Local Currency
19	FWBAS	VBSEGS	FWBAS		☐	FWBAS	☐	Tax Base Amount in Document Currency
20	MWART	VBSEGS	MWART		☐	MWART	☐	Tax Type
21	KURSR	VBSEGS	KURSR		☐	KURSR	☐	Hedged Exchange Rate
22	GBETR	VBSEGS	GBETR		☐	GBETR	☐	Hedged Amount in Foreign Currency
23	ZFBDT	VBSEGS	ZFBDT		☐	DZFBDT	☐	Baseline date for due date calculation
24	VALUT	VBSEGS	VALUT		☐	VALUT	☐	Fixed Value Date
25	ZUONR	VBSEGS	ZUONR		☐	DZUONR	☐	Assignment number
26	SGTXT	VBSEGS	SGTXT		☐	SGTXT	☐	Item Text
27	ZINKZ	VBSEGS	ZINKZ		☐	DZINKZ	☐	Exempted from Interest Calculation
28	RMVCT	VBSEGS	RMVCT		☐	RMVCT	☐	Transaction type
29	FDLEV	VBSEGS	FDLEV		☐	FDLEV	☐	Planning Level
30	FDGRP	VBSEGS	FDGRP		☐	FDGRP	☐	Planning Group
31	FDWBT	VBSEGS	FDWBT		☐	FDWBT	☐	Planned Amount in Document or G/L Account Currency
32	FDTAG	VBSEGS	FDTAG		☐	FDTAG	☐	Planning Date
33	KOKRS	VBSEGS	KOKRS		☐	KOKRS	☐	Controlling Area
34	KOSTL	VBSEGS	KOSTL		☐	KOSTL	☐	Cost Center
35	AUFNR	VBSEGS	AUFNR		☐	AUFNR	☐	Order Number
36	KDAUF	VBSEGS	KDAUF		☐	KDAUF	☐	Sales Order Number
37	KDPOS	VBSEGS	KDPOS		☐	KDPOS	☐	Item number in Sales Order
38	PPRCTR	VBSEGS	PPRCTR		☐	PPRCTR	☐	Partner Profit Center
39	IMKEY	VBSEGS	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
40	PERNR	VBSEGS	PERNR		☐	PERNR_D	☐	Personnel Number
41	XUMSW	VBSEGS	XUMSW		☐	XUMSW	☐	Indicator: Sales-Related Item ?
42	XSKRL	VBSEGS	XSKRL		☐	XSKRL	☐	Indicator: Line item not liable to cash discount?
43	SAKNR	VBSEGS	SAKNR		☐	SAKNR	☐	G/L Account Number
44	HZUON	VBSEGS	HZUON		☐	HZUON	☐	Assignment Number for Special G/L Accounts
45	MATNR	VBSEGS	MATNR		☐	MATNR	☐	Material Number
46	WERKS	VBSEGS	WERKS		☐	WERKS_D	☐	Plant
47	MENGE	VBSEGS	MENGE		☐	MENGE_D	☐	Quantity
48	MEINS	VBSEGS	MEINS		☐	MEINS	☐	Base Unit of Measure
49	BPMNG	VBSEGS	BPMNG		☐	BPMNG	☐	Quantity in order price quantity unit
50	EBELN	VBSEGS	EBELN		☐	EBELN	☐	Purchasing Document Number
51	EBELP	VBSEGS	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
52	REWRT	VBSEGS	REWRT		☐	REEWR	☐	Invoice Value Entered (in Local Currency)
53	REWWR	VBSEGS	REWWR		☐	REFWR	☐	Invoice Value in Foreign Currency
54	ZEKKN	VBSEGS	ZEKKN		☐	DZEKKN	☐	Sequential Number of Account Assignment
55	LFBNR	VBSEGS	LFBNR		☐	WEBLN	☐	Number of goods receipt document
56	LFPOS	VBSEGS	LFPOS		☐	MBLPO	☐	Item in material document
57	LFGJA	VBSEGS	LFGJA		☐	MJAHR	☐	Year of material document
58	BWKEY	VBSEGS	BWKEY		☐	BWKEY	☐	Valuation area
59	BWTAR	VBSEGS	BWTAR		☐	BWTAR_D	☐	Valuation type
60	TBTKZ	VBSEGS	TBTKZ		☐	TBTKZ	☐	Indicator: Subsequent Debit/Credit
61	STCEG	VBSEGS	STCEG		☐	STCEG	☐	VAT Registration Number
62	PRCTR	VBSEGS	PRCTR		☐	PRCTR	☐	Profit Center
63	VNAME	VBSEGS	VNAME		☐	JV_NAME	☐	Joint venture
64	RECID	VBSEGS	RECID		☐	JV_RECIND	☐	Recovery Indicator
65	EGRUP	VBSEGS	EGRUP		☐	JV_EGROUP	☐	Equity group
66	VPTNR	VBSEGS	VPTNR		☐	JV_PART	☐	Partner account number
67	VERTT	VBSEGS	VERTT		☐	RANTYP	☐	Contract Type
68	VERTN	VBSEGS	VERTN		☐	RANL	☐	Contract Number
69	VBEWA	VBSEGS	VBEWA		☐	SBEWART	☐	Flow Type
70	TXJCD	VBSEGS	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
71	DABRZ	VBSEGS	DABRZ		☐	DABRBEZ	☐	Reference date for settlement
72	KSTRG	VBSEGS	KSTRG		☐	KSTRG	☐	Cost Object
73	NPLNR	VBSEGS	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
74	AUFPL	VBSEGS	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
75	PS_PSP_PNR	VBSEGS	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
76	PAOBJNR	VBSEGS	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
77	PASUBNR	VBSEGS	PASUBNR		☐	RKESUBNR	☐	Profitability Segment Changes (CO-PA)
78	BTYPE	VBSEGS	BTYPE		☐	JV_BILIND	☐	Payroll Type
79	ETYPE	VBSEGS	ETYPE		☐	JV_ETYPE	☐	Equity type
80	XEGDR	VBSEGS	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
81	HRKFT	VBSEGS	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
82	FIPOS	VBSEGS	FIPOS		☐	FIPOS	☐	Commitment Item
83	KOART	VBSEGS	KOART		☐	KOART	☐	Account type
84	VPRSV	VBSEGS	VPRSV		☐	VPRSV	☐	Price control indicator
85	PEINH	VBSEGS	PEINH		☐	PEINH	☐	Price unit
86	KDEIN	VBSEGS	KDEIN		☐	ETENR	☐	Schedule line
87	ANLN1	VBSEGS	ANLN1		☐	ANLN1	☐	Main Asset Number
88	ANLN2	VBSEGS	ANLN2		☐	ANLN2	☐	Asset Subnumber
89	SMWSK	VBSEGS	SMWSK		☐	SMWSK	☐	Tax Category in Account Master Record
90	SWAER	VBSEGS	SWAER		☐	WAERS	☐	Currency Key
91	STUNR	VBSEGS	STUNR		☐	STUNR	☐	Level Number
92	ZAEHK	VBSEGS	ZAEHK		☐	DZAEHK	☐	Condition counter
93	XFDIS	VBSEGS	XFDIS		☐	XFDIS	☐	Indicator: Cash Management activated?
94	XREF3	VBSEGS	XREF3		☐	XREF3	☐	Reference key for line item
95	RSTGR	VBSEGS	RSTGR		☐	RSTGR	☐	Reason Code for Payments
96	FISTL	VBSEGS	FISTL		☐	FISTL	☐	Funds Center
97	BSTAT	VBKPF	BSTAT		☐	BSTAT_D	☐	Document Status
98	BLART	VBKPF	BLART		☐	BLART	☐	Document type
99	BLDAT	VBKPF	BLDAT		☐	BLDAT	☐	Document Date in Document
100	BUDAT	VBKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
101	MONAT	VBKPF	MONAT		☐	MONAT	☐	Fiscal period
102	WWERT	VBKPF	WWERT		☐	WWERT_D	☐	Translation date
103	CPUDT	VBKPF	CPUDT		☐	CPUDT	☐	Accounting document entry date
104	CPUTM	VBKPF	CPUTM		☐	CPUTM	☐	Time of data entry
105	AEDAT	VBKPF	AEDAT		☐	AEDT_VBKPF	☐	Date of the Last Document Change
106	UPDDT	VBKPF	UPDDT		☐	UPDDT	☐	Date of the Last Document Update
107	USNAM	VBKPF	USNAM		☐	USNM_VBKPF	☐	User Name
108	TCODE	VBKPF	TCODE		☐	TCODE	☐	Transaction Code
109	BVORG	VBKPF	BVORG		☐	BVORG	☐	Number of Cross-Company Code Posting Transaction
110	XBLNR	VBKPF	XBLNR		☐	XBLNR1	☐	Reference Document Number
111	BKTXT	VBKPF	BKTXT		☐	BKTXT	☐	Document Header Text
112	FIKRS	VBKPF	FIKRS		☐	FIKRS	☐	Financial Management Area
113	KOARS	VBKPF	KOARS		☐	KOARS_003	☐	Account Types Allowed
114	XBSET	VBKPF	XBSET		☐	XBSET	☐	Tax information exists in the document
115	XSNET	VBKPF	XSNET		☐	XSNET	☐	G/L account amounts entered exclude tax
116	XBWAE	VBKPF	XBWAE		☐	XBWAE	☐	Only transfer document in document currency when posting
117	WAERS	VBKPF	WAERS		☐	WAERS	☐	Currency Key
118	HWAER	VBKPF	HWAER		☐	HWAER	☐	Local Currency
119	HWAE2	VBKPF	HWAE2		☐	HWAE2	☐	Currency Key of Second Local Currency
120	HWAE3	VBKPF	HWAE3		☐	HWAE3	☐	Currency Key of Third Local Currency
121	KURSF	VBKPF	KURSF		☐	KURSF	☐	Exchange rate
122	KURS2	VBKPF	KURS2		☐	KURS2	☐	Exchange Rate for the Second Local Currency
123	KURS3	VBKPF	KURS3		☐	KURS3	☐	Exchange Rate for the Third Local Currency
124	BASW2	VBKPF	BASW2		☐	CURSR	☐	Source Currency for Currency Translation
125	BASW3	VBKPF	BASW3		☐	CURSR	☐	Source Currency for Currency Translation
126	UMRD2	VBKPF	UMRD2		☐	UMRD2	☐	Translation Date Type for Second Local Currency
127	UMRD3	VBKPF	UMRD3		☐	UMRD3	☐	Translation Date Type for Third Local Currency
128	CURT2	VBKPF	CURT2		☐	CURT2	☐	Currency Type of Second Local Currency
129	CURT3	VBKPF	CURT3		☐	CURT3	☐	Currency Type of Third Local Currency
130	KUTY2	VBKPF	KUTY2		☐	KURST	☐	Exchange Rate Type
131	KUTY3	VBKPF	KUTY3		☐	KURST	☐	Exchange Rate Type
132	XMWST	VBKPF	XMWST		☐	XMWST	☐	Calculate tax automatically
133	PARGB_BKPF	VBKPF	PARGB		☐	PGBVW	☐	Partner Business Area Default Value
134	VBLNR	VBKPF	VBLNR		☐	BELNR_D	☐	Accounting Document Number
135	VGJHR	VBKPF	VGJHR		☐	GJAHR	☐	Fiscal Year
136	XFRGE	VBKPF	XFRGE		☐	XFRGE	☐	Released
137	XPRFG	VBKPF	XPRFG		☐	XPRFG	☐	Document complete
138	FRATH	VBKPF	FRATH		☐	FRATH	☐	Unplanned Delivery Costs
139	XWFFR	VBKPF	XWFFR		☐	XWFFR	☐	Release necessary
140	VBUND	VBKPF	VBUND		☐	RASSC	☐	Company ID of trading partner

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in	470