	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

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

169 COLUMNS | 1 INDEXES | ERP 6.0 | VIAKBSEG TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management
1	ERP EHP7	6.0	VIAKBSEG	169	1	Document Line Item from SCS for Interface	Real Estate Management

SQL: selectupdate insert create

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

SELECT MANDTT, VVABBLN, BELEG, POS, JPOSTED, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, MANDT, MAPPE, IBELN, IBELZ, BUKRS, BELNR, BUZEI, SGTXT, SHKZG, UMSKZ, VALUT, ZUMSK, ZUONR, ZFBDT, BSCHL, WRBTR, DMBTR, WERKS, XCPDD, BVTYP, BWKEY, BWTAR, BZDAT, ANLN1, ANLN2, ANBWA, AUFNR, ABPER, MABER, MANSP, MSCHL, KOSTL, KUNNR, KURSR, MWSKZ, FILKD, FDTAG, FDGRP, FDLEV, HZUON, KOART, GSBER, HKONT, HBKID, DBKEY, KOMKZ, SAMKZ, BLART, REBZG, LIFNR, REGUL, CPD, NAME1, NAME2, NAME3, NAME4, STCD1, STCD2, PSTLZ, PSTL2, PSKTO, PFACH, ORT01, STRAS, STKZU, STKZA, REGIO, BKONT, BANKS, BANKN, BANKL, LAND1, EMPFG, DTAWS, DTAMS, MEINS, MENGE, IMMO, DABRZ, POPTS, SWENR, SGENR, SGRNR, SMENR, SNKSL, SEMPSL, BDAT, NABFW, ABZFW, SBERI, VERTT, VERTN, VBEWA, DEPOT, MWSTS, WMWST, ZLSCH, ZLSPR, PRCTR, SAMNR, IMKEY, RKLAMMER, FWBAS, AUGLINFO, AUGLZLSPR, REBZZ, REBZJ, SKFBT, XBLNR, PERNR, RVZBLG, ZTERM, ZINKZ, SVWNR, NEWBK, AUGDT, AUGCP, AUGBL, REBZT, INTRENO, MADAT, MANST, ZE_KUNNR, ZE_PARTNER, ZE_BVTYP, VBUND, XREF1, LZBKZ, LANDL, GJAHR, DFAELL, TXJCD, PRSDT, US_MWSKZ, US_WMWST, US_TXINT, US_TAXIT, US_KTOSL, US_FWBAS, UNKA_STAX, UNKA_KTOSL, UNKA_FWBAS, UNKA_KBETR, RE_AWTYP, RE_AWREF, RE_AWORG, RE_POSNR, RE_KSCHL, FCVAL, XREF1_HD, XREF2_HD, PS_PSP_PNR FROM VIAKBSEG

TOP ERP 6.0 | VIAKBSEG COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDTT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	VVABBLN	Settlement Identification ->Accounting Ref. Doc.Number	nvarchar	16	0	CHAR	(N' ')	No		VVABBLN1	Allow NULL?
3	BELEG	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
4	POS	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	No		BUZEI	Allow NULL?
5	JPOSTED	Indicator for document posted	char	1	0	CHAR	(N' ')	Yes		REJPOSTED	Allow NULL?
6	ZZSPREG	Special Region	nvarchar	5	0	CHAR	(N' ')	Yes	ZZSPREG	ZREGION	Allow NULL?
7	ZZBUSPARTN	Business partner	nvarchar	10	0	CHAR	(N' ')	Yes		ZZBUSPARTN	Allow NULL?
8	ZZPRODUCT	Product group	nvarchar	10	0	CHAR	(N' ')	Yes		ZZPRODUCT	Allow NULL?
9	ZZLOCA	City	nvarchar	4	0	CHAR	(N' ')	Yes		ZZLOCA	Allow NULL?
10	ZZCHAN	Distribution channel	nvarchar	4	0	CHAR	(N' ')	Yes		ZZCHAN	Allow NULL?
11	ZZLOB	BUSINESS LINE	nvarchar	7	0	CHAR	(N' ')	Yes	*	ZZLOB	Allow NULL?
12	ZZNFAL		nvarchar	10	0		(N' ')	Yes			Allow NULL?
13	ZZUSERFLD1	Territory	nvarchar	9	0	CHAR	(N' ')	Yes	ZFU1	ZZUSERFLD1	Allow NULL?
14	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	CHAR	(N' ')	Yes		ZZUSERFLD2	Allow NULL?
15	ZZUSERFLD3	Vein	nvarchar	22	0	CHAR	(N' ')	Yes		ZZUSERFLD3	Allow NULL?
16	ZZREGION	Location	nvarchar	3	0	CHAR	(N' ')	Yes	ZREG	ZZREGION	Allow NULL?
17	ZZSTATE	State/Province Code	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	ZZSTATE	Allow NULL?
18	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	Yes	*	MANDT	Allow NULL?
19	MAPPE	Group name: Batch input session name	nvarchar	12	0	CHAR	(N' ')	Yes		APQ_GRPN	Allow NULL?
20	IBELN	Internal doc.number	nvarchar	9	0	NUMC	(N'000000000')	Yes		VVIBELN	Allow NULL?
21	IBELZ	Internal doc.number	nvarchar	9	0	NUMC	(N'000000000')	Yes		VVIBELN	Allow NULL?
22	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
23	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
24	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
25	SGTXT	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
26	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
27	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	*	UMSKZ	Allow NULL?
28	VALUT	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
29	ZUMSK	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	*	UMSKZ	Allow NULL?
30	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
31	ZFBDT	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
32	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	*	BSCHL	Allow NULL?
33	WRBTR	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
34	DMBTR	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
35	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
36	XCPDD	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
37	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
38	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	BWKEY	Allow NULL?
39	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
40	BZDAT	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
41	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
42	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANLN2	Allow NULL?
43	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	BWASL	Allow NULL?
44	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
45	ABPER	Posting period in the form YYYYMM	nvarchar	6	0	ACCP	(N' ')	Yes		BUPER	Allow NULL?
46	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	*	MABER	Allow NULL?
47	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	*	MANSP	Allow NULL?
48	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	*	MSCHL	Allow NULL?
49	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
50	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
51	KURSR	Hedged Exchange Rate	decimal	9	5	DEC	((0))	Yes		KURSR
52	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
53	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
54	FDTAG	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
55	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	*	FDGRP	Allow NULL?
56	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	*	FDLEV	Allow NULL?
57	HZUON	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
58	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
59	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
60	HKONT	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
61	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	*	HBKID	Allow NULL?
62	DBKEY	Database key memory	nvarchar	60	0	CHAR	(N' ')	Yes		DBKEY	Allow NULL?
63	KOMKZ	Compression indicator per account symbol	char	1	0	CHAR	(N' ')	Yes		KOMPZ	Allow NULL?
64	SAMKZ	Mark item for collective purchase order	char	1	0	CHAR	(N' ')	Yes		SAMKZ	Allow NULL?
65	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	BLART	Allow NULL?
66	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
67	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
68	REGUL	Indicator: Individual Payee in Document	char	1	0	CHAR	(N' ')	Yes		REGUL	Allow NULL?
69	CPD	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
70	NAME1	Employee's last name	nvarchar	35	0	CHAR	(N' ')	Yes		NAME	Allow NULL?
71	NAME2	Employee's last name	nvarchar	35	0	CHAR	(N' ')	Yes		NAME	Allow NULL?
72	NAME3	Employee's last name	nvarchar	35	0	CHAR	(N' ')	Yes		NAME	Allow NULL?
73	NAME4	Employee's last name	nvarchar	35	0	CHAR	(N' ')	Yes		NAME	Allow NULL?
74	STCD1	Tax Number 1	nvarchar	16	0	CHAR	(N' ')	Yes		STCD1	Allow NULL?
75	STCD2	Tax Number 2	nvarchar	11	0	CHAR	(N' ')	Yes		STCD2	Allow NULL?
76	PSTLZ	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
77	PSTL2	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
78	PSKTO	Account Number of Bank Account At Post Office	nvarchar	16	0	CHAR	(N' ')	Yes		PSKTO	Allow NULL?
79	PFACH	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		PFACH	Allow NULL?
80	ORT01	Data Element Type CHAR Length 35	nvarchar	35	0	CHAR	(N' ')	Yes		CHAR35	Allow NULL?
81	STRAS	Data Element Type CHAR Length 35	nvarchar	35	0	CHAR	(N' ')	Yes		CHAR35	Allow NULL?
82	STKZU	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
83	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	CHAR	(N' ')	Yes		STKZA	Allow NULL?
84	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	*	REGIO	Allow NULL?
85	BKONT	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
86	BANKS	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
87	BANKN	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
88	BANKL	Bank number	nvarchar	15	0	CHAR	(N' ')	Yes		BANKL	Allow NULL?
89	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
90	EMPFG	Payee code	nvarchar	16	0	CHAR	(N' ')	Yes		EMPFG	Allow NULL?
91	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	*	DTAWS	Allow NULL?
92	DTAMS	Indicator for Data Medium Exchange	char	1	0	CHAR	(N' ')	Yes		DTAMS	Allow NULL?
93	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
94	MENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
95	IMMO	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
96	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
97	POPTS	Real estate option rate	decimal	9	6	DEC	((0))	Yes		POPTSATZ
98	SWENR	Site Number	nvarchar	8	0	CHAR	(N' ')	Yes	*	SWENR	Allow NULL?
99	SGENR	Building Number	nvarchar	8	0	CHAR	(N' ')	Yes	*	SGENR	Allow NULL?
100	SGRNR	Property Number for BE	nvarchar	8	0	CHAR	(N' ')	Yes	*	SGRNR	Allow NULL?
101	SMENR	Number of Rental Unit	nvarchar	8	0	CHAR	(N' ')	Yes	*	SMENR	Allow NULL?
102	SNKSL	Service Charge Key	nvarchar	4	0	CHAR	(N' ')	Yes	*	SNKSL	Allow NULL?
103	SEMPSL	Settlement Unit	nvarchar	5	0	CHAR	(N' ')	Yes	*	SEMPSL	Allow NULL?
104	BDAT	Reference date	nvarchar	8	0	DATS	(N'00000000')	Yes		BDAT	Allow NULL?
105	NABFW	Input tax amount cannot be deducted	decimal	13	2	CURR	((0))	Yes		NABFW
106	ABZFW	Deductible input tax amount	decimal	13	2	CURR	((0))	Yes		ABZFW
107	SBERI	Correction item number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SBERI	Allow NULL?
108	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
109	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
110	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
111	DEPOT	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	RLDEPO	Allow NULL?
112	MWSTS	Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MWSTS
113	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
114	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	DZLSCH	Allow NULL?
115	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	*	DZLSPR	Allow NULL?
116	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
117	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
118	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
119	RKLAMMER	Classification Number for Finance Projects	nvarchar	13	0	CHAR	(N' ')	Yes		RKLAMMER	Allow NULL?
120	FWBAS	Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		FWBAS
121	AUGLINFO	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
122	AUGLZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	*	DZLSPR	Allow NULL?
123	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
124	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
125	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
126	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
127	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
128	RVZBLG	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
129	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
130	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
131	SVWNR	Management Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes	*	VVSVWNR	Allow NULL?
132	NEWBK	Company Code for the Next Line Item	nvarchar	4	0	CHAR	(N' ')	Yes	*	NEWBK	Allow NULL?
133	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
134	AUGCP	Clearing Entry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGCP	Allow NULL?
135	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	Yes		AUGBL	Allow NULL?
136	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
137	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
138	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
139	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
140	ZE_KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
141	ZE_PARTNER	Partner number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SPARTNR	Allow NULL?
142	ZE_BVTYP	Bank type of alternative payer	nvarchar	4	0	CHAR	(N' ')	Yes		VVBVTYPABW	Allow NULL?
143	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	*	RASSC	Allow NULL?
144	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
145	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	*	LZBKZ	Allow NULL?
146	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	*	LANDL	Allow NULL?
147	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
148	DFAELL	Due date	nvarchar	8	0	DATS	(N'00000000')	Yes		DFAELL	Allow NULL?
149	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
150	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	DATS	(N'00000000')	Yes		PRSDT	Allow NULL?
151	US_MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
152	US_WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
153	US_TXINT	Indicator: tax item - RE internal entry	char	1	0	CHAR	(N' ')	Yes		VVTAXUSINT	Allow NULL?
154	US_TAXIT	Indicator: Tax Item	char	1	0	CHAR	(N' ')	Yes		TAXIT	Allow NULL?
155	US_KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL	Allow NULL?
156	US_FWBAS	Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		FWBAS
157	UNKA_STAX	Indicator: Tax item - internal entry RE (SCS)	char	1	0	CHAR	(N' ')	Yes		VVUNKATAX	Allow NULL?
158	UNKA_KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL	Allow NULL?
159	UNKA_FWBAS	Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		FWBAS
160	UNKA_KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2	CURR	((0))	Yes		KBETR_KOND
161	RE_AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	*	AWTYP	Allow NULL?
162	RE_AWREF	Reference Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		AWREF	Allow NULL?
163	RE_AWORG	Reference Organizational Units	nvarchar	10	0	CHAR	(N' ')	Yes		AWORG	Allow NULL?
164	RE_POSNR	Accounting Document Line Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		POSNR_ACC	Allow NULL?
165	RE_KSCHL	Condition Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	KSCHL	Allow NULL?
166	FCVAL	Indicator: Line Item Contains Foreign Currency Valuation	char	1	0	CHAR	(N' ')	Yes		FCVAL	Allow NULL?
167	XREF1_HD	Reference Key 1 Internal for Document Header	nvarchar	20	0	CHAR	(N' ')	Yes		XREF1_HD	Allow NULL?
168	XREF2_HD	Reference Key 2 Internal for Document Header	nvarchar	20	0	CHAR	(N' ')	Yes		XREF2_HD	Allow NULL?
169	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?

TOP ERP 6.0 | VIAKBSEG INDEXES

Name	Primary	Unique	Type	Columns
VIAKBSEG~0	Yes	Yes	CLUSTERED	MANDTT, VVABBLN, BELEG, POS

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

169 COLUMNS | 1 INDEXES | ERP 6.0 | VIAKBSEG TABLE

TOP ERP 6.0 | VIAKBSEG COLUMNS

TOP ERP 6.0 | VIAKBSEG 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

169 COLUMNS | 1 INDEXES | ERP 6.0 | VIAKBSEG TABLE

TOPERP 6.0 | VIAKBSEG COLUMNS

TOPERP 6.0 | VIAKBSEG INDEXES

TOP ERP 6.0 | VIAKBSEG COLUMNS

TOP ERP 6.0 | VIAKBSEG INDEXES