	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

181 COLUMNS | 1 INDEXES | ERP 6.0 | MWZMSEG TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	MWZMSEG	181	1	ZMSEG:Interface for Posting of Value	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, GRANT_NBR, BUDGET_PD FROM MWZMSEG

TOP ERP 6.0 | MWZMSEG 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	*	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	*	MATNR	Allow NULL?
12	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
13	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
14	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	*	SOBKZ	Allow NULL?
19	LIFNR	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ELIFN	Allow NULL?
20	KUNNR	Account Number of Customer	nvarchar	10	0	CHAR	(N' ')	Yes	*	EKUNN	Allow NULL?
21	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	*	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	*	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	*	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	*	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	*	BBPRM	Allow NULL?
39	EBELN	Purchase Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BSTNR	Allow NULL?
40	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	*	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' ')	Yes		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	*	GSBER	Allow NULL?
53	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	KOKRS	Allow NULL?
54	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARGB	Allow NULL?
55	PARBU	Clearing company code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARBU	Allow NULL?
56	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	*	AUFNR	Allow NULL?
59	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
60	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	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	*	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	*	UMMAT	Allow NULL?
79	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	UMWRK	Allow NULL?
80	UMLGO	Receiving/Issuing Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	UMLGO	Allow NULL?
81	UMCHA	Receiving/Issuing Batch	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	*	UMBAR	Allow NULL?
85	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	*	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	*	LGNUM	Allow NULL?
92	LGTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	LGTYP	Allow NULL?
93	LGPLA	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	*	BWLVS	Allow NULL?
96	TBNUM	Transfer Requirement Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	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	*	MB_GRBEW	Allow NULL?
107	EVERS	Shipping Instructions	nvarchar	2	0	CHAR	(N' ')	Yes	*	EVERS	Allow NULL?
108	EVERE	Compliance with Shipping Instructions	nvarchar	2	0	CHAR	(N' ')	Yes	*	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	*	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	*	JV_PART	Allow NULL?
119	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
120	SAKTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	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	decimal	13	3	QUAN	((0))	Yes		LBKUM
155	SALK3	Value of Total Valuated Stock	decimal	13	2	CURR	((0))	Yes		SALK3
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	*	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	*	MWSKZ	Allow NULL?
169	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	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	*	BEMOT	Allow NULL?
180	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
181	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?

TOP ERP 6.0 | MWZMSEG INDEXES

Name	Primary	Unique	Type	Columns
MWZMSEG~0	Yes	Yes	CLUSTERED	ZEILE, MJAHR, MBLNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

181 COLUMNS | 1 INDEXES | ERP 6.0 | MWZMSEG TABLE

TOP ERP 6.0 | MWZMSEG COLUMNS

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

181 COLUMNS | 1 INDEXES | ERP 6.0 | MWZMSEG TABLE

TOPERP 6.0 | MWZMSEG COLUMNS

TOPERP 6.0 | MWZMSEG INDEXES

TOP ERP 6.0 | MWZMSEG COLUMNS

TOP ERP 6.0 | MWZMSEG INDEXES