	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

304 COLUMNS | 4 INDEXES | ERP 6.0 | MSEG TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MSEG	304	4	Document Segment: Material	Inventory Management

SQL: selectupdate insert create

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

SELECT MANDT, MBLNR, MJAHR, ZEILE, LINE_ID, PARENT_ID, LINE_DEPTH, MAA_URZEI, BWART, XAUTO, MATNR, WERKS, LGORT, CHARG, INSMK, ZUSCH, ZUSTD, SOBKZ, LIFNR, KUNNR, KDAUF, KDPOS, KDEIN, PLPLA, SHKZG, WAERS, DMBTR, BNBTR, BUALT, SHKUM, DMBUM, BWTAR, MENGE, MEINS, ERFMG, ERFME, BPMNG, BPRME, EBELN, EBELP, LFBJA, LFBNR, LFPOS, SJAHR, SMBLN, SMBLP, ELIKZ, SGTXT, EQUNR, WEMPF, ABLAD, GSBER, KOKRS, PARGB, PARBU, KOSTL, PROJN, AUFNR, ANLN1, ANLN2, XSKST, XSAUF, XSPRO, XSERG, GJAHR, XRUEM, XRUEJ, BUKRS, BELNR, BUZEI, BELUM, BUZUM, RSNUM, RSPOS, KZEAR, PBAMG, KZSTR, UMMAT, UMWRK, UMLGO, UMCHA, UMZST, UMZUS, UMBAR, UMSOK, KZBEW, KZVBR, KZZUG, WEUNB, PALAN, LGNUM, LGTYP, LGPLA, BESTQ, BWLVS, TBNUM, TBPOS, XBLVS, VSCHN, NSCHN, DYPLA, UBNUM, TBPRI, TANUM, WEANZ, GRUND, EVERS, EVERE, IMKEY, KSTRG, PAOBJNR, PRCTR, PS_PSP_PNR, NPLNR, AUFPL, APLZL, AUFPS, VPTNR, FIPOS, SAKTO, BSTMG, BSTME, XWSBR, EMLIF, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, EXBWR, VKWRT, AKTNR, ZEKKN, VFDAT, CUOBJ_CH, EXVKW, PPRCTR, RSART, GEBER, FISTL, MATBF, UMMAB, BUSTM, BUSTW, MENGU, WERTU, LBKUM, SALK3, VPRSV, FKBER, DABRBZ, VKWRA, DABRZ, XBEAU, LSMNG, LSMEH, KZBWS, QINSPST, URZEI, J_1BEXBASE, MWSKZ, TXJCD, EMATN, J_1AGIRUPD, VKMWS, HSDAT, BERKZ, MAT_KDAUF, MAT_KDPOS, MAT_PSPNR, XWOFF, BEMOT, PRZNR, LLIEF, LSTAR, XOBEW, GRANT_NBR, ZUSTD_T156M, SPE_GTS_STOCK_TY, KBLNR, KBLPOS, XMACC, VGART_MKPF, BUDAT_MKPF, CPUDT_MKPF, CPUTM_MKPF, USNAM_MKPF, XBLNR_MKPF, TCODE2_MKPF, VBELN_IM, VBELP_IM, SGT_SCAT, SGT_UMSCAT, _DATAAGING, SGT_RCAT, /BEV2/ED_KZ_VER, /BEV2/ED_USER, /BEV2/ED_AEDAT, /BEV2/ED_AETIM, DISUB_OWNER, OINAVNW, OICONDCOD, CONDI, OIKNUMV, OIEXGPTR, OIMATPST, OIMATIE, OIEXGTYP, OIFEETOT, OIFEEPST, OIFEEDT, OIMATREF, OIEXGNUM, OINETCYC, OIJ1BNFFIM, OITRKNR, OITRKJR, OIEXTNR, OIITMNR, OIFTIND, OIPRIOP, OITRIND, OIGHNDL, OIUMBAR, OISBREL, OIBASPROD, OIBASVAL, OIGLERF, OIGLSKU, OIGLBPR, OIGLBST, OIGLCALC, OIBBSWQTY, OIASTBW, OIVBELN, OIPOSNR, 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, OICERTF1, OIDATFM1, OIDATTO1, OIH_LICTP, OIH_LICIN, OIH_LCFOL, OIH_FOLQTY, OID_EXTBOL, OID_MISCDL, OIBOMHEAD, OIB_TIMESTAMP, OIB_GUID_OPEN, OIB_GUID_CLOSE, OIB_SOCNR, OITAXFROM, OITAXTO, OIHANTYP, OITAXGRP, OIPRICIE, OIINVREC, OIOILCON, OIOILCON2, OIFUTDT, OIFUTDT2, OIUOMQT, OITAXQT, OIFUTQT, OIFUTQT2, OITAXGRP2, OIEDBAL_GI, OIEDBALM_GI, OICERTF1_GI, OIDATFM1_GI, OIDATTO1_GI, OIH_LICTP_GI, OIH_LICIN_GI, OIH_LCFOL_GI, OIH_FOLQTY_GI, OIHANTYP_GI, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3 FROM MSEG

TOP ERP 6.0 | MSEG 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	*	MANDT	Allow NULL?
2	MBLNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	No		MBLNR	Allow NULL?
3	MJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	No		MJAHR	Allow NULL?
4	ZEILE	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	No		MBLPO	Allow NULL?
5	LINE_ID	Unique identification of document line	nvarchar	6	0	NUMC	(N'000000')	Yes		MB_LINE_ID	Allow NULL?
6	PARENT_ID	Identifier of immediately superior line	nvarchar	6	0	NUMC	(N'000000')	Yes		MB_PARENT_ID	Allow NULL?
7	LINE_DEPTH	Hierarchy level of line in document	nvarchar	2	0	NUMC	(N'00')	Yes		MB_LINE_DEPTH	Allow NULL?
8	MAA_URZEI	Original Line for Account Assignment Item in Material Doc.	nvarchar	4	0	NUMC	(N'0000')	Yes		MAA_URZEI	Allow NULL?
9	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	Yes	T156	BWART	Allow NULL?
10	XAUTO	Item automatically created	char	1	0	CHAR	(N' ')	Yes		MB_XAUTO	Allow NULL?
11	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
12	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
13	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
14	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	CHARG_D	Allow NULL?
15	INSMK	Stock Type	char	1	0	CHAR	(N' ')	Yes		MB_INSMK	Allow NULL?
16	ZUSCH	Batch status key	char	1	0	CHAR	(N' ')	Yes		DZUSCH	Allow NULL?
17	ZUSTD	Batch in Restricted-Use Stock	char	1	0	CHAR	(N' ')	Yes		DZUSTD	Allow NULL?
18	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
19	LIFNR	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	ELIFN	Allow NULL?
20	KUNNR	Account Number of Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	EKUNN	Allow NULL?
21	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
22	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
23	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	NUMC	(N'0000')	Yes		KDEIN	Allow NULL?
24	PLPLA	Distribution of Differences	nvarchar	10	0	CHAR	(N' ')	Yes		PLPLA	Allow NULL?
25	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
26	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
27	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
28	BNBTR	Delivery costs in local currency	decimal	13	2	CURR	((0))	Yes		BNBTR
29	BUALT	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
30	SHKUM	Debit/credit indicator in revaluation	char	1	0	CHAR	(N' ')	Yes		SHKUM	Allow NULL?
31	DMBUM	Revaluation amount on back-posting to a previous period	decimal	13	2	CURR	((0))	Yes		DMBUM
32	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
33	MENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
34	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
35	ERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
36	ERFME	Unit of Entry	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERFME	Allow NULL?
37	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
38	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BBPRM	Allow NULL?
39	EBELN	Purchase Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	BSTNR	Allow NULL?
40	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
41	LFBJA	Fiscal Year of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFBJA	Allow NULL?
42	LFBNR	Document No. of a Reference Document	nvarchar	10	0	CHAR	(N' ')	No		LFBNR	Allow NULL?
43	LFPOS	Item of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFPOS	Allow NULL?
44	SJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	Yes		MJAHR	Allow NULL?
45	SMBLN	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	Yes		MBLNR	Allow NULL?
46	SMBLP	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
47	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
48	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
49	EQUNR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EQUNR	Allow NULL?
50	WEMPF	Goods Recipient/Ship-To Party	nvarchar	12	0	CHAR	(N' ')	Yes		WEMPF	Allow NULL?
51	ABLAD	Unloading Point	nvarchar	25	0	CHAR	(N' ')	Yes		ABLAD	Allow NULL?
52	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
53	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
54	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	PARGB	Allow NULL?
55	PARBU	Clearing company code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	PARBU	Allow NULL?
56	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
57	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR	(N' ')	Yes		PROJN	Allow NULL?
58	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
59	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
60	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
61	XSKST	Indicator: Statistical posting to cost center	char	1	0	CHAR	(N' ')	Yes		XSKST	Allow NULL?
62	XSAUF	Indicator: Posting to order is statistical	char	1	0	CHAR	(N' ')	Yes		XSAUF	Allow NULL?
63	XSPRO	Indicator: Posting to project is statistical	char	1	0	CHAR	(N' ')	Yes		XSPRO	Allow NULL?
64	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	CHAR	(N' ')	Yes		XSERG	Allow NULL?
65	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
66	XRUEM	Allow Posting to Previous Period (Backposting)	char	1	0	CHAR	(N' ')	Yes		XRUEM	Allow NULL?
67	XRUEJ	Indicator: post to previous year	char	1	0	CHAR	(N' ')	Yes		XRUEJ	Allow NULL?
68	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
69	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
70	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
71	BELUM	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
72	BUZUM	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
73	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
74	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	Yes		RSPOS	Allow NULL?
75	KZEAR	Final Issue for This Reservation	char	1	0	CHAR	(N' ')	Yes		KZEAR	Allow NULL?
76	PBAMG	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
77	KZSTR	Transaction/event is relevant to statistics	char	1	0	CHAR	(N' ')	Yes		KZSTR	Allow NULL?
78	UMMAT	Receiving/Issuing Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	UMMAT	Allow NULL?
79	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	UMWRK	Allow NULL?
80	UMLGO	Receiving/Issuing Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	UMLGO	Allow NULL?
81	UMCHA	Receiving/Issuing Batch	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	UMCHA	Allow NULL?
82	UMZST	Status of Transfer Batch	char	1	0	CHAR	(N' ')	Yes		UMZST	Allow NULL?
83	UMZUS	Status key of transfer batch	char	1	0	CHAR	(N' ')	Yes		UMZUS	Allow NULL?
84	UMBAR	Valuation Type of Transfer Batch	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	UMBAR	Allow NULL?
85	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	T148	UMSOK	Allow NULL?
86	KZBEW	Movement Indicator	char	1	0	CHAR	(N' ')	Yes		KZBEW	Allow NULL?
87	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
88	KZZUG	Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		KZZUG	Allow NULL?
89	WEUNB	Goods Receipt, Non-Valuated	char	1	0	CHAR	(N' ')	Yes		WEUNB	Allow NULL?
90	PALAN	WMS Number of pallets	decimal	11	0	DEC	((0))	Yes		PALAN
91	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
92	LGTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LGTYP	Allow NULL?
93	LGPLA	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	LAGP	LGPLA	Allow NULL?
94	BESTQ	Stock Category in the Warehouse Management System	char	1	0	CHAR	(N' ')	Yes		BESTQ	Allow NULL?
95	BWLVS	Movement Type for Warehouse Management	nvarchar	3	0	NUMC	(N'000')	Yes	T333	BWLVS	Allow NULL?
96	TBNUM	Transfer Requirement Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	LTBK	TBNUM	Allow NULL?
97	TBPOS	Transfer Requirement Item	nvarchar	4	0	NUMC	(N'0000')	Yes		TBPOS	Allow NULL?
98	XBLVS	Indicator: posting in warehouse management system	char	1	0	CHAR	(N' ')	Yes		XBLVS	Allow NULL?
99	VSCHN	Ind: interim storage posting for source stor.type and bin	char	1	0	CHAR	(N' ')	Yes		T333_VSCHN	Allow NULL?
100	NSCHN	Ind.: interim storage posting for dest.stor.type and bin	char	1	0	CHAR	(N' ')	Yes		T333_NSCHN	Allow NULL?
101	DYPLA	Indicator: dynamic storage bin	char	1	0	CHAR	(N' ')	Yes		DYPLA	Allow NULL?
102	UBNUM	Posting Change Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		UBNUM	Allow NULL?
103	TBPRI	Transfer Priority	char	1	0	CHAR	(N' ')	Yes		TBPRI	Allow NULL?
104	TANUM	Transfer Order Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		TANUM	Allow NULL?
105	WEANZ	Number of GR/GI Slips to Be Printed	nvarchar	3	0	NUMC	(N'000')	Yes		WEANZ	Allow NULL?
106	GRUND	Reason for Movement	nvarchar	4	0	NUMC	(N'0000')	Yes	T157D	MB_GRBEW	Allow NULL?
107	EVERS	Shipping Instructions	nvarchar	2	0	CHAR	(N' ')	Yes	T027A	EVERS	Allow NULL?
108	EVERE	Compliance with Shipping Instructions	nvarchar	2	0	CHAR	(N' ')	Yes	T027C	EVERE	Allow NULL?
109	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
110	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	*	KSTRG	Allow NULL?
111	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
112	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
113	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
114	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NPLNR	Allow NULL?
115	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
116	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
117	AUFPS	Order Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		CO_POSNR	Allow NULL?
118	VPTNR	Partner account number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	JV_PART	Allow NULL?
119	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	FMFPO	FIPOS	Allow NULL?
120	SAKTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	SAKNR	Allow NULL?
121	BSTMG	Goods receipt quantity in order unit	decimal	13	3	QUAN	((0))	Yes		MB_BSTMG
122	BSTME	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	BSTME	Allow NULL?
123	XWSBR	Reversal of GR allowed for GR-based IV despite invoice	char	1	0	CHAR	(N' ')	Yes		XWSBR	Allow NULL?
124	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	EMLIF	Allow NULL?
125	ZZSPREG	Special Region	nvarchar	5	0	CHAR	(N' ')	Yes	ZZSPREG	ZREGION	Allow NULL?
126	ZZBUSPARTN	Business partner	nvarchar	10	0	CHAR	(N' ')	Yes		ZZBUSPARTN	Allow NULL?
127	ZZPRODUCT	Product group	nvarchar	10	0	CHAR	(N' ')	Yes		ZZPRODUCT	Allow NULL?
128	ZZLOCA	City	nvarchar	4	0	CHAR	(N' ')	Yes		ZZLOCA	Allow NULL?
129	ZZCHAN	Distribution channel	nvarchar	4	0	CHAR	(N' ')	Yes		ZZCHAN	Allow NULL?
130	ZZLOB	BUSINESS LINE	nvarchar	7	0	CHAR	(N' ')	Yes	*	ZZLOB	Allow NULL?
131	ZZNFAL		nvarchar	10	0		(N' ')	Yes			Allow NULL?
132	ZZUSERFLD1	Territory	nvarchar	9	0	CHAR	(N' ')	Yes	ZFU1	ZZUSERFLD1	Allow NULL?
133	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	CHAR	(N' ')	Yes		ZZUSERFLD2	Allow NULL?
134	ZZUSERFLD3	Vein	nvarchar	22	0	CHAR	(N' ')	Yes		ZZUSERFLD3	Allow NULL?
135	ZZREGION	Location	nvarchar	3	0	CHAR	(N' ')	Yes	ZREG	ZZREGION	Allow NULL?
136	ZZSTATE	State/Province Code	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	ZZSTATE	Allow NULL?
137	EXBWR	Externally Entered Posting Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		EXBWR
138	VKWRT	Value at Sales Prices Including Value-Added Tax	decimal	13	2	CURR	((0))	Yes		VKWRT
139	AKTNR	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	*	WAKTION	Allow NULL?
140	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
141	VFDAT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
142	CUOBJ_CH	Internal object number of the batch classification	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_CH	Allow NULL?
143	EXVKW	Externally Entered Sales Value in Local Currency	decimal	13	2	CURR	((0))	Yes		EXVKW
144	PPRCTR	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PPRCTR	Allow NULL?
145	RSART	Record type	char	1	0	CHAR	(N' ')	Yes		RSART	Allow NULL?
146	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
147	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
148	MATBF	Material in Respect of Which Stock is Managed	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATBF	Allow NULL?
149	UMMAB	Receiving/Issuing Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	UMMAT	Allow NULL?
150	BUSTM	Posting string for quantities	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTM	Allow NULL?
151	BUSTW	Posting string for values	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTW	Allow NULL?
152	MENGU	Quantity Updating in Material Master Record	char	1	0	CHAR	(N' ')	Yes		MENGU	Allow NULL?
153	WERTU	Value Update in Material Master Record	char	1	0	CHAR	(N' ')	Yes		WERTU	Allow NULL?
154	LBKUM	Total valuated stock before the posting	decimal	13	3	QUAN	((0))	Yes		LBKUM_MSEG
155	SALK3	Value of total valuated stock before the posting	decimal	13	2	CURR	((0))	Yes		SALK3_MSEG
156	VPRSV	Price control indicator	char	1	0	CHAR	(N' ')	Yes		VPRSV	Allow NULL?
157	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
158	DABRBZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
159	VKWRA	Value at sales prices excluding value-added tax	decimal	13	2	CURR	((0))	Yes		VKWRA
160	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
161	XBEAU	Purchase order created at time of goods receipt	char	1	0	CHAR	(N' ')	Yes		XBEAU	Allow NULL?
162	LSMNG	Quantity in Unit of Measure from Delivery Note	decimal	13	3	QUAN	((0))	Yes		LSMNG
163	LSMEH	Unit of Measure From Delivery Note	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LSMEH	Allow NULL?
164	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
165	QINSPST	Status of Goods Receipt Inspection	char	1	0	CHAR	(N' ')	Yes		QINSPST	Allow NULL?
166	URZEI	Original line in material document	nvarchar	4	0	NUMC	(N'0000')	Yes		URZEI	Allow NULL?
167	J_1BEXBASE	Alternate base amount in document currency	decimal	13	2	CURR	((0))	Yes		J_1BEXBASE
168	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
169	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
170	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EMATN	Allow NULL?
171	J_1AGIRUPD	Goods issue revaluation performed	char	1	0	CHAR	(N' ')	Yes		J_1AGIRUPD	Allow NULL?
172	VKMWS	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
173	HSDAT	Date of Manufacture	nvarchar	8	0	DATS	(N'00000000')	Yes		HSDAT	Allow NULL?
174	BERKZ	Material Staging Indicator for Production Supply	char	1	0	CHAR	(N' ')	Yes		BERKZ	Allow NULL?
175	MAT_KDAUF	Sales Order Number of Valuated Sales Order Stock	nvarchar	10	0	CHAR	(N' ')	Yes	*	MAT_KDAUF	Allow NULL?
176	MAT_KDPOS	Sales Order Item of Valuated Sales Order Stock	nvarchar	6	0	NUMC	(N'000000')	Yes		MAT_KDPOS	Allow NULL?
177	MAT_PSPNR	Valuated Sales Order Stock WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	MAT_PSPNR	Allow NULL?
178	XWOFF	Calculation of val. open	char	1	0	CHAR	(N' ')	Yes		XWOFF	Allow NULL?
179	BEMOT	Accounting Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TBMOT	BEMOT	Allow NULL?
180	PRZNR	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
181	LLIEF	Supplying Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LLIEF	Allow NULL?
182	LSTAR	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	*	LSTAR	Allow NULL?
183	XOBEW	Vendor Stock Valuation Indicator	char	1	0	CHAR	(N' ')	Yes		XOBEW	Allow NULL?
184	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
185	ZUSTD_T156M	Stock Type Modification (Read from Table T156M)	char	1	0	CHAR	(N' ')	Yes		BAMOK_MSEG	Allow NULL?
186	SPE_GTS_STOCK_TY	GTS Stock Type	char	1	0	CHAR	(N' ')	Yes		/SPE/GTS_STOCK_TYPE	Allow NULL?
187	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR_FI	Allow NULL?
188	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
189	XMACC	Multiple Account Assignment	char	1	0	CHAR	(N' ')	Yes		XMACC	Allow NULL?
190	VGART_MKPF	Transaction/Event Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	VGART	Allow NULL?
191	BUDAT_MKPF	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
192	CPUDT_MKPF	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
193	CPUTM_MKPF	Time of Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		CPUTM	Allow NULL?
194	USNAM_MKPF	User name	nvarchar	12	0	CHAR	(N' ')	Yes	*	USNAM	Allow NULL?
195	XBLNR_MKPF	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR	Allow NULL?
196	TCODE2_MKPF	Transaction Code	nvarchar	20	0	CHAR	(N' ')	Yes	*	TCODE	Allow NULL?
197	VBELN_IM	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
198	VBELP_IM	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
199	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
200	SGT_UMSCAT	Receiving/Issuing Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_UMSCAT	Allow NULL?
201	_DATAAGING	Data Filter Value for Data Aging	nvarchar	8	0	DATS	(N'00000000')	Yes		DATA_TEMPERATURE	Allow NULL?
202	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
203	/BEV2/ED_KZ_VER	Processing Status of Material Document for Excise Duties	char	1	0	CHAR	(N' ')	Yes		/BEV2/EDKZ_VER	Allow NULL?
204	/BEV2/ED_USER	User name	nvarchar	12	0	CHAR	(N' ')	Yes	*	USNAM	Allow NULL?
205	/BEV2/ED_AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
206	/BEV2/ED_AETIM	System Time	nvarchar	6	0	TIMS	(N'000000')	Yes		SYUZEIT	Allow NULL?
207	DISUB_OWNER	Owner of stock	nvarchar	10	0	CHAR	(N' ')	Yes	*	OWNER_D	Allow NULL?
208	OINAVNW	Non-deductible input tax	decimal	13	2	CURR	((0))	Yes		NAVNW
209	OICONDCOD	Joint Venture Indicator (Condition Key)	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_CONDCOD	Allow NULL?
210	CONDI	Joint Venture Indicator (Condition Key)	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_CONDCOD	Allow NULL?
211	OIKNUMV	Number of the document condition	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMV	Allow NULL?
212	OIEXGPTR	Exchange partner (vendor number)	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIA_EXGPTR	Allow NULL?
213	OIMATPST	Posting rules for material	char	1	0	CHAR	(N' ')	Yes		OIA_MATPST	Allow NULL?
214	OIMATIE	Material internal / external posting indicator	char	1	0	CHAR	(N' ')	Yes		OIA_MATIE	Allow NULL?
215	OIEXGTYP	Exchange type	nvarchar	4	0	CHAR	(N' ')	Yes	*	OIA_EXGTYP	Allow NULL?
216	OIFEETOT	Fee total	decimal	13	2	CURR	((0))	Yes		OIA_FEETOT
217	OIFEEPST	Posting rules for fees	char	1	0	CHAR	(N' ')	Yes		OIA_FEEPST	Allow NULL?
218	OIFEEDT	Fee pricing condition date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIA_FEEDT	Allow NULL?
219	OIMATREF	Material group reference for exchange balance reporting	nvarchar	20	0	CHAR	(N' ')	Yes		OIA_MATREF	Allow NULL?
220	OIEXGNUM	Exchange agreement number	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIA_EXGNUM	Allow NULL?
221	OINETCYC	Netting cycle (FI blocking indicator)	char	1	0	CHAR	(N' ')	Yes	T008	OIA_NETCYC	Allow NULL?
222	OIJ1BNFFIM	Control Flag for Nota Fiscal creation (Gain/Loss)	char	1	0	CHAR	(N' ')	Yes		OIH_J1B_NFFI	Allow NULL?
223	OITRKNR	Tracking number	nvarchar	10	0	CHAR	(N' ')	Yes		OIH_TRKNR	Allow NULL?
224	OITRKJR	Tracking number year	nvarchar	4	0	NUMC	(N'0000')	Yes		OIH_TRKJR	Allow NULL?
225	OIEXTNR	External tracking number	nvarchar	18	0	CHAR	(N' ')	Yes		OIH_EXTNR	Allow NULL?
226	OIITMNR	Tracking number item line	nvarchar	5	0	NUMC	(N'00000')	Yes		OIH_ITMNR	Allow NULL?
227	OIFTIND	Final transfer indicator	char	1	0	CHAR	(N' ')	Yes		OIH_FTIND	Allow NULL?
228	OIPRIOP	Price options for gain calculation	char	1	0	CHAR	(N' ')	Yes		OIH_PRIOP	Allow NULL?
229	OITRIND	Transfer sign for plant-to-plant transfers	char	1	0	CHAR	(N' ')	Yes		OIH_TRIND	Allow NULL?
230	OIGHNDL	Gain handling	char	1	0	CHAR	(N' ')	Yes		OIH_GHNDL	Allow NULL?
231	OIUMBAR	Valuation type of issuing location for two-step transfer	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	OIH_UMBAR	Allow NULL?
232	OISBREL	Sub product/ base product relevence indicator	nvarchar	3	0	NUMC	(N'000')	Yes		OIA_SBREL	Allow NULL?
233	OIBASPROD	Base product number	nvarchar	18	0	CHAR	(N' ')	Yes	*	OIA_SBMAT	Allow NULL?
234	OIBASVAL	Base product value	decimal	13	2	CURR	((0))	Yes		OIA_BASVAL
235	OIGLERF	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
236	OIGLSKU	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
237	OIGLBPR	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
238	OIGLBST	Goods receipt quantity in order unit	decimal	13	3	QUAN	((0))	Yes		MB_BSTMG
239	OIGLCALC	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
240	OIBBSWQTY	Additional Oil and Gas Quantity	float	15	16	FLTP	((0))	Yes		OIB_ADQNT
241	OIASTBW	Reversal movement type	char	1	0	CHAR	(N' ')	Yes		XSTBW	Allow NULL?
242	OIVBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
243	OIPOSNR	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
244	OIPIPEVAL	Validation indicator for pipeline fields (X=ON, blank=OFF)	char	1	0	CHAR	(N' ')	Yes		OID_PIPEV	Allow NULL?
245	OIC_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
246	OIC_DCITYC	Destination city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_DCITYC	Allow NULL?
247	OIC_DCOUNC	Destination county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_DCOUNC	Allow NULL?
248	OIC_DREGIO	Destination region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_DREGIO	Allow NULL?
249	OIC_DLAND1	Destination country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_DLAND1	Allow NULL?
250	OIC_OCITYC	Origin city code	nvarchar	4	0	CHAR	(N' ')	Yes	T005G	OIC_OCITYC	Allow NULL?
251	OIC_OCOUNC	Origin county code	nvarchar	3	0	CHAR	(N' ')	Yes	T005E	OIC_OCOUNC	Allow NULL?
252	OIC_OREGIO	Origin region	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	OIC_OREGIO	Allow NULL?
253	OIC_OLAND1	Origin country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	OIC_OLAND1	Allow NULL?
254	OIC_PORGIN	Tax origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PORGIN	Allow NULL?
255	OIC_PDESTN	Tax destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_PDESTN	Allow NULL?
256	OIC_PTRIP	Pipeline trip number (external)	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PTRIP	Allow NULL?
257	OIC_PBATCH	Pipeline operator´s external batch number	nvarchar	16	0	CHAR	(N' ')	Yes		OIC_PBATCH	Allow NULL?
258	OIC_MOT	IS-OIL MAP external details mode of transport	nvarchar	2	0	CHAR	(N' ')	Yes	TVTR	OIC_MOT	Allow NULL?
259	OIC_AORGIN	Alternate origin	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_AORGIN	Allow NULL?
260	OIC_ADESTN	Alternate destination	nvarchar	15	0	CHAR	(N' ')	Yes		OIC_ADESTN	Allow NULL?
261	OIC_TRUCKN	Truck number	nvarchar	10	0	CHAR	(N' ')	Yes		OIC_TRUCKN	Allow NULL?
262	OIA_BASELO	Base location	nvarchar	15	0	CHAR	(N' ')	Yes		OIA_BASELO	Allow NULL?
263	OICERTF1	Excise tax external license number	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1	Allow NULL?
264	OIDATFM1	Excise Duty License Valid from Date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATFM1	Allow NULL?
265	OIDATTO1	Valid to date for excise duty tax certificate	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATTO1	Allow NULL?
266	OIH_LICTP	License type	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP	Allow NULL?
267	OIH_LICIN	Excise tax internal license number	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LICIN	Allow NULL?
268	OIH_LCFOL	Follow-on license for quantity license	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL	Allow NULL?
269	OIH_FOLQTY	Excise Tax Follow-On License Quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY
270	OID_EXTBOL	External bill of lading	nvarchar	16	0	CHAR	(N' ')	Yes		OID_EXTBOL	Allow NULL?
271	OID_MISCDL	Miscellaneous delivery number	nvarchar	16	0	CHAR	(N' ')	Yes		OID_MISCDL	Allow NULL?
272	OIBOMHEAD	BoM header material number	nvarchar	18	0	CHAR	(N' ')	Yes	*	OIA_BOMHM	Allow NULL?
273	OIB_TIMESTAMP	Tank dip time stamp	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		OIB_TMSTM	Allow NULL?
274	OIB_GUID_OPEN	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	CHAR	(N' ')	Yes		GUID_32	Allow NULL?
275	OIB_GUID_CLOSE	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	CHAR	(N' ')	Yes		GUID_32	Allow NULL?
276	OIB_SOCNR	SOC: Storage object characteristic segment number	nvarchar	20	0	CHAR	(N' ')	Yes	*	OII_SOCNR	Allow NULL?
277	OITAXFROM	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
278	OITAXTO	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
279	OIHANTYP	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
280	OITAXGRP	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
281	OIPRICIE	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
282	OIINVREC	Indicator whether ED pricing is external (not used?)	char	1	0	CHAR	(N' ')	Yes		OIH_INVREC	Allow NULL?
283	OIOILCON	Oil content in a material as a percentage	decimal	5	2	DEC	((0))	Yes		OIH_OILCON
284	OIOILCON2	Oil content of a material as a percentage (2)	decimal	5	2	DEC	((0))	Yes		OIH_OILCN2
285	OIFUTDT	Future tax date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_FUTDT	Allow NULL?
286	OIFUTDT2	Future tax date 2	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_FUTDT2	Allow NULL?
287	OIUOMQT	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	nvarchar	3	0	UNIT	(N' ')	Yes	*	OIH_UOMQT	Allow NULL?
288	OITAXQT	Excise duty tax quantity in STBME	decimal	13	3	QUAN	((0))	Yes		OIH_TAXQT
289	OIFUTQT	Future tax quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FUTQT
290	OIFUTQT2	Future tax quantity 2	decimal	13	3	QUAN	((0))	Yes		OIH_FUTQT2
291	OITAXGRP2	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	*	OIH_TAXGRP	Allow NULL?
292	OIEDBAL_GI	Excise Duty Balancing is Required for Mat. (STO)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBAL_GI	Allow NULL?
293	OIEDBALM_GI	Excise Duty Balancing Method Indicator for Mat. (STO)	char	1	0	CHAR	(N' ')	Yes		OIH_EDBALM_GI	Allow NULL?
294	OICERTF1_GI	Excise Tax External License Number Used During GI (STO)	nvarchar	15	0	CHAR	(N' ')	Yes		OIH_CERTF1_GI	Allow NULL?
295	OIDATFM1_GI	Excise Duty License Valid from Date for Mat. (STO)	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATFM1_GI	Allow NULL?
296	OIDATTO1_GI	Valid To Date for Excise Duty Tax Certificate for Mat. (STO)	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_DATTO1_GI	Allow NULL?
297	OIH_LICTP_GI	License Type to Material (STO)	nvarchar	4	0	CHAR	(N' ')	Yes	OIH20	OIH_LICTP_GI	Allow NULL?
298	OIH_LICIN_GI	Excise Tax Internal License Number to Mat. (STO)	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LICIN_GI	Allow NULL?
299	OIH_LCFOL_GI	Follow-On License for Quantity License to Mat. (STO)	nvarchar	10	0	CHAR	(N' ')	Yes	OIHL	OIH_LCFOL_GI	Allow NULL?
300	OIH_FOLQTY_GI	Excise Tax Follow-On License Quantity to Mat. (STO)	decimal	13	3	QUAN	((0))	Yes		OIH_FOLQTY_GI
301	OIHANTYP_GI	Excise Duty Handling Type - Denotes Use of Material	nvarchar	2	0	CHAR	(N' ')	Yes	*	OIH_HANTYP_GI	Allow NULL?
302	WRF_CHARSTC1	Characteristic Value 1	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC1	Allow NULL?
303	WRF_CHARSTC2	Characteristic Value 2	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC2	Allow NULL?
304	WRF_CHARSTC3	Characteristic Value 3	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC3	Allow NULL?

TOP ERP 6.0 | MSEG INDEXES

Name	Primary	Unique	Type	Columns
MSEG~0	Yes	Yes	CLUSTERED	ZEILE, MJAHR, MBLNR, MANDT
MSEG~M	No	No	NONCLUSTERED	SOBKZ, BWART, LGORT, WERKS, MATNR, MANDT
MSEG~R	No	No	NONCLUSTERED	RSNUM, MANDT
MSEG~S	No	No	NONCLUSTERED	SMBLP, SJAHR, SMBLN

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

304 COLUMNS | 4 INDEXES | ERP 6.0 | MSEG TABLE

TOP ERP 6.0 | MSEG COLUMNS

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

304 COLUMNS | 4 INDEXES | ERP 6.0 | MSEG TABLE

TOPERP 6.0 | MSEG COLUMNS

TOPERP 6.0 | MSEG INDEXES

TOP ERP 6.0 | MSEG COLUMNS

TOP ERP 6.0 | MSEG INDEXES