	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

327 COLUMNS | 1 INDEXES | ERP 6.0 | FUDT_VDOCBSEG TABLE

ERP EHP7

6.0

327

Verification Document Item with Additional Info

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, BELNR, GJAHR, BUZEI, BUZID, AUGDT, AUGCP, AUGBL, BSCHL, KOART, UMSKZ, UMSKS, ZUMSK, SHKZG, GSBER, PARGB, MWSKZ, QSSKZ, DMBTR, WRBTR, KZBTR, PSWBT, PSWSL, TXBHW, TXBFW, MWSTS, WMWST, HWBAS, FWBAS, HWZUZ, FWZUZ, SHZUZ, STEKZ, MWART, TXGRP, KTOSL, QSSHB, KURSR, GBETR, BDIFF, BDIF2, VALUT, ZUONR, SGTXT, ZINKZ, VBUND, BEWAR, ALTKT, VORGN, FDLEV, FDGRP, FDWBT, FDTAG, FKONT, KOKRS, KOSTL, PROJN, AUFNR, VBELN, VBEL2, POSN2, ETEN2, ANLN1, ANLN2, ANBWA, BZDAT, PERNR, XUMSW, XHRES, XKRES, XOPVW, XCPDD, XSKST, XSAUF, XSPRO, XSERG, XFAKT, XUMAN, XANET, XSKRL, XINVE, XPANZ, XAUTO, XNCOP, XZAHL, SAKNR, HKONT, KUNNR, LIFNR, FILKD, XBILK, GVTYP, HZUON, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, NEBTR, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, REBZG, REBZJ, REBZZ, REBZT, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, SAMNR, ABPER, VRSKZ, VRSDT, DISBN, DISBJ, DISBZ, WVERW, ANFBN, ANFBJ, ANFBU, ANFAE, BLNBT, BLNKZ, BLNPZ, MSCHL, MANSP, MADAT, MANST, MABER, ESRNR, ESRRE, ESRPZ, KLIBT, QSZNR, QBSHB, QSFBT, NAVHW, NAVFW, MATNR, WERKS, MENGE, MEINS, ERFMG, ERFME, BPMNG, BPRME, EBELN, EBELP, ZEKKN, ELIKZ, VPRSV, PEINH, BWKEY, BWTAR, BUSTW, REWRT, REWWR, BONFB, BUALT, PSALT, NPREI, TBTKZ, SPGRP, SPGRM, SPGRT, SPGRG, SPGRV, SPGRQ, STCEG, EGBLD, EGLLD, RSTGR, RYACQ, RPACQ, RDIFF, RDIF2, PRCTR, XHKOM, VNAME, RECID, EGRUP, VPTNR, VERTT, VERTN, VBEWA, DEPOT, TXJCD, IMKEY, DABRZ, POPTS, FIPOS, KSTRG, NPLNR, AUFPL, APLZL, PROJK, PAOBJNR, PASUBNR, SPGRS, SPGRC, BTYPE, ETYPE, XEGDR, LNRAN, HRKFT, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, NAVH2, NAVH3, SKNT2, SKNT3, BDIF3, RDIF3, HWMET, GLUPM, XRAGL, UZAWE, LOKKT, FISTL, GEBER, STBUK, TXBH2, TXBH3, PPRCT, XREF1, XREF2, KBLNR, KBLPOS, STTAX, FKBER, OBZEI, XNEGP, RFZEI, CCBTC, KKBER, EMPFB, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, GRICD, GRIRG, GITYP, XPYPR, KIDNO, ABSBT, IDXSP, LINFV, KONTT, KONTL, TXDAT, AGZEI, PYCUR, PYAMT, BUPLA, SECCO, LSTAR, CESSION_KZ, PRZNR, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, GRANT_NBR, SCTAX, FKBER_LONG, GMVKZ, SRTYPE, INTRENO, MEASURE, AUGGJ, PPA_EX_IND, DOCLN, SEGMENT, PSEGMENT, PFKBER, HKTID, KSTAR, XLGCLR, TAXPS, PAYS_PROV, PAYS_TRAN, VDOCSTATUS, RE_BUKRS, RE_ACCOUNT, PGEBER, PGRANT_NBR, BUDGET_PD, PBUDGET_PD, PEROP_BEG, PEROP_END, FASTPAY, IGNR_IVREF, PRODPER FROM FUDT_VDOCBSEG

TOP ERP 6.0 | FUDT_VDOCBSEG COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
5	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
6	BUZID	Identification of the Line Item	char	1	0	Allow NULL?
7	AUGDT	Clearing Date	nvarchar	8	0	Allow NULL?
8	AUGCP	Clearing Entry Date	nvarchar	8	0	Allow NULL?
9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	Allow NULL?
10	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
11	KOART	Account Type	char	1	0	Allow NULL?
12	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
13	UMSKS	Special G/L Transaction Type	char	1	0	Allow NULL?
14	ZUMSK	Target Special G/L Indicator	char	1	0	Allow NULL?
15	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
16	GSBER	Business Area	nvarchar	4	0	Allow NULL?
17	PARGB	Trading partner's business area	nvarchar	4	0	Allow NULL?
18	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
19	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
20	DMBTR	Amount in Local Currency	decimal	13	2
21	WRBTR	Amount in document currency	decimal	13	2
22	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2
23	PSWBT	Amount for Updating in General Ledger	decimal	13	2
24	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
25	TXBHW	Original Tax Base Amount in Local Currency	decimal	13	2
26	TXBFW	Original Tax Base Amount in Document Currency	decimal	13	2
27	MWSTS	Tax Amount in Local Currency	decimal	13	2
28	WMWST	Tax amount in document currency	decimal	13	2
29	HWBAS	Tax Base Amount in Local Currency	decimal	13	2
30	FWBAS	Tax Base Amount in Document Currency	decimal	13	2
31	HWZUZ	Provision Amount in Local Currency	decimal	13	2
32	FWZUZ	Additional Tax in Document Currency	decimal	13	2
33	SHZUZ	Debit/Credit Addition for Cash Discount	char	1	0	Allow NULL?
34	STEKZ	Version Number Component	nvarchar	2	0	Allow NULL?
35	MWART	Tax Type	char	1	0	Allow NULL?
36	TXGRP	Group Indicator for Tax Line Items	nvarchar	3	0	Allow NULL?
37	KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
38	QSSHB	Withholding Tax Base Amount	decimal	13	2
39	KURSR	Hedged Exchange Rate	decimal	9	5
40	GBETR	Hedged Amount in Foreign Currency	decimal	13	2
41	BDIFF	Valuation Difference	decimal	13	2
42	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2
43	VALUT	Value date	nvarchar	8	0	Allow NULL?
44	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
45	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
46	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
47	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
48	BEWAR	Transaction Type	nvarchar	3	0	Allow NULL?
49	ALTKT	Group account number	nvarchar	10	0	Allow NULL?
50	VORGN	Transaction Type for General Ledger	nvarchar	4	0	Allow NULL?
51	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
52	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
53	FDWBT	Planning amount in document currency	decimal	13	2
54	FDTAG	Planning date	nvarchar	8	0	Allow NULL?
55	FKONT	Financial Budget Item	nvarchar	3	0	Allow NULL?
56	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
57	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
58	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
59	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
60	VBELN	Billing Document	nvarchar	10	0	Allow NULL?
61	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
62	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
63	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
64	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
65	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
66	ANBWA	Asset Transaction Type	nvarchar	3	0	Allow NULL?
67	BZDAT	Asset value date	nvarchar	8	0	Allow NULL?
68	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
69	XUMSW	Indicator: Sales-related item ?	char	1	0	Allow NULL?
70	XHRES	Indicator: Resident G/L account?	char	1	0	Allow NULL?
71	XKRES	Indicator: Can Line Items Be Displayed by Account?	char	1	0	Allow NULL?
72	XOPVW	Indicator: Open Item Management?	char	1	0	Allow NULL?
73	XCPDD	Indicator: Address and bank data set individually	char	1	0	Allow NULL?
74	XSKST	Indicator: Statistical posting to cost center	char	1	0	Allow NULL?
75	XSAUF	Indicator: Posting to order is statistical	char	1	0	Allow NULL?
76	XSPRO	Indicator: Posting to project is statistical	char	1	0	Allow NULL?
77	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	Allow NULL?
78	XFAKT	Indicator: Billing document update successful ?	char	1	0	Allow NULL?
79	XUMAN	Indicator: Transfer posting from down payment ?	char	1	0	Allow NULL?
80	XANET	Indicator: Down payment in net procedure ?	char	1	0	Allow NULL?
81	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	Allow NULL?
82	XINVE	Indicator: Capital Goods Affected?	char	1	0	Allow NULL?
83	XPANZ	Display item	char	1	0	Allow NULL?
84	XAUTO	Indicator: Line item automatically created	char	1	0	Allow NULL?
85	XNCOP	Indicator: Items cannot be copied?	char	1	0	Allow NULL?
86	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	Allow NULL?
87	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
88	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
89	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
90	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
91	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
92	XBILK	Indicator: Account is a balance sheet account?	char	1	0	Allow NULL?
93	GVTYP	P&L statement account type	nvarchar	2	0	Allow NULL?
94	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	Allow NULL?
95	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
96	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
97	ZBD1T	Cash discount days 1	decimal	3	0
98	ZBD2T	Cash discount days 2	decimal	3	0
99	ZBD3T	Net Payment Terms Period	decimal	3	0
100	ZBD1P	Cash Discount Percentage 1	decimal	5	3
101	ZBD2P	Cash Discount Percentage 2	decimal	5	3
102	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2
103	SKNTO	Cash discount amount in local currency	decimal	13	2
104	WSKTO	Cash discount amount in document currency	decimal	13	2
105	ZLSCH	Payment Method	char	1	0	Allow NULL?
106	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
107	ZBFIX	Fixed Payment Terms	char	1	0	Allow NULL?
108	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
109	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
110	NEBTR	Net Payment Amount	decimal	13	2
111	MWSK1	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
112	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2
113	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2
114	MWSK2	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
115	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2
116	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2
117	MWSK3	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
118	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2
119	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2
120	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
121	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
122	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
123	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
124	ZOLLT	Customs Tariff Number	nvarchar	8	0	Allow NULL?
125	ZOLLD	Customs Date	nvarchar	8	0	Allow NULL?
126	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
127	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
128	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	Allow NULL?
129	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
130	ABPER	Settlement period	nvarchar	6	0	Allow NULL?
131	VRSKZ	Insurance indicator	char	1	0	Allow NULL?
132	VRSDT	Insurance date	nvarchar	8	0	Allow NULL?
133	DISBN	Number of Bill of Exchange Usage Document (Discount Doc.)	nvarchar	10	0	Allow NULL?
134	DISBJ	Fiscal Year of Bill of Exchange Usage Document	nvarchar	4	0	Allow NULL?
135	DISBZ	Line Item within the Bill of Exchange Usage Document	nvarchar	3	0	Allow NULL?
136	WVERW	Bill of exchange usage type	char	1	0	Allow NULL?
137	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	Allow NULL?
138	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	Allow NULL?
139	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	Allow NULL?
140	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	Allow NULL?
141	BLNBT	Base Amount for Determining the Preference Amount	decimal	13	2
142	BLNKZ	Subsidy indicator for determining the reduction rates	nvarchar	2	0	Allow NULL?
143	BLNPZ	Preference Percentage Rate	decimal	7	2
144	MSCHL	Dunning key	char	1	0	Allow NULL?
145	MANSP	Dunning block	char	1	0	Allow NULL?
146	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
147	MANST	Dunning level	char	1	0	Allow NULL?
148	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
149	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
150	ESRRE	ISR Reference Number	nvarchar	27	0	Allow NULL?
151	ESRPZ	ISR Check Digit	nvarchar	2	0	Allow NULL?
152	KLIBT	Credit Control Amount	decimal	13	2
153	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	Allow NULL?
154	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2
155	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2
156	NAVHW	Non-Deductible Input Tax (in Local Currency)	decimal	13	2
157	NAVFW	Non-Deductible Input Tax (in Document Currency)	decimal	13	2
158	MATNR	Material Number	nvarchar	18	0	Allow NULL?
159	WERKS	Plant	nvarchar	4	0	Allow NULL?
160	MENGE	Quantity	decimal	13	3
161	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
162	ERFMG	Quantity in Unit of Entry	decimal	13	3
163	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
164	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3
165	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
166	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
167	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
168	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
169	ELIKZ	"Delivery Completed" Indicator	char	1	0	Allow NULL?
170	VPRSV	Price control indicator	char	1	0	Allow NULL?
171	PEINH	Price Unit	decimal	5	0
172	BWKEY	Valuation Area	nvarchar	4	0	Allow NULL?
173	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
174	BUSTW	Posting string for values	nvarchar	4	0	Allow NULL?
175	REWRT	Invoice Value Entered (in Local Currency)	decimal	13	2
176	REWWR	Invoice value in foreign currency	decimal	13	2
177	BONFB	Amount Qualifying for Bonus in Local Currency	decimal	13	2
178	BUALT	Amount posted in alternative price control	decimal	13	2
179	PSALT	Alternative Price Control	char	1	0	Allow NULL?
180	NPREI	New price	decimal	11	2
181	TBTKZ	Indicator: subsequent debit/credit	char	1	0	Allow NULL?
182	SPGRP	Blocking reason: price	char	1	0	Allow NULL?
183	SPGRM	Blocking reason: quantity	char	1	0	Allow NULL?
184	SPGRT	Blocking Reason: Date	char	1	0	Allow NULL?
185	SPGRG	Blocking reason: order price quantity	char	1	0	Allow NULL?
186	SPGRV	Blocking reason: project budget	char	1	0	Allow NULL?
187	SPGRQ	Manual Blocking Reason	char	1	0	Allow NULL?
188	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
189	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	Allow NULL?
190	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	Allow NULL?
191	RSTGR	Reason Code for Payments	nvarchar	3	0	Allow NULL?
192	RYACQ	Year of acquisition	nvarchar	4	0	Allow NULL?
193	RPACQ	Period of Acquisition	nvarchar	3	0	Allow NULL?
194	RDIFF	Exchange Rate Gain/Loss Realized	decimal	13	2
195	RDIF2	Exchange Rate Difference Realized for Second Local Currency	decimal	13	2
196	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
197	XHKOM	Indicator: G/L account assigned manually ?	char	1	0	Allow NULL?
198	VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
199	RECID	Recovery Indicator	nvarchar	2	0	Allow NULL?
200	EGRUP	Equity group	nvarchar	3	0	Allow NULL?
201	VPTNR	Partner account number	nvarchar	10	0	Allow NULL?
202	VERTT	Contract Type	char	1	0	Allow NULL?
203	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
204	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
205	DEPOT	Securities Account	nvarchar	10	0	Allow NULL?
206	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
207	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
208	DABRZ	Reference Date for Settlement	nvarchar	8	0	Allow NULL?
209	POPTS	Real estate option rate	decimal	9	6
210	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
211	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
212	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
213	AUFPL	Task list number for operations in order	nvarchar	10	0	Allow NULL?
214	APLZL	General counter for order	nvarchar	8	0	Allow NULL?
215	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
216	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
217	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	Allow NULL?
218	SPGRS	Blocking Reason: Item Amount	char	1	0	Allow NULL?
219	SPGRC	Block.reason: quality	char	1	0	Allow NULL?
220	BTYPE	Payroll Type	nvarchar	2	0	Allow NULL?
221	ETYPE	Equity type	nvarchar	3	0	Allow NULL?
222	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	Allow NULL?
223	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	Allow NULL?
224	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
225	DMBE2	Amount in Second Local Currency	decimal	13	2
226	DMBE3	Amount in Third Local Currency	decimal	13	2
227	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
228	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
229	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
230	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
231	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
232	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
233	MWST2	Tax Amount in Second Local Currency	decimal	13	2
234	MWST3	Tax Amount in Third Local Currency	decimal	13	2
235	NAVH2	Non-Deductible Input Tax in Second Local Currency	decimal	13	2
236	NAVH3	Non-Deductible Input Tax in Third Local Currency	decimal	13	2
237	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2
238	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2
239	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2
240	RDIF3	Exchange Rate Difference Realized for Third Local Currency	decimal	13	2
241	HWMET	Method with Which the Local Currency Amount Was Determined	char	1	0	Allow NULL?
242	GLUPM	Update Method for FM - FI-CA Integration	char	1	0	Allow NULL?
243	XRAGL	Indicator: Clearing was Reversed	char	1	0	Allow NULL?
244	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
245	LOKKT	Alternative account number in company code	nvarchar	10	0	Allow NULL?
246	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
247	GEBER	Fund	nvarchar	10	0	Allow NULL?
248	STBUK	Tax Company Code	nvarchar	4	0	Allow NULL?
249	TXBH2	Tax Base/Original Tax Base in Second Local Currency	decimal	13	2
250	TXBH3	Tax Base/Original Tax Base in Third Local Currency	decimal	13	2
251	PPRCT	Partner Profit Center	nvarchar	10	0	Allow NULL?
252	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
253	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
254	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
255	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
256	STTAX	Tax amount as statistical information in document currency	decimal	13	2
257	FKBER	Functional Area	nvarchar	4	0	Allow NULL?
258	OBZEI	Number of Line Item in Original Document	nvarchar	3	0	Allow NULL?
259	XNEGP	Indicator: Negative posting	char	1	0	Allow NULL?
260	RFZEI	Payment Card Item	nvarchar	3	0	Allow NULL?
261	CCBTC	Payment cards: Settlement run	nvarchar	10	0	Allow NULL?
262	KKBER	Credit control area	nvarchar	4	0	Allow NULL?
263	EMPFB	Payee/Payer	nvarchar	10	0	Allow NULL?
264	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
265	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
266	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
267	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
268	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
269	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	Allow NULL?
270	GRIRG	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
271	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	Allow NULL?
272	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	Allow NULL?
273	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
274	ABSBT	Credit management: Hedged amount	decimal	13	2
275	IDXSP	Inflation Index	nvarchar	5	0	Allow NULL?
276	LINFV	Last Adjustment Date	nvarchar	8	0	Allow NULL?
277	KONTT	Account Assignment Category for Industry Solution	nvarchar	2	0	Allow NULL?
278	KONTL	Acct assignment string for industry-specific acct assignmnts	nvarchar	50	0	Allow NULL?
279	TXDAT	Date for defining tax rates	nvarchar	8	0	Allow NULL?
280	AGZEI	Clearing Item	decimal	5	0
281	PYCUR	Currency for Automatic Payment	nvarchar	5	0	Allow NULL?
282	PYAMT	Amount in Payment Currency	decimal	13	2
283	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
284	SECCO	Section Code	nvarchar	4	0	Allow NULL?
285	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
286	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	Allow NULL?
287	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
288	PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	decimal	13	2
289	PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	decimal	13	2
290	PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	decimal	13	2
291	PENLC1	Penalty charge amount in first local currency	decimal	13	2
292	PENLC2	Penalty charge amount in second local currency	decimal	13	2
293	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2
294	PENFC	Penalty charge amount in document currency	decimal	13	2
295	PENDAYS	Number of days for penalty charge calculation	int	10	0	Allow NULL?
296	PENRC	Reason for late payment	nvarchar	2	0	Allow NULL?
297	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
298	SCTAX	Tax portion FI-CA local currency	decimal	13	2
299	FKBER_LONG	Functional Area	nvarchar	16	0	Allow NULL?
300	GMVKZ	Item is in Execution	char	1	0	Allow NULL?
301	SRTYPE	Type of Additional Receivable	nvarchar	2	0	Allow NULL?
302	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
303	MEASURE	Funded Program	nvarchar	24	0	Allow NULL?
304	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	Allow NULL?
305	PPA_EX_IND	PPA Exclude Indicator	char	1	0	Allow NULL?
306	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0	Allow NULL?
307	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
308	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
309	PFKBER	Partner Functional Area	nvarchar	16	0	Allow NULL?
310	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
311	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
312	XLGCLR	Clearing Specific to Ledger Groups	char	1	0	Allow NULL?
313	TAXPS	Tax document item number	nvarchar	6	0	Allow NULL?
314	PAYS_PROV	Payment Service Provider	nvarchar	4	0	Allow NULL?
315	PAYS_TRAN	Payment Reference of Payment Service Provider	nvarchar	35	0	Allow NULL?
316	VDOCSTATUS	FI Document Verification Status	char	1	0	Allow NULL?
317	RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	nvarchar	4	0	Allow NULL?
318	RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	nvarchar	10	0	Allow NULL?
319	PGEBER	Partner Fund	nvarchar	10	0	Allow NULL?
320	PGRANT_NBR	Partner Grant	nvarchar	20	0	Allow NULL?
321	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
322	PBUDGET_PD	FM: Partner Budget Period	nvarchar	10	0	Allow NULL?
323	PEROP_BEG	Billing Period of Performance Start Date	nvarchar	8	0	Allow NULL?
324	PEROP_END	Billing Period of Performance End Date	nvarchar	8	0	Allow NULL?
325	FASTPAY	PPA Fast Pay Indicator	char	1	0	Allow NULL?
326	IGNR_IVREF	FMFG: Ignore the invoice reference during FI doc splitting	char	1	0	Allow NULL?
327	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	Allow NULL?

TOP ERP 6.0 | FUDT_VDOCBSEG INDEXES

Name	Primary	Unique	Type	Columns
FUDT_VDOCBSEG~0	Yes	Yes	CLUSTERED	BUZEI, GJAHR, BELNR, BUKRS, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

327 COLUMNS | 1 INDEXES | ERP 6.0 | FUDT_VDOCBSEG TABLE

TOP ERP 6.0 | FUDT_VDOCBSEG COLUMNS

TOP ERP 6.0 | FUDT_VDOCBSEG INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

327 COLUMNS | 1 INDEXES | ERP 6.0 | FUDT_VDOCBSEG TABLE

TOPERP 6.0 | FUDT_VDOCBSEG COLUMNS

TOPERP 6.0 | FUDT_VDOCBSEG INDEXES

TOP ERP 6.0 | FUDT_VDOCBSEG COLUMNS

TOP ERP 6.0 | FUDT_VDOCBSEG INDEXES