	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

355 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_VBAP TABLE

ERP EHP7

6.0

355

Sales Document: Item Data

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, PCTRF, LOGSYS_EXT, J_1BTAXLW3, J_1BTAXLW4, J_1BTAXLW5, STOCKLOC, SLOCTYPE, MSR_RET_REASON, MSR_REFUND_CODE, MSR_APPROV_BLOCK, NRAB_KNUMH, TRMRISK_RELEVANT, SGT_RCAT, HANDOVERLOC, HANDOVERDATE, HANDOVERTIME, Z_PRS_OFFSHORE, Z_PRS_BILL_FLAG, Z_PRS_COUNTRY, Z_PRS_CHARGELEVL, TC_AUT_DET, MANUAL_TC_REASON, FISCAL_INCENTIVE, TAX_SUBJECT_ST, FISCAL_INCENTIVE_ID, SPCSTO, /BEV1/SRFUND, CPD_UPDAT, AUFPL_OLC, APLZL_OLC, /XLSO/COURSE_ID, /XLSO/COURSE_BDA, /XLSO/COURSE_EDA, FERC_IND, KOSTL, FONDS, FISTL, FKBER, GRANT_NBR, BUDGET_PD, IUID_RELEVANT, MILL_SE_GPOSN, OID_EXTBOL, OID_MISCDL, OIPLANTD, OIBYPASS, OIEDOK, CMETH, OITAXFROM, OIHANTYP, OITAXGRP, OITAXTO, OICERTF1, OIOILCON, OIEDBAL, OIPRICIE, OIINEX, OIEDBALM, OIDRC, OIC_DRCTRY, OIC_DRCREG, OIMETIND, OIWAP, OISLF, OIPSDRC, OIPIPEVAL, OIC_LIFNR, OIC_DCITYC, OIC_DCOUNC, OIC_DREGIO, OIC_DLAND1, OIC_OCITYC, OIC_OCOUNC, OIC_OREGIO, OIC_OLAND1, OIC_PORGIN, OIC_PDESTN, OIC_PTRIP, OIC_PBATCH, OIC_MOT, OIC_AORGIN, OIC_ADESTN, OIC_TRUCKN, OIA_BASELO, OIEXGNUM, OIEXGTYP, OIFEETOT, OIFEEDT, OINETCYC, OICONTNR, OIC_KMPOS, OIFEECH, OIH_LICTP, OIH_LICIN, OIH_LCFOL, OIH_FOLQTY, OISBREL, OIBASPROD, OIDMSG_PRD, OIDMSG_QTY, OIDMSG_UOM, OIDMSG_DAT, OIDMSG_TRM, OIDMSG_SHP, OIGNRULE, OID_SHIP, OIBWTAR_IM, OIHANTYP_IM, OITAXGRP_IM, OITAXFROM_IM, OITAXTO_IM, OIEDBAL_IM, OIEDBALM_IM, OIPRICIE_IM, OIBWTAR_EX, OIHANTYP_EX, OITAXGRP_EX, OITAXFROM_EX, OITAXTO_EX, OIEDBAL_EX, OIEDBALM_EX, OIPRICIE_EX, OIINEX_EX, OICERTF1_EX, OIH_LICTP_EX, OIH_LICIN_EX, OIH_LCFOL_EX, OIH_FOLQTY_EX, OIHTAXRCP_EX, OIHNOTWERKS, OIHNOTLGORT, OIHCOTDISCH, PRS_OBJNR, PRS_SD_SPSNR, PRS_WORK_PERIOD, TAS, BETC, MOD_ALLOW, CANCEL_ALLOW, PAY_METHOD, BPN, REP_FREQ, FMFGUS_KEY, PARGB, AUFPL_OAA, APLZL_OAA, ARSNUM, ARSPOS, WTYSC_CLMITEM, ZZDEA_LICENSE, ZZDEA_SCHEDULE FROM ZEIM_VBAP

TOP ERP 6.0 | ZEIM_VBAP 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 (Own or External)	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_EXT	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?
205	PCTRF	Profit Center for Billing	nvarchar	10	0	CHAR	(N' ')	Yes	*	PCTRF	Allow NULL?
206	LOGSYS_EXT	Logical system	nvarchar	10	0	CHAR	(N' ')	Yes	*	LOGSYS	Allow NULL?
207	J_1BTAXLW3	ISS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL3	J_1BTAXLW3	Allow NULL?
208	J_1BTAXLW4	COFINS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL4A	J_1BTAXLW4	Allow NULL?
209	J_1BTAXLW5	PIS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL5	J_1BTAXLW5	Allow NULL?
210	STOCKLOC	First Inventory-Managing Location	nvarchar	20	0	CHAR	(N' ')	Yes		STOCKLOC	Allow NULL?
211	SLOCTYPE	Type of First Inventory-Managing Location	nvarchar	4	0	CHAR	(N' ')	Yes		SLOCTYPE	Allow NULL?
212	MSR_RET_REASON	Return Reason	nvarchar	3	0	CHAR	(N' ')	Yes	MSR_C_RET_REASON	MSR_RETURNS_REASON	Allow NULL?
213	MSR_REFUND_CODE	Returns Refund Code	nvarchar	3	0	CHAR	(N' ')	Yes	MSR_C_RET_REFUND	MSR_RETURNS_REFUND_CODE	Allow NULL?
214	MSR_APPROV_BLOCK	Approval Block	char	1	0	CHAR	(N' ')	Yes		MSR_APPROVAL_BLOCK	Allow NULL?
215	NRAB_KNUMH	Condition record number	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMH	Allow NULL?
216	TRMRISK_RELEVANT	Risk Relevancy in Sales	nvarchar	2	0	CHAR	(N' ')	Yes		SLS_TRM_RISK_RELEVANCY	Allow NULL?
217	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
218	HANDOVERLOC	Location for a physical handover of goods	nvarchar	10	0	CHAR	(N' ')	Yes		HANDOVER_LOC	Allow NULL?
219	HANDOVERDATE	Handover Date at the Handover Location	nvarchar	8	0	DATS	(N'00000000')	Yes		HANDOVER_DATE	Allow NULL?
220	HANDOVERTIME	Handover time at the handover location	nvarchar	6	0	TIMS	(N'000000')	Yes		HANDOVER_TIME	Allow NULL?
221	Z_PRS_OFFSHORE	Professional Services: Delivery Type	char	1	0	CHAR	(N' ')	Yes		Z_PRS_OFFSHORE	Allow NULL?
222	Z_PRS_BILL_FLAG	Professional Services: Billable/Non-Billable	char	1	0	CHAR	(N' ')	Yes		Z_PRS_BILLABLE_FLAG	Allow NULL?
223	Z_PRS_COUNTRY	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
224	Z_PRS_CHARGELEVL	Professional Services: Charge Level	nvarchar	2	0	CHAR	(N' ')	Yes		Z_PRS_CHARGELEVEL	Allow NULL?
225	TC_AUT_DET	Tax Code Automatically Determined	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1BTC_AUT_DET	Allow NULL?
226	MANUAL_TC_REASON	Manual Tax Code Reason	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1BMANUAL_TC_REASON	Allow NULL?
227	FISCAL_INCENTIVE	Tax Incentive Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_1BFISCAL_INCENTIVE_CODE	Allow NULL?
228	TAX_SUBJECT_ST	Tax Subject to Substituição Tributária	char	1	0	CHAR	(N' ')	Yes		J_1BTC_TAX_SUBJECT_ST	Allow NULL?
229	FISCAL_INCENTIVE_ID	Incentive ID	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_1BFISCAL_INCENTIVE_ID_SD	Allow NULL?
230	SPCSTO	Nota Fiscal Special Case for CFOP Determination	nvarchar	2	0	NUMC	(N'00')	Yes	*	J_1BSPCSTO_SD	Allow NULL?
231	/BEV1/SRFUND	Analysis/Reason for Rejection	nvarchar	2	0	CHAR	(N' ')	Yes	*	/BEV1/SRBEFUND	Allow NULL?
232	CPD_UPDAT	Time Stamp	decimal	15	0	DEC	((0))	Yes		/CPD/PFP_TSTMP
233	AUFPL_OLC	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
234	APLZL_OLC	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
235	/XLSO/COURSE_ID	Product ID	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	/XLSO/E_PRODUCT_ID	Allow NULL?
236	/XLSO/COURSE_BDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
237	/XLSO/COURSE_EDA	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
238	FERC_IND	Regulatory indicator	nvarchar	4	0	CHAR	(N' ')	Yes	FERC_C7	FE_IND	Allow NULL?
239	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
240	FONDS	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
241	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
242	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
243	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
244	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
245	IUID_RELEVANT	IUID Relevant for Customer	char	1	0	CHAR	(N' ')	Yes		IUID_RELEVANT_CUST	Allow NULL?
246	MILL_SE_GPOSN	Global Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	MILL_SE_GPOSN	Allow NULL?
247	OID_EXTBOL	External bill of lading	nvarchar	16	0	CHAR	(N' ')	Yes		OID_EXTBOL	Allow NULL?
248	OID_MISCDL	Miscellaneous delivery number	nvarchar	16	0	CHAR	(N' ')	Yes		OID_MISCDL	Allow NULL?
249	OIPLANTD	Plant determination active or not active	char	1	0	CHAR	(N' ')	Yes		OID_PLANTD	Allow NULL?
250	OIBYPASS	IS-Oil plant determination indicator: x=yes blank=no	char	1	0	CHAR	(N' ')	Yes		OID_BYPASS	Allow NULL?
251	OIEDOK	Excise duty validation indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDOK	Allow NULL?
252	CMETH	Quantity Conversion Method	char	1	0	CHAR	(N' ')	Yes		OIB_CMETH	Allow NULL?
253	OITAXFROM	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
254	OIHANTYP	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
255	OITAXGRP	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
256	OITAXTO	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
257	OICERTF1	Excise tax external license number	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1	Allow NULL?
258	OIOILCON	Oil content in a material as a percentage	decimal	5	2	DEC	((0))	Yes		OIH_OILCON
259	OIEDBAL	Excise duty balancing is required (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL	Allow NULL?
260	OIPRICIE	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
261	OIINEX	Code for internal or external excise duty rate determination	nvarchar	2	0	CHAR	(N' ')	Yes	OIH16	OIH_INEX	Allow NULL?
262	OIEDBALM	Excise duty balancing method indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM	Allow NULL?
263	OIDRC	Differential Reference Code (DRC)	nvarchar	5	0	CHAR	(N' ')	Yes	OICDC	OIC_DRC	Allow NULL?
264	OIC_DRCTRY	DRC country	nvarchar	3	0	CHAR	(N' ')	Yes	*	OIC_DRCTRY	Allow NULL?
265	OIC_DRCREG	DRC region	nvarchar	3	0	CHAR	(N' ')	Yes	*	OIC_DRCREG	Allow NULL?
266	OIMETIND	Metropolitan indicator	nvarchar	4	0	CHAR	(N' ')	Yes	*	OIC_METIND	Allow NULL?
267	OIWAP	Wide-area pricing zone	nvarchar	3	0	CHAR	(N' ')	Yes	*	OIC_WAP	Allow NULL?
268	OISLF	State license fee zone	nvarchar	3	0	CHAR	(N' ')	Yes	*	OIC_SLF	Allow NULL?
269	OIPSDRC	Pricing DRC (grouping customers by DRC for pricing)	nvarchar	5	0	CHAR	(N' ')	Yes	*	OIC_PSDRC	Allow NULL?
270	OIPIPEVAL	Validation indicator for pipeline fields (X=ON, blank=OFF)	char	1	0	CHAR	(N' ')	Yes		OID_PIPEV	Allow NULL?
271	OIC_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
272	OIC_DCITYC	Destination city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_DCITYC	Allow NULL?
273	OIC_DCOUNC	Destination county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_DCOUNC	Allow NULL?
274	OIC_DREGIO	Destination region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_DREGIO	Allow NULL?
275	OIC_DLAND1	Destination country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_DLAND1	Allow NULL?
276	OIC_OCITYC	Origin city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_OCITYC	Allow NULL?
277	OIC_OCOUNC	Origin county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_OCOUNC	Allow NULL?
278	OIC_OREGIO	Origin region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_OREGIO	Allow NULL?
279	OIC_OLAND1	Origin country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_OLAND1	Allow NULL?
280	OIC_PORGIN	Tax origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PORGIN	Allow NULL?
281	OIC_PDESTN	Tax destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PDESTN	Allow NULL?
282	OIC_PTRIP	Pipeline trip number (external)	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PTRIP	Allow NULL?
283	OIC_PBATCH	Pipeline operator´s external batch number	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PBATCH	Allow NULL?
284	OIC_MOT	IS-OIL MAP external details mode of transport	nvarchar	2	0	CHAR	(N' ')	Yes	TVTR	OIC_MOT	Allow NULL?
285	OIC_AORGIN	Alternate origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_AORGIN	Allow NULL?
286	OIC_ADESTN	Alternate destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_ADESTN	Allow NULL?
287	OIC_TRUCKN	Truck number	nvarchar	10	0	CHAR	(N' ')	Yes		OIC_TRUCKN	Allow NULL?
288	OIA_BASELO	Base location	nvarchar	15	0	CHAR	(N' ')	Yes		OIA_BASELO	Allow NULL?
289	OIEXGNUM	Exchange agreement number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIA_EXGNUM	Allow NULL?
290	OIEXGTYP	Exchange type	nvarchar	4	0	CHAR	(N' ')	Yes	TOIA2	OIA_EXGTYP	Allow NULL?
291	OIFEETOT	Fee total	decimal	13	2	CURR	((0))	Yes		OIA_FEETOT
292	OIFEEDT	Fee pricing condition date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIA_FEEDT	Allow NULL?
293	OINETCYC	Netting cycle (FI blocking indicator)	char	1	0	CHAR	(N' ')	Yes	T008	OIA_NETCYC	Allow NULL?
294	OICONTNR	Outline agreement: contract	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIC_CONTNR	Allow NULL?
295	OIC_KMPOS	Reference contract line item number	nvarchar	6	0	NUMC	(N'000000')	Yes		OIC_KMPOS	Allow NULL?
296	OIFEECH	Fee edit control	char	1	0	CHAR	(N' ')	Yes		OIA_FEECH	Allow NULL?
297	OIH_LICTP	License type	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP	Allow NULL?
298	OIH_LICIN	Excise tax internal license number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIH_LICIN	Allow NULL?
299	OIH_LCFOL	Follow-on license for quantity license	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL	Allow NULL?
300	OIH_FOLQTY	Excise Tax Follow-On License Quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY
301	OISBREL	Sub product/ base product relevence indicator	nvarchar	3	0	NUMC	(N'000')	Yes		OIA_SBREL	Allow NULL?
302	OIBASPROD	Base product number	nvarchar	18	0	CHAR	(N' ')	Yes	*	OIA_SBMAT	Allow NULL?
303	OIDMSG_PRD	Message type for product with contract restrictions	char	1	0	CHAR	(N' ')	Yes		OIDMSG_PRD	Allow NULL?
304	OIDMSG_QTY	Message type for contract restrictions quantity	char	1	0	CHAR	(N' ')	Yes		OIDMSG_QTY	Allow NULL?
305	OIDMSG_UOM	Message type for contract restrictions unit of measure	char	1	0	CHAR	(N' ')	Yes		OIDMSG_UOM	Allow NULL?
306	OIDMSG_DAT	Message type for contract restrictions validity period	char	1	0	CHAR	(N' ')	Yes		OIDMSG_DAT	Allow NULL?
307	OIDMSG_TRM	Message type for contract restrictions payment terms	char	1	0	CHAR	(N' ')	Yes		OIDMSG_TRM	Allow NULL?
308	OIDMSG_SHP	Message type for contract restrictions ship-to party	char	1	0	CHAR	(N' ')	Yes		OIDMSG_SHP	Allow NULL?
309	OIGNRULE	Gross/net pricing rule	nvarchar	3	0	NUMC	(N'000')	Yes	*	OIC_GNRULE	Allow NULL?
310	OID_SHIP	Ship-to party	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNWE	Allow NULL?
311	OIBWTAR_IM	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
312	OIHANTYP_IM	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
313	OITAXGRP_IM	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
314	OITAXFROM_IM	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
315	OITAXTO_IM	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
316	OIEDBAL_IM	Excise duty balancing is required (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL	Allow NULL?
317	OIEDBALM_IM	Excise duty balancing method indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM	Allow NULL?
318	OIPRICIE_IM	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
319	OIBWTAR_EX	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
320	OIHANTYP_EX	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
321	OITAXGRP_EX	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
322	OITAXFROM_EX	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
323	OITAXTO_EX	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
324	OIEDBAL_EX	Excise duty balancing is required (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL	Allow NULL?
325	OIEDBALM_EX	Excise duty balancing method indicator	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM	Allow NULL?
326	OIPRICIE_EX	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
327	OIINEX_EX	Code for internal or external excise duty rate determination	nvarchar	2	0	CHAR	(N' ')	Yes	OIH16	OIH_INEX	Allow NULL?
328	OICERTF1_EX	Excise tax external license number	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1	Allow NULL?
329	OIH_LICTP_EX	License type	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP	Allow NULL?
330	OIH_LICIN_EX	Excise tax internal license number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIH_LICIN	Allow NULL?
331	OIH_LCFOL_EX	Follow-on license for quantity license	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL	Allow NULL?
332	OIH_FOLQTY_EX	Excise Tax Follow-On License Quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY
333	OIHTAXRCP_EX	Tax Recipient	nvarchar	10	0	CHAR	(N' ')	Yes		OIHTAXRCP	Allow NULL?
334	OIHNOTWERKS	Cross Excise Duty Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	OIH_SHADOWPL	Allow NULL?
335	OIHNOTLGORT	Cross Excise Duty Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	OIH_SHADOWLOC	Allow NULL?
336	OIHCOTDISCH	Trigger Import Posting at Proof of Delivery Receipt	char	1	0	CHAR	(N' ')	Yes		OIHCOTDISCH	Allow NULL?
337	PRS_OBJNR	Engagement mgmt: Object number	nvarchar	22	0	CHAR	(N' ')	Yes		PRS_OBJNR	Allow NULL?
338	PRS_SD_SPSNR	Standard WBS Element for Project Inception via SD	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PRS_SD_SPSNR	Allow NULL?
339	PRS_WORK_PERIOD	Work Period (Internal Representation)	nvarchar	7	0	NUMC	(N'0000000')	Yes		PRS_WORK_PERIOD	Allow NULL?
340	TAS	Treasury Account Symbol	nvarchar	30	0	CHAR	(N' ')	Yes		FMFG_TAS	Allow NULL?
341	BETC	Business Event Type Code	nvarchar	10	0	CHAR	(N' ')	Yes		FMFG_BETC	Allow NULL?
342	MOD_ALLOW	Modification Allowed	char	1	0	CHAR	(N' ')	Yes		FMFG_MOD_ALLOW	Allow NULL?
343	CANCEL_ALLOW	Cancellation Allowed	char	1	0	CHAR	(N' ')	Yes		FMFG_CANCEL_ALLOW	Allow NULL?
344	PAY_METHOD	List of the Payment Methods to be Considered	nvarchar	10	0	CHAR	(N' ')	Yes		DZWELS	Allow NULL?
345	BPN	Business Partner Number	nvarchar	6	0	CHAR	(N' ')	Yes	T880	FMFG_BPN	Allow NULL?
346	REP_FREQ	Reporting Frequency	nvarchar	3	0	CHAR	(N' ')	Yes		FMFG_REP_FREQ	Allow NULL?
347	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
348	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARGB	Allow NULL?
349	AUFPL_OAA	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
350	APLZL_OAA	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
351	ARSNUM	Number of reservation/dependent requirements	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WTYSC_RSNUM	Allow NULL?
352	ARSPOS	Item number of reservation/dependent requirements	nvarchar	4	0	NUMC	(N'0000')	Yes		WTYSC_RSPOS	Allow NULL?
353	WTYSC_CLMITEM	Claim item number	nvarchar	16	0	CHAR	(N' ')	Yes		WTYSC_CLMITEM	Allow NULL?
354	ZZDEA_LICENSE	DEA Number	nvarchar	9	0	CHAR	(N' ')	Yes		ZZDEA_NO	Allow NULL?
355	ZZDEA_SCHEDULE	DEA Schedule Key	nvarchar	2	0	CHAR	(N' ')	Yes		ZZDEA_SCHED_KEY	Allow NULL?

TOP ERP 6.0 | ZEIM_VBAP INDEXES

Name	Primary	Unique	Type	Columns
ZEIM_VBAP~0	Yes	Yes	CLUSTERED	MANDT, VBELN, POSNR

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

355 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_VBAP TABLE

TOP ERP 6.0 | ZEIM_VBAP COLUMNS

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

355 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_VBAP TABLE

TOPERP 6.0 | ZEIM_VBAP COLUMNS

TOPERP 6.0 | ZEIM_VBAP INDEXES

TOP ERP 6.0 | ZEIM_VBAP COLUMNS

TOP ERP 6.0 | ZEIM_VBAP INDEXES