	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

204 COLUMNS | 2 INDEXES | ERP 6.0 | VVBAP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components
1	ERP EHP7	6.0	VVBAP	204	2	Sales Document: Item Data	Cross-Application Components

SQL: selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, MATNR, MATWA, PMATN, CHARG, MATKL, ARKTX, PSTYV, POSAR, LFREL, FKREL, UEPOS, GRPOS, ABGRU, PRODH, ZWERT, ZMENG, ZIEME, UMZIZ, UMZIN, MEINS, SMENG, ABLFZ, ABDAT, ABSFZ, POSEX, KDMAT, KBVER, KEVER, VKGRU, VKAUS, GRKOR, FMENG, UEBTK, UEBTO, UNTTO, FAKSP, ATPKZ, RKFKF, SPART, GSBER, NETWR, WAERK, ANTLF, KZTLF, CHSPL, KWMENG, LSMENG, KBMENG, KLMENG, VRKME, UMVKZ, UMVKN, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, VBELV, POSNV, VGBEL, VGPOS, VOREF, UPFLU, ERLRE, LPRIO, WERKS, LGORT, VSTEL, ROUTE, STKEY, STDAT, STLNR, STPOS, AWAHR, ERDAT, ERNAM, ERZET, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, VBEAF, VBEAV, VGREF, NETPR, KPEIN, KMEIN, SHKZG, SKTOF, MTVFP, SUMBD, KONDM, KTGRM, BONUS, PROVG, EANNR, PRSOK, BWTAR, BWTEX, XCHPF, XCHAR, LFMNG, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, STCUR, AEDAT, EAN11, FIXMG, PRCTR, MVGR1, MVGR2, MVGR3, MVGR4, MVGR5, KMPMG, SUGRD, SOBKZ, VPZUO, PAOBJNR, PS_PSP_PNR, AUFNR, VPMAT, VPWRK, PRBME, UMREF, KNTTP, KZVBR, SERNR, OBJNR, ABGRS, BEDAE, CMPRE, CMTFG, CMPNT, CMKUA, CUOBJ, CUOBJ_CH, CEPOK, KOUPD, SERAIL, ANZSN, NACHL, MAGRV, MPROK, VGTYP, PROSA, UEPVW, KALNR, KLVAR, SPOSN, KOWRR, STADAT, EXART, PREFE, KNUMH, CLINT, CHMVS, STLTY, STLKN, STPOZ, STMAN, ZSCHL_K, KALSM_K, KALVAR, KOSCH, UPMAT, UKONM, MFRGR, PLAVO, KANNR, CMPRE_FLT, ABFOR, ABGES, J_1BCFOP, J_1BTAXLW1, J_1BTAXLW2, J_1BTXSDC, WKTNR, WKTPS, SKOPF, KZBWS, WGRU1, WGRU2, KNUMA_PI, KNUMA_AG, KZFME, LSTANR, TECHS, MWSBP, BERID FROM VVBAP

TOP ERP 6.0 | VVBAP COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	VBELN	Sales Document	nvarchar	10	0	CHAR	(N' ')	No	VBUK	VBELN_VA	Allow NULL?
3	POSNR	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	No	VBUP	POSNR_VA	Allow NULL?
4	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
5	MATWA	Material entered	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATWA	Allow NULL?
6	PMATN	Pricing Reference Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PMATN	Allow NULL?
7	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	CHARG_D	Allow NULL?
8	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
9	ARKTX	Short text for sales order item	nvarchar	40	0	CHAR	(N' ')	Yes		ARKTX	Allow NULL?
10	PSTYV	Sales document item category	nvarchar	4	0	CHAR	(N' ')	Yes	TVPT	PSTYV	Allow NULL?
11	POSAR	Item type	char	1	0	CHAR	(N' ')	Yes		POSAR	Allow NULL?
12	LFREL	Item is relevant for delivery	char	1	0	CHAR	(N' ')	Yes		LFREL_AP	Allow NULL?
13	FKREL	Relevant for Billing	char	1	0	CHAR	(N' ')	Yes		FKREL	Allow NULL?
14	UEPOS	Higher-level item in bill of material structures	nvarchar	6	0	NUMC	(N'000000')	Yes	*	UEPOS	Allow NULL?
15	GRPOS	Item for which this item is an alternative	nvarchar	6	0	NUMC	(N'000000')	Yes		GRPOS	Allow NULL?
16	ABGRU	Reason for rejection of quotations and sales orders	nvarchar	2	0	CHAR	(N' ')	Yes	TVAG	ABGRU_VA	Allow NULL?
17	PRODH	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
18	ZWERT	Target Value for Outline Agreement in Document Currency	decimal	13	2	CURR	((0))	Yes		DZWERT
19	ZMENG	Target quantity in sales units	decimal	13	3	QUAN	((0))	Yes		DZMENG
20	ZIEME	Target quantity UoM	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZIEME	Allow NULL?
21	UMZIZ	Factor for converting sales units to base units (target qty)	decimal	5	0	DEC	((0))	Yes		UMZIZ
22	UMZIN	Factor for converting sales units to base units (target qty)	decimal	5	0	DEC	((0))	Yes		UMZIN
23	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
24	SMENG	Scale quantity in base unit of measure	decimal	13	3	QUAN	((0))	Yes		SMENG
25	ABLFZ	Rounding quantity for delivery	decimal	13	3	QUAN	((0))	Yes		ABLFZ
26	ABDAT	Reconciliation Date for Agreed Cumulative Quantity	nvarchar	8	0	DATS	(N'00000000')	Yes		ABDAT	Allow NULL?
27	ABSFZ	Allowed deviation in quantity (absolute)	decimal	13	3	QUAN	((0))	Yes		ABSFZ
28	POSEX	Item Number of the Underlying Purchase Order	nvarchar	6	0	CHAR	(N' ')	Yes		POSEX	Allow NULL?
29	KDMAT	Material Number Used by Customer	nvarchar	35	0	CHAR	(N' ')	Yes		MATNR_KU	Allow NULL?
30	KBVER	Allowed deviation in quantity (in percent)	decimal	3	0	DEC	((0))	Yes		KBVER
31	KEVER	Days by which the quantity can be shifted	decimal	3	0	DEC	((0))	Yes		KEVER
32	VKGRU	Repair Processing: Classification of Items	nvarchar	3	0	CHAR	(N' ')	Yes	TVRMAVK	VKGRU	Allow NULL?
33	VKAUS	Usage Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	TVLV	ABRVW	Allow NULL?
34	GRKOR	Delivery group (items are delivered together)	nvarchar	3	0	NUMC	(N'000')	Yes		GRKOR	Allow NULL?
35	FMENG	Quantity is Fixed	char	1	0	CHAR	(N' ')	Yes		FMENG	Allow NULL?
36	UEBTK	Unlimited overdelivery allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK_V	Allow NULL?
37	UEBTO	Overdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UEBTO
38	UNTTO	Underdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UNTTO
39	FAKSP	Billing block for item	nvarchar	2	0	CHAR	(N' ')	Yes	TVFS	FAKSP_AP	Allow NULL?
40	ATPKZ	Replacement part	char	1	0	CHAR	(N' ')	Yes		ATPKZ	Allow NULL?
41	RKFKF	Method of billing for CO/PPC orders	char	1	0	CHAR	(N' ')	Yes		RKFKF	Allow NULL?
42	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
43	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
44	NETWR	Net value of the order item in document currency	decimal	15	2	CURR	((0))	Yes		NETWR_AP
45	WAERK	SD Document Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERK	Allow NULL?
46	ANTLF	Maximum Number of Partial Deliveries Allowed Per Item	decimal	1	0	DEC	((0))	Yes		ANTLF
47	KZTLF	Partial delivery at item level	char	1	0	CHAR	(N' ')	Yes		KZTLF	Allow NULL?
48	CHSPL	Batch split allowed	char	1	0	CHAR	(N' ')	Yes		CHSPL	Allow NULL?
49	KWMENG	Cumulative Order Quantity in Sales Units	decimal	15	3	QUAN	((0))	Yes		KWMENG
50	LSMENG	Cumulative required delivery qty (all dlv-relev.sched.lines)	decimal	15	3	QUAN	((0))	Yes		LSMENG
51	KBMENG	Cumulative confirmed quantity in sales unit	decimal	15	3	QUAN	((0))	Yes		KBMENG
52	KLMENG	Cumulative confirmed quantity in base unit	decimal	15	3	QUAN	((0))	Yes		KLMENG
53	VRKME	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VRKME	Allow NULL?
54	UMVKZ	Numerator (factor) for conversion of sales quantity into SKU	decimal	5	0	DEC	((0))	Yes		UMVKZ
55	UMVKN	Denominator (Divisor) for Conversion of Sales Qty into SKU	decimal	5	0	DEC	((0))	Yes		UMVKN
56	BRGEW	Gross Weight of the Item	decimal	15	3	QUAN	((0))	Yes		BRGEW_AP
57	NTGEW	Net Weight of the Item	decimal	15	3	QUAN	((0))	Yes		NTGEW_AP
58	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
59	VOLUM	Volume of the item	decimal	15	3	QUAN	((0))	Yes		VOLUM_AP
60	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
61	VBELV	Originating document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELV	Allow NULL?
62	POSNV	Originating item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNV	Allow NULL?
63	VGBEL	Document number of the reference document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VGBEL	Allow NULL?
64	VGPOS	Item number of the reference item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	VGPOS	Allow NULL?
65	VOREF	Complete reference indicator	char	1	0	CHAR	(N' ')	Yes		VOREF	Allow NULL?
66	UPFLU	Update indicator for sales document document flow	char	1	0	CHAR	(N' ')	Yes		UPFLV	Allow NULL?
67	ERLRE	Completion rule for quotation / contract	char	1	0	CHAR	(N' ')	Yes		ERLRE	Allow NULL?
68	LPRIO	Delivery Priority	nvarchar	2	0	NUMC	(N'00')	Yes	TPRIO	LPRIO	Allow NULL?
69	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
70	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
71	VSTEL	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	TVST	VSTEL	Allow NULL?
72	ROUTE	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
73	STKEY	Origin of the bill of material	char	1	0	CHAR	(N' ')	Yes		STKEY	Allow NULL?
74	STDAT	Key date of the bill of material	nvarchar	8	0	DATS	(N'00000000')	Yes		STDAT	Allow NULL?
75	STLNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
76	STPOS	Bill of material item number VBAP not used	decimal	5	0	DEC	((0))	Yes		STPOS_VBAP
77	AWAHR	Order probability of the item	nvarchar	3	0	NUMC	(N'000')	Yes		AWAHR	Allow NULL?
78	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
79	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
80	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
81	TAXM1	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
82	TAXM2	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
83	TAXM3	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
84	TAXM4	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
85	TAXM5	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
86	TAXM6	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
87	TAXM7	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
88	TAXM8	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
89	TAXM9	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
90	VBEAF	Fixed shipping processing time in days (= setup time)	decimal	5	2	DEC	((0))	Yes		VBEAF
91	VBEAV	Variable shipping processing time in days	decimal	5	2	DEC	((0))	Yes		VBEAV
92	VGREF	Preceding document has resulted from reference	char	1	0	CHAR	(N' ')	Yes		VGREF	Allow NULL?
93	NETPR	Net price	decimal	11	2	CURR	((0))	Yes		NETPR
94	KPEIN	Condition pricing unit	decimal	5	0	DEC	((0))	Yes		KPEIN
95	KMEIN	Condition unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	KMEIN	Allow NULL?
96	SHKZG	Returns Item	char	1	0	CHAR	(N' ')	Yes		SHKZG_VA	Allow NULL?
97	SKTOF	Cash discount indicator	char	1	0	CHAR	(N' ')	Yes		SKTOF	Allow NULL?
98	MTVFP	Checking Group for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	TMVF	MTVFP	Allow NULL?
99	SUMBD	Summing up of requirements	char	1	0	CHAR	(N' ')	Yes		SUMBD	Allow NULL?
100	KONDM	Material Pricing Group	nvarchar	2	0	CHAR	(N' ')	Yes	T178	KONDM	Allow NULL?
101	KTGRM	Account assignment group for this material	nvarchar	2	0	CHAR	(N' ')	Yes	TVKM	KTGRM	Allow NULL?
102	BONUS	Volume rebate group	nvarchar	2	0	CHAR	(N' ')	Yes	TVBO	BONUS	Allow NULL?
103	PROVG	Commission group	nvarchar	2	0	CHAR	(N' ')	Yes	TVPR	PROVG	Allow NULL?
104	EANNR	European Article Number (EAN) - obsolete!!!!!	nvarchar	13	0	CHAR	(N' ')	Yes		EANNR	Allow NULL?
105	PRSOK	Pricing is OK	char	1	0	CHAR	(N' ')	Yes		PRSOK	Allow NULL?
106	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
107	BWTEX	Indicator: Separate valuation	char	1	0	CHAR	(N' ')	Yes		BWTEX	Allow NULL?
108	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
109	XCHAR	Batch management indicator (internal)	char	1	0	CHAR	(N' ')	Yes		XCHAR	Allow NULL?
110	LFMNG	Minimum delivery quantity in delivery note processing	decimal	13	3	QUAN	((0))	Yes		MINLF
111	STAFO	Update group for statistics update	nvarchar	6	0	CHAR	(N' ')	Yes	*	STAFO	Allow NULL?
112	WAVWR	Cost in document currency	decimal	13	2	CURR	((0))	Yes		WAVWR
113	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
114	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
115	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
116	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
117	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
118	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
119	STCUR	Exchange rate for statistics (Exch.rate at time of creation)	decimal	9	5	DEC	((0))	Yes		STCUR_AP
120	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
121	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
122	FIXMG	Delivery date and quantity fixed	char	1	0	CHAR	(N' ')	Yes		FIXMG	Allow NULL?
123	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
124	MVGR1	Material group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVM1	MVGR1	Allow NULL?
125	MVGR2	Material group 2	nvarchar	3	0	CHAR	(N' ')	Yes	TVM2	MVGR2	Allow NULL?
126	MVGR3	Material group 3	nvarchar	3	0	CHAR	(N' ')	Yes	TVM3	MVGR3	Allow NULL?
127	MVGR4	Material group 4	nvarchar	3	0	CHAR	(N' ')	Yes	TVM4	MVGR4	Allow NULL?
128	MVGR5	Material group 5	nvarchar	3	0	CHAR	(N' ')	Yes	TVM5	MVGR5	Allow NULL?
129	KMPMG	Component quantity	decimal	13	3	QUAN	((0))	Yes		KMPMG
130	SUGRD	Reason for material substitution	nvarchar	4	0	CHAR	(N' ')	Yes	TVSU	SUGRD	Allow NULL?
131	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
132	VPZUO	Allocation Indicator	char	1	0	CHAR	(N' ')	Yes		VPZUO	Allow NULL?
133	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
134	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
135	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
136	VPMAT	Planning material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	VPMAT	Allow NULL?
137	VPWRK	Planning plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	VPWRK	Allow NULL?
138	PRBME	Base unit of measure for product group	nvarchar	3	0	UNIT	(N' ')	Yes	T006	PRBME	Allow NULL?
139	UMREF	Conversion factor: quantities	float	15	16	FLTP	((0))	Yes		UMREFF
140	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
141	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
142	SERNR	BOM explosion number	nvarchar	8	0	CHAR	(N' ')	Yes	SNUM	SERNR	Allow NULL?
143	OBJNR	Object number at item level	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	OBJPO	Allow NULL?
144	ABGRS	Results Analysis Key	nvarchar	6	0	CHAR	(N' ')	Yes	TKKAA	ABGR_SCHL	Allow NULL?
145	BEDAE	Requirements type	nvarchar	4	0	CHAR	(N' ')	Yes	T459A	BEDAE	Allow NULL?
146	CMPRE	Item credit price	decimal	11	2	CURR	((0))	Yes		CMPRE
147	CMTFG	ID for partial release of order item, credit block	char	1	0	CHAR	(N' ')	Yes		CMTFG	Allow NULL?
148	CMPNT	ID: Item with active credit function / relevant for credit	char	1	0	CHAR	(N' ')	Yes		CMPNT	Allow NULL?
149	CMKUA	Credit data exchange rate for requested delivery date	decimal	9	5	DEC	((0))	Yes		CMKUA
150	CUOBJ	Configuration	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_VA	Allow NULL?
151	CUOBJ_CH	Internal object number of the batch classification	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_CH	Allow NULL?
152	CEPOK	Status expected price	char	1	0	CHAR	(N' ')	Yes		CEPOK	Allow NULL?
153	KOUPD	Condition update	char	1	0	CHAR	(N' ')	Yes		KOUPD	Allow NULL?
154	SERAIL	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	T377P	SERAIL	Allow NULL?
155	ANZSN	Number of serial numbers	int	10	0	INT4	((0))	Yes		ANZSN	Allow NULL?
156	NACHL	Customer has not posted goods receipt	char	1	0	CHAR	(N' ')	Yes		NACHL	Allow NULL?
157	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	CHAR	(N' ')	Yes	TVEGR	MAGRV	Allow NULL?
158	MPROK	Status manual price change	char	1	0	CHAR	(N' ')	Yes		MPROK	Allow NULL?
159	VGTYP	Document category of preceding SD document	char	1	0	CHAR	(N' ')	Yes		VBTYP_V	Allow NULL?
160	PROSA	ID for material determination	char	1	0	CHAR	(N' ')	Yes		PROSA	Allow NULL?
161	UEPVW	ID for higher-level item usage	char	1	0	CHAR	(N' ')	Yes		UEPVW	Allow NULL?
162	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR	Allow NULL?
163	KLVAR	Costing Variant	nvarchar	4	0	CHAR	(N' ')	Yes	*	CK_KLVAR	Allow NULL?
164	SPOSN	BOM Item Number	nvarchar	4	0	CHAR	(N' ')	Yes		SPOSN	Allow NULL?
165	KOWRR	Statistical values	char	1	0	CHAR	(N' ')	Yes		KOWRR	Allow NULL?
166	STADAT	Statistics date	nvarchar	8	0	DATS	(N'00000000')	Yes		STADAT	Allow NULL?
167	EXART	Business Transaction Type for Foreign Trade	nvarchar	2	0	CHAR	(N' ')	Yes	T605	EXART	Allow NULL?
168	PREFE	Preference indicator in export/import	char	1	0	CHAR	(N' ')	Yes		PREFE	Allow NULL?
169	KNUMH	Number of condition record from batch determination	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMH_CH	Allow NULL?
170	CLINT	Internal Class Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	KLAH	CLINT	Allow NULL?
171	CHMVS	Batches: Exit to quantity proposal	nvarchar	3	0	NUMC	(N'000')	Yes		CHMVS	Allow NULL?
172	STLTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
173	STLKN	BOM item node number	nvarchar	8	0	NUMC	(N'00000000')	Yes		STLKN	Allow NULL?
174	STPOZ	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
175	STMAN	Inconsistent configuration	char	1	0	CHAR	(N' ')	Yes		CUINK	Allow NULL?
176	ZSCHL_K	Overhead key	nvarchar	6	0	CHAR	(N' ')	Yes		AUFZSCHL	Allow NULL?
177	KALSM_K	Costing Sheet	nvarchar	6	0	CHAR	(N' ')	Yes	T683	AUFKALSM	Allow NULL?
178	KALVAR	Costing Variant	nvarchar	4	0	CHAR	(N' ')	Yes	TCK03	CK_KLVAR	Allow NULL?
179	KOSCH	Product allocation determination procedure	nvarchar	18	0	CHAR	(N' ')	Yes	T190S	KOSCH	Allow NULL?
180	UPMAT	Pricing reference material of main item	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	UPMAT	Allow NULL?
181	UKONM	Material pricing group of main item	nvarchar	2	0	CHAR	(N' ')	Yes	T178	UKONM	Allow NULL?
182	MFRGR	Material freight group	nvarchar	8	0	CHAR	(N' ')	Yes	TMFG	MFRGR	Allow NULL?
183	PLAVO	Planning delivery schedule instruction	nvarchar	4	0	CHAR	(N' ')	Yes	TVZP	PLAVO	Allow NULL?
184	KANNR	KANBAN/sequence number	nvarchar	35	0	CHAR	(N' ')	Yes		KANNR	Allow NULL?
185	CMPRE_FLT	Item credit price	float	15	16	FLTP	((0))	Yes		CMPRE_FLT
186	ABFOR	Form of payment guarantee	nvarchar	2	0	CHAR	(N' ')	Yes	T691K	ABSFORM_CM	Allow NULL?
187	ABGES	Guaranteed (factor between 0 and 1)	float	15	16	FLTP	((0))	Yes		ABGES_CM
188	J_1BCFOP	CFOP Code and Extension	nvarchar	10	0	CHAR	(N' ')	Yes	J_1BAG	J_1BCFOP	Allow NULL?
189	J_1BTAXLW1	Tax law: ICMS	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL1	J_1BTAXLW1	Allow NULL?
190	J_1BTAXLW2	Tax law: IPI	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL2	J_1BTAXLW2	Allow NULL?
191	J_1BTXSDC	SD tax code	nvarchar	2	0	CHAR	(N' ')	Yes	J_1BTXSDC	J_1BTXSDC_	Allow NULL?
192	WKTNR	Value contract no.	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	WKTNR	Allow NULL?
193	WKTPS	Value contract item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	WKTPS	Allow NULL?
194	SKOPF	Assortment module	nvarchar	18	0	CHAR	(N' ')	Yes	WSOH	W_SORTK	Allow NULL?
195	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
196	WGRU1	Material group hierarchy 1	nvarchar	18	0	CHAR	(N' ')	Yes		WGRU_HIE1	Allow NULL?
197	WGRU2	Material group hierarchy 2	nvarchar	18	0	CHAR	(N' ')	Yes		WGRU_HIE2	Allow NULL?
198	KNUMA_PI	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_PI	Allow NULL?
199	KNUMA_AG	Sales deal	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_AG	Allow NULL?
200	KZFME	ID: Leading unit of measure for completing a transaction	char	1	0	CHAR	(N' ')	Yes		KZFME	Allow NULL?
201	LSTANR	Free goods delivery control	char	1	0	CHAR	(N' ')	Yes		LSTANR	Allow NULL?
202	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
203	MWSBP	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		MWSBP
204	BERID	MRP Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	BERID	Allow NULL?

TOP ERP 6.0 | VVBAP INDEXES

Name	Primary	Unique	Type	Columns
VVBAP~0	Yes	Yes	CLUSTERED	MANDT, VBELN, POSNR
VVBAP~A	No	No	NONCLUSTERED	MANDT, ABGRU

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

204 COLUMNS | 2 INDEXES | ERP 6.0 | VVBAP TABLE

TOP ERP 6.0 | VVBAP COLUMNS

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

204 COLUMNS | 2 INDEXES | ERP 6.0 | VVBAP TABLE

TOPERP 6.0 | VVBAP COLUMNS

TOPERP 6.0 | VVBAP INDEXES

TOP ERP 6.0 | VVBAP COLUMNS

TOP ERP 6.0 | VVBAP INDEXES