SAP ABAP Table V_VBSEGD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_VBSEGD	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUSBK	AUSBK	BUKRS	CHAR	4	0	Source Company Code	T001
3	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year	VBKPF
5	BZKEY	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	BUZEI	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
8	BSCHL	BSCHL	BSCHL	CHAR	2	0	Posting Key
9	UMSKZ	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator
10	UMSKS	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
11	SHKZG	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
12	GSBER	GSBER	GSBER	CHAR	4	0	Business Area
13	PARGB	PARGB	GSBER	CHAR	4	0	Trading partner's business area
14	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
15	DMBTR	DMBTR	WERT7	CURR	13	2	Amount in local currency
16	DMBE2	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
17	DMBE3	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
18	WRBTR	WRBTR	WERT7	CURR	13	2	Amount in document currency
19	HWMET	HWMET	HWMET	CHAR	1	0	Method with Which the Local Currency Amount Was Determined
20	MWSTS	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
21	MWST2	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
22	MWST3	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
23	WMWST	WMWST	WERT7	CURR	13	2	Tax amount in document currency
24	HWBAS	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
25	FWBAS	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
26	MWART	MWART	MWART	CHAR	1	0	Tax Type
27	KURSR	KURSR	KURSP	DEC	9	5	Hedged Exchange Rate
28	GBETR	GBETR	WERT7	CURR	13	2	Hedged Amount in Foreign Currency
29	VALUT	VALUT	DATUM	DATS	8	0	Fixed Value Date
30	ZUONR	DZUONR	ZUONR	CHAR	18	0	Assignment number
31	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
32	ZINKZ	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
33	FDLEV	FDLEV	FDLEV	CHAR	2	0	Planning Level
34	FDGRP	FDGRP	FDGRP	CHAR	10	0	Planning Group
35	FDWBT	FDWBT	WERTV7	CURR	13	2	Planned Amount in Document or G/L Account Currency
36	FDTAG	FDTAG	DATUM	DATS	8	0	Planning Date
37	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
38	FISTL	FISTL	FISTL	CHAR	16	0	Funds Center
39	VNAME	JV_NAME	JV_NAME	CHAR	6	0	Joint venture
40	EGRUP	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group
41	BTYPE	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type
42	XUMSW	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
43	XCPDD	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
44	XZEMP	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
45	HKONT	HKONT	SAKNR	CHAR	10	0	General Ledger Account
46	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number
47	FILKD	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
48	HZUON	HZUON	ZUONR	CHAR	18	0	Assignment Number for Special G/L Accounts
49	ZFBDT	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
50	ZTERM	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
51	ZBD1T	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
52	ZBD2T	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
53	ZBD3T	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
54	ZBD1P	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
55	ZBD2P	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
56	XSKFB	XSKFB	XFELD	CHAR	1	0	Indicator: Calculate amounts qualifying for cash discount ?
57	SKFBT	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
58	SKNTO	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
59	WSKTO	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
60	ZLSCH	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
61	ZLSPR	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key
62	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement
63	HBKID	HBKID	HBKID	CHAR	5	0	Short key for a house bank
64	BVTYP	BVTYP	BVTYP	CHAR	4	0	Partner bank type
65	REBZG	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
66	REBZJ	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
67	REBZZ	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
68	REBZT	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
69	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator
70	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country
71	DIEKZ	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
72	VRSKZ	VRSKZ	CHAR1	CHAR	1	0	Insurance Indicator
73	VRSDT	VRSDT	DATUM	DATS	8	0	Insurance Date
74	BLNBT	BLNBT	WERT7	CURR	13	2	Base Amount for Determining the Preference Amount
75	BLNKZ	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates
76	BLNPZ	BLNPZ	PRZ52	DEC	7	2	Preference Percentage Rate
77	MSCHL	MSCHL	MSCHL	CHAR	1	0	Dunning key
78	MANSP	MANSP	MANSP	CHAR	1	0	Dunning block
79	MABER	MABER	MABER	CHAR	2	0	Dunning Area
80	STCEG	STCEG	STCEG	CHAR	20	0	VAT Registration Number
81	XHKOM	XHKOM	XFELD	CHAR	1	0	Indicator: G/L Account Assigned Manually?
82	VERTT	RANTYP	RANTYP	CHAR	1	0	Contract Type
83	VERTN	RANL	RANL	CHAR	13	0	Contract Number
84	VBEWA	SBEWART	SBEWART	CHAR	4	0	Flow Type
85	XEGDR	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
86	FIPOS	FIPOS	FIPOS	CHAR	14	0	Commitment Item
87	SWAER	WAERS	WAERS	CUKY	5	0	Currency Key
88	MADAT	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
89	MANST	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
90	SAMNR	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
91	ANFBN	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
92	ANFBJ	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
93	ANFBU	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	T001
94	ANFAE	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
95	EGMLD	EGMLD_BSEZ	LAND1	CHAR	3	0	Reporting Country for Delivery of Goods within the EU
96	XEGMD	XEGMD	XFELD	CHAR	1	0	EC reporting country deleted
97	XREF1	XREF1	CHAR12	CHAR	12	0	Business partner reference key
98	XREF2	XREF2	CHAR12	CHAR	12	0	Business partner reference key
99	XREF3	XREF3	CHAR20	CHAR	20	0	Reference key for line item
100	XZANF	XZANF	XFELD	CHAR	1	0	Indicator: Payment demand
101	XFDIS	XFDIS	XFELD	CHAR	1	0	Indicator: Cash Management activated?
102	KKBER	KKBER	KKBER	CHAR	4	0	Credit control area	T014
103	RSTGR	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	T053R
104	EMPFB	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
105	BSTAT	BSTAT_D	BSTAT	CHAR	1	0	Document Status
106	BLART	BLART	BLART	CHAR	2	0	Document type	T003
107	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
108	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
109	MONAT	MONAT	MONAT	NUMC	2	0	Fiscal period
110	WWERT	WWERT_D	DATUM	DATS	8	0	Translation date
111	CPUDT	CPUDT	DATUM	DATS	8	0	Accounting document entry date
112	CPUTM	CPUTM	UZEIT	TIMS	6	0	Time of data entry
113	AEDAT	AEDT_VBKPF	DATUM	DATS	8	0	Date of the Last Document Change
114	UPDDT	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
115	USNAM	USNM_VBKPF	USNAM	CHAR	12	0	User Name
116	TCODE	TCODE	TCODE	CHAR	20	0	Transaction Code
117	BVORG	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
118	XBLNR	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
119	BKTXT	BKTXT	TEXT25	CHAR	25	0	Document Header Text
120	FIKRS	FIKRS	FIKRS	CHAR	4	0	Financial Management Area
121	KOARS	KOARS_003	CHAR5	CHAR	5	0	Account Types Allowed
122	XBSET	XBSET	XFELD	CHAR	1	0	Tax information exists in the document
123	XSNET	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
124	XBWAE	XBWAE	XFELD	CHAR	1	0	Only transfer document in document currency when posting
125	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key
126	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency
127	HWAE2	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency
128	HWAE3	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency
129	KURSF	KURSF	KURSF	DEC	9	5	Exchange rate
130	KURS2	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
131	KURS3	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
132	BASW2	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
133	BASW3	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
134	UMRD2	UMRD2	CURDT	CHAR	1	0	Translation Date Type for Second Local Currency
135	UMRD3	UMRD3	CURDT	CHAR	1	0	Translation Date Type for Third Local Currency
136	CURT2	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
137	CURT3	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
138	KUTY2	KURST	KURST	CHAR	4	0	Exchange Rate Type
139	KUTY3	KURST	KURST	CHAR	4	0	Exchange Rate Type
140	XMWST	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
141	PARGB_BKPF	PGBVW	GSBER	CHAR	4	0	Partner Business Area Default Value	TGSB
142	VBLNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
143	VGJHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
144	XFRGE	XFRGE	XFELD	CHAR	1	0	Released
145	XPRFG	XPRFG	XFELD	CHAR	1	0	Document complete
146	FRATH	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
147	XWFFR	XWFFR	XFELD	CHAR	1	0	Release necessary
148	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_VBSEGD	ANFBU	T001	BUKRS
2	V_VBSEGD	AUSBK	T001	BUKRS	KEY	1	CN
3	V_VBSEGD	BLART	T003	BLART	REF	1	CN
4	V_VBSEGD	BUKRS	T001	BUKRS	REF	1	CN
5	V_VBSEGD	GJAHR	VBKPF	GJAHR	KEY	1	CN
6	V_VBSEGD	KKBER	T014	KKBER		1	CN
7	V_VBSEGD	MANDT	T000	MANDT	KEY	1	CN
8	V_VBSEGD	PARGB_BKPF	TGSB	GSBER
9	V_VBSEGD	RSTGR	T053R	RSTGR		C	CN