	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

STG_MM002 TABLE

ERP EHP7

6.0

246

Data staging - Material storage location view complex table

SQL: selectupdate insert create

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

SELECT MANDT, DSF_GUID, DSF_DSTORE_ID, USER_GUID, DSF_RECORD_ID, DSF_CHANGED_BY, DSF_CHANGED_TS, MATNR, VPSTA, MTART, MBRSH, MATKL, BISMT, MEINS, BSTME, ZEINR, ZEIAR, ZEIVR, ZEIFO, AESZN, BLATT, BLANZ, FERTH, FORMT, GROES, WRKST, NORMT, LABOR, EKWSL, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, BEHVO, RAUBE, TEMPB, DISST, TRAGR, STOFF, SPART, KUNNR, EANNR, WESCH, BWVOR, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, KZNFM, PMATA, MSTAE, MSTAV, MSTDE, MSTDV, TAKLV, RBNRM, MHDRZ, MHDHB, MHDLP, INHME, INHAL, VPREH, ETIAG, INHBR, CMETH, CUOBF, KZUMW, KOSCH, SPROF, NRFHG, MFRPN, MFRNR, BMATN, MPROF, KZWSM, SAITY, PROFL, IHIVI, ILOOS, SERLV, KZGVH, XGCHP, KZEFF, IPRKZ, RDMHD, PRZUS, MTPOS_MARA, BFLME, MATFI, CMREL, BBTYP, SLED_BBD, GTIN_VARIANT, GENNR, RMATP, GDS_RELEVANT, WEORA, HUTYP_DFLT, PILFERABLE, WHSTC, WHMATGR, HNDLCODE, HAZMAT, HUTYP, TARE_VAR, MAXC, MAXC_TOL, MAXL, MAXB, MAXH, MAXDIM_UOM, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, /BEV1/LULEINH, /BEV1/LULDEGRP, /DSD/VC_GROUP, /VSO/R_TILT_IND, /VSO/R_STACK_IND, /VSO/R_BOT_IND, /VSO/R_TOP_IND, /VSO/R_STACK_NO, /VSO/R_PAL_IND, /VSO/R_PAL_OVR_D, /VSO/R_PAL_OVR_W, /VSO/R_PAL_B_HT, /VSO/R_PAL_MIN_H, /VSO/R_TOL_B_HT, /VSO/R_NO_P_GVH, /VSO/R_QUAN_UNIT, /VSO/R_KZGVH_IND, MCOND, RETDELC, LOGLEV_RETO, NSNID, IMATN, PICNUM, BSTAT, COLOR_ATINN, SIZE1_ATINN, SIZE2_ATINN, COLOR, SIZE1, SIZE2, FREE_CHAR, CARE_CODE, BRAND_ID, FIBER_CODE1, FIBER_PART1, FIBER_CODE2, FIBER_PART2, FIBER_CODE3, FIBER_PART3, FIBER_CODE4, FIBER_PART4, FIBER_CODE5, FIBER_PART5, FASHGRD, MAKTX, WERKS, LGORT, PSTAT, LVORM, LFGJA, LFMON, SPERR, LABST, UMLME, INSME, EINME, SPEME, RETME, VMLAB, VMUML, VMINS, VMEIN, VMSPE, VMRET, KZILL, KZILQ, KZILE, KZILS, KZVLL, KZVLQ, KZVLE, KZVLS, DISKZ, LSOBS, LMINB, LBSTF, HERKL, EXPPG, EXVER, LGPBE, KLABS, KINSM, KEINM, KSPEM, DLINL, PRCTL, ERSDA, VKLAB, VKUML, LWMKB, BSKRF, MDRUE, MDJIN FROM /SMERP/STG_MM002

TOP ERP 6.0 | /SMERP/STG_MM002 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DSF_GUID	DSF GUID	nvarchar	32	0	Allow NULL?
3	DSF_DSTORE_ID	Data Store ID	nvarchar	40	0	Allow NULL?
4	USER_GUID	User GUID	nvarchar	32	0	Allow NULL?
5	DSF_RECORD_ID	DSF Record ID	nvarchar	10	0	Allow NULL?
6	DSF_CHANGED_BY	Last Changed By	nvarchar	12	0	Allow NULL?
7	DSF_CHANGED_TS	Changed time stamp	decimal	15	0
8	MATNR	Material Number	nvarchar	18	0	Allow NULL?
9	VPSTA	Maintenance status of complete material	nvarchar	15	0	Allow NULL?
10	MTART	Material Type	nvarchar	4	0	Allow NULL?
11	MBRSH	Industry sector	char	1	0	Allow NULL?
12	MATKL	Material Group	nvarchar	9	0	Allow NULL?
13	BISMT	Old material number	nvarchar	18	0	Allow NULL?
14	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
15	BSTME	Purchase Order Unit of Measure	nvarchar	3	0	Allow NULL?
16	ZEINR	Document number (without document management system)	nvarchar	22	0	Allow NULL?
17	ZEIAR	Document type (without Document Management system)	nvarchar	3	0	Allow NULL?
18	ZEIVR	Document version (without Document Management system)	nvarchar	2	0	Allow NULL?
19	ZEIFO	Page format of document (without Document Management system)	nvarchar	4	0	Allow NULL?
20	AESZN	Document change number (without document management system)	nvarchar	6	0	Allow NULL?
21	BLATT	Page number of document (without Document Management system)	nvarchar	3	0	Allow NULL?
22	BLANZ	Number of sheets (without Document Management system)	nvarchar	3	0	Allow NULL?
23	FERTH	Production/inspection memo	nvarchar	18	0	Allow NULL?
24	FORMT	Page Format of Production Memo	nvarchar	4	0	Allow NULL?
25	GROES	Size/dimensions	nvarchar	32	0	Allow NULL?
26	WRKST	Basic Material	nvarchar	48	0	Allow NULL?
27	NORMT	Industry Standard Description (such as ANSI or ISO)	nvarchar	18	0	Allow NULL?
28	LABOR	Laboratory/design office	nvarchar	3	0	Allow NULL?
29	EKWSL	Purchasing Value Key	nvarchar	4	0	Allow NULL?
30	BRGEW	Gross Weight	decimal	13	3
31	NTGEW	Net Weight	decimal	13	3
32	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
33	VOLUM	Volume	decimal	13	3
34	VOLEH	Volume unit	nvarchar	3	0	Allow NULL?
35	BEHVO	Container requirements	nvarchar	2	0	Allow NULL?
36	RAUBE	Storage conditions	nvarchar	2	0	Allow NULL?
37	TEMPB	Temperature conditions indicator	nvarchar	2	0	Allow NULL?
38	DISST	Low-Level Code	nvarchar	3	0	Allow NULL?
39	TRAGR	Transportation Group	nvarchar	4	0	Allow NULL?
40	STOFF	Hazardous material number	nvarchar	18	0	Allow NULL?
41	SPART	Division	nvarchar	2	0	Allow NULL?
42	KUNNR	Competitor	nvarchar	10	0	Allow NULL?
43	EANNR	European Article Number (EAN) - obsolete!!!!!	nvarchar	13	0	Allow NULL?
44	WESCH	Quantity: Number of GR/GI slips to be printed	decimal	13	3
45	BWVOR	Procurement rule	char	1	0	Allow NULL?
46	SAISO	Season Category	nvarchar	4	0	Allow NULL?
47	ETIAR	Label type	nvarchar	2	0	Allow NULL?
48	ETIFO	Label form	nvarchar	2	0	Allow NULL?
49	ENTAR	Deactivated	char	1	0	Allow NULL?
50	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	Allow NULL?
51	NUMTP	Category of International Article Number (EAN)	nvarchar	2	0	Allow NULL?
52	LAENG	Length	decimal	13	3
53	BREIT	Width	decimal	13	3
54	HOEHE	Height	decimal	13	3
55	MEABM	Unit of Dimension for Length/Width/Height	nvarchar	3	0	Allow NULL?
56	PRDHA	Product hierarchy	nvarchar	18	0	Allow NULL?
57	AEKLK	Stock Transfer Net Change Costing	char	1	0	Allow NULL?
58	CADKZ	CAD Indicator	char	1	0	Allow NULL?
59	QMPUR	QM in Procurement is Active	char	1	0	Allow NULL?
60	ERGEW	Allowed packaging weight	decimal	13	3
61	ERGEI	Unit of weight (allowed packaging weight)	nvarchar	3	0	Allow NULL?
62	ERVOL	Allowed packaging volume	decimal	13	3
63	ERVOE	Volume unit (allowed packaging volume)	nvarchar	3	0	Allow NULL?
64	GEWTO	Excess Weight Tolerance for Handling unit	decimal	3	1
65	VOLTO	Excess Volume Tolerance of the Handling Unit	decimal	3	1
66	VABME	Variable Purchase Order Unit Active	char	1	0	Allow NULL?
67	KZREV	Revision Level Has Been Assigned to the Material	char	1	0	Allow NULL?
68	KZKFG	Configurable Material	char	1	0	Allow NULL?
69	VHART	Packaging Material Type	nvarchar	4	0	Allow NULL?
70	FUELG	Maximum level (by volume)	decimal	3	0
71	STFAK	Stacking factor	smallint	5	0
72	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	Allow NULL?
73	BEGRU	Authorization Group	nvarchar	4	0	Allow NULL?
74	DATAB	Valid-From Date	nvarchar	8	0	Allow NULL?
75	LIQDT	Deletion date	nvarchar	8	0	Allow NULL?
76	SAISJ	Season Year	nvarchar	4	0	Allow NULL?
77	PLGTP	Price Band Category	nvarchar	2	0	Allow NULL?
78	MLGUT	Empties Bill of Material	char	1	0	Allow NULL?
79	EXTWG	External Material Group	nvarchar	18	0	Allow NULL?
80	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	Allow NULL?
81	ATTYP	Material Category	nvarchar	2	0	Allow NULL?
82	KZNFM	Indicator: The material has a follow-up material	char	1	0	Allow NULL?
83	PMATA	Pricing Reference Material	nvarchar	18	0	Allow NULL?
84	MSTAE	Cross-Plant Material Status	nvarchar	2	0	Allow NULL?
85	MSTAV	Cross-distribution-chain material status	nvarchar	2	0	Allow NULL?
86	MSTDE	Date from which the cross-plant material status is valid	nvarchar	8	0	Allow NULL?
87	MSTDV	Date from which the X-distr.-chain material status is valid	nvarchar	8	0	Allow NULL?
88	TAKLV	Tax classification of the material	char	1	0	Allow NULL?
89	RBNRM	Catalog Profile	nvarchar	9	0	Allow NULL?
90	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0
91	MHDHB	Total shelf life	decimal	4	0
92	MHDLP	Storage percentage	decimal	3	0
93	INHME	Content unit	nvarchar	3	0	Allow NULL?
94	INHAL	Net contents	decimal	13	3
95	VPREH	Comparison price unit	decimal	5	0
96	ETIAG	IS-R Labeling: material grouping (deactivated in 4.0)	nvarchar	18	0	Allow NULL?
97	INHBR	Gross contents	decimal	13	3
98	CMETH	Quantity Conversion Method	char	1	0	Allow NULL?
99	CUOBF	Internal object number	nvarchar	18	0	Allow NULL?
100	KZUMW	Environmentally Relevant	char	1	0	Allow NULL?
101	KOSCH	Product allocation determination procedure	nvarchar	18	0	Allow NULL?
102	SPROF	Pricing profile for variants	char	1	0	Allow NULL?
103	NRFHG	Material qualifies for discount in kind	char	1	0	Allow NULL?
104	MFRPN	Manufacturer Part Number	nvarchar	40	0	Allow NULL?
105	MFRNR	Number of a Manufacturer	nvarchar	10	0	Allow NULL?
106	BMATN	Number of firm's own (internal) inventory-managed material	nvarchar	18	0	Allow NULL?
107	MPROF	Manufacturer Part Profile	nvarchar	4	0	Allow NULL?
108	KZWSM	Units of measure usage	char	1	0	Allow NULL?
109	SAITY	Rollout in a Season	nvarchar	2	0	Allow NULL?
110	PROFL	Dangerous Goods Indicator Profile	nvarchar	3	0	Allow NULL?
111	IHIVI	Indicator: Highly Viscous	char	1	0	Allow NULL?
112	ILOOS	Indicator: In Bulk/Liquid	char	1	0	Allow NULL?
113	SERLV	Level of Explicitness for Serial Number	char	1	0	Allow NULL?
114	KZGVH	Packaging Material is Closed Packaging	char	1	0	Allow NULL?
115	XGCHP	Indicator: Approved batch record required	char	1	0	Allow NULL?
116	KZEFF	Assign effectivity parameter values/ override change numbers	char	1	0	Allow NULL?
117	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	Allow NULL?
118	RDMHD	Rounding rule for calculation of SLED	char	1	0	Allow NULL?
119	PRZUS	Indicator: Product composition printed on packaging	char	1	0	Allow NULL?
120	MTPOS_MARA	General item category group	nvarchar	4	0	Allow NULL?
121	BFLME	Generic Material with Logistical Variants	char	1	0	Allow NULL?
122	MATFI	Material Is Locked	char	1	0	Allow NULL?
123	CMREL	Relevant for Configuration Management	char	1	0	Allow NULL?
124	BBTYP	Assortment List Type	char	1	0	Allow NULL?
125	SLED_BBD	Expiration Date	char	1	0	Allow NULL?
126	GTIN_VARIANT	Global Trade Item Number Variant	nvarchar	2	0	Allow NULL?
127	GENNR	Material Number of the Generic Material in Prepack Materials	nvarchar	18	0	Allow NULL?
128	RMATP	Reference material for materials packed in same way	nvarchar	18	0	Allow NULL?
129	GDS_RELEVANT	Indicator: Global Data Synchronization-Relevant	char	1	0	Allow NULL?
130	WEORA	Acceptance At Origin	char	1	0	Allow NULL?
131	HUTYP_DFLT	Standard HU Type	nvarchar	4	0	Allow NULL?
132	PILFERABLE	Pilferable	char	1	0	Allow NULL?
133	WHSTC	Warehouse Storage Condition	nvarchar	2	0	Allow NULL?
134	WHMATGR	Warehouse Material Group	nvarchar	4	0	Allow NULL?
135	HNDLCODE	Handling Indicator	nvarchar	4	0	Allow NULL?
136	HAZMAT	Relevant for Hazardous Substances	char	1	0	Allow NULL?
137	HUTYP	Handling Unit Type	nvarchar	4	0	Allow NULL?
138	TARE_VAR	Variable Tare Weight	char	1	0	Allow NULL?
139	MAXC	Maximum Allowed Capacity of Packaging Material	decimal	15	3
140	MAXC_TOL	Overcapacity Tolerance of the Handling Unit	decimal	3	1
141	MAXL	Maximum Packing Length of Packaging Material	decimal	15	3
142	MAXB	Maximum Packing Width of Packaging Material	decimal	15	3
143	MAXH	Maximum Packing Height of Packaging Material	decimal	15	3
144	MAXDIM_UOM	Unit of Measure for Maximum Packing Length/Width/Height	nvarchar	3	0	Allow NULL?
145	QQTIME	Quarantine Period	decimal	3	0
146	QQTIMEUOM	Time Unit for Quarantine Period	nvarchar	3	0	Allow NULL?
147	QGRP	Quality Inspection Group	nvarchar	4	0	Allow NULL?
148	SERIAL	Serial Number Profile	nvarchar	4	0	Allow NULL?
149	PS_SMARTFORM	Form Name	nvarchar	30	0	Allow NULL?
150	LOGUNIT	EWM CW: Logistics Unit of Measure	nvarchar	3	0	Allow NULL?
151	CWQREL	EWM CW: Material Is a Catch Weight Material	char	1	0	Allow NULL?
152	CWQPROC	EWM CW: Catch Weight Profile for Entering CW Quantity	nvarchar	2	0	Allow NULL?
153	CWQTOLGR	EWM-CW: Catch Weight Tolerance Group for EWM	nvarchar	9	0	Allow NULL?
154	/BEV1/LULEINH	Loading Units	nvarchar	8	0	Allow NULL?
155	/BEV1/LULDEGRP	Loading Unit Group: IS Beverage	nvarchar	3	0	Allow NULL?
156	/DSD/VC_GROUP	DSD Grouping	nvarchar	6	0	Allow NULL?
157	/VSO/R_TILT_IND	Material may be Tilted (Vehicle Space Optimization)	char	1	0	Allow NULL?
158	/VSO/R_STACK_IND	Stacking not Allowed (VSO)	char	1	0	Allow NULL?
159	/VSO/R_BOT_IND	Bottom Layer (Vehicle Space Optimization)	char	1	0	Allow NULL?
160	/VSO/R_TOP_IND	Top Layer (VSO)	char	1	0	Allow NULL?
161	/VSO/R_STACK_NO	Stacking Factor (Vehicle Space Optimization)	nvarchar	3	0	Allow NULL?
162	/VSO/R_PAL_IND	Load without Packaging Material (VSO)	char	1	0	Allow NULL?
163	/VSO/R_PAL_OVR_D	Permissible Overhang (Depth) of Packaging Material (VSO)	decimal	13	3
164	/VSO/R_PAL_OVR_W	Permissible Overhang (Width) of Shipping Material (VSO)	decimal	13	3
165	/VSO/R_PAL_B_HT	Maximum Stacking Height of the Packaging Material (VSO)	decimal	13	3
166	/VSO/R_PAL_MIN_H	Minimum Stacking Height of the Packaging Material (VSO)	decimal	13	3
167	/VSO/R_TOL_B_HT	Tolerance to Exceed the Max. Stacking Height (VSO)	decimal	13	3
168	/VSO/R_NO_P_GVH	Number of Materials for each Closed PKM (VSO)	nvarchar	2	0	Allow NULL?
169	/VSO/R_QUAN_UNIT	Unit of Measure Vehicle Space Optimization	nvarchar	3	0	Allow NULL?
170	/VSO/R_KZGVH_IND	Closed Packaging Material Required (VSO)	char	1	0	Allow NULL?
171	MCOND	Material Condition Management	char	1	0	Allow NULL?
172	RETDELC	Return Code	char	1	0	Allow NULL?
173	LOGLEV_RETO	Return to Logistics Level	char	1	0	Allow NULL?
174	NSNID	NATO Item Identification Number	nvarchar	9	0	Allow NULL?
175	IMATN	FFF class	nvarchar	18	0	Allow NULL?
176	PICNUM	Supersession chain number	nvarchar	18	0	Allow NULL?
177	BSTAT	Creation Status - Seasonal Procurement	nvarchar	2	0	Allow NULL?
178	COLOR_ATINN	Internal Charactieristic Number for Color Characteristics	nvarchar	10	0	Allow NULL?
179	SIZE1_ATINN	Internal Char. Number for Characteristics for Main Sizes	nvarchar	10	0	Allow NULL?
180	SIZE2_ATINN	Internal Char. Number for Characteristics for Second Sizes	nvarchar	10	0	Allow NULL?
181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0	Allow NULL?
182	SIZE1	Characteristic Value for Main Sizes of Variants	nvarchar	18	0	Allow NULL?
183	SIZE2	Characteristic Value for Second Size for Variants	nvarchar	18	0	Allow NULL?
184	FREE_CHAR	Characteristic Value for Evaluation Purposes	nvarchar	18	0	Allow NULL?
185	CARE_CODE	Care Codes (such as Washing Code, Ironing Code, etc.)	nvarchar	16	0	Allow NULL?
186	BRAND_ID	Brand	nvarchar	4	0	Allow NULL?
187	FIBER_CODE1	Fiber Code for Textiles (Component 1)	nvarchar	3	0	Allow NULL?
188	FIBER_PART1	Percentage Share of Fiber (Component 1)	nvarchar	3	0	Allow NULL?
189	FIBER_CODE2	Fiber Code for Textiles (Component 2)	nvarchar	3	0	Allow NULL?
190	FIBER_PART2	Percentage Share of Fiber (Component 2)	nvarchar	3	0	Allow NULL?
191	FIBER_CODE3	Fiber Code for Textiles (Component 3)	nvarchar	3	0	Allow NULL?
192	FIBER_PART3	Percentage Share of Fiber (Component 3)	nvarchar	3	0	Allow NULL?
193	FIBER_CODE4	Fiber Code for Textiles (Component 4)	nvarchar	3	0	Allow NULL?
194	FIBER_PART4	Percentage Share of Fiber (Component 4)	nvarchar	3	0	Allow NULL?
195	FIBER_CODE5	Fiber Code for Textiles (Component 5)	nvarchar	3	0	Allow NULL?
196	FIBER_PART5	Percentage Share of Fiber (Component 5)	nvarchar	3	0	Allow NULL?
197	FASHGRD	Fashion Grade	nvarchar	4	0	Allow NULL?
198	MAKTX	Material Description (Short Text)	nvarchar	40	0	Allow NULL?
199	WERKS	Plant	nvarchar	4	0	Allow NULL?
200	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
201	PSTAT	Maintenance status	nvarchar	15	0	Allow NULL?
202	LVORM	Flag Material for Deletion at Storage Location Level	char	1	0	Allow NULL?
203	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	Allow NULL?
204	LFMON	Current period (posting period)	nvarchar	2	0	Allow NULL?
205	SPERR	Physical Inventory Blocking Indicator	char	1	0	Allow NULL?
206	LABST	Valuated Unrestricted-Use Stock	decimal	13	3
207	UMLME	Stock in transfer (from one storage location to another)	decimal	13	3
208	INSME	Stock in Quality Inspection	decimal	13	3
209	EINME	Total Stock of All Restricted Batches	decimal	13	3
210	SPEME	Blocked Stock	decimal	13	3
211	RETME	Blocked Stock Returns	decimal	13	3
212	VMLAB	Valuated unrestricted-use stock in previous period	decimal	13	3
213	VMUML	Stock in Transfer in Previous Period	decimal	13	3
214	VMINS	Stock in Quality Inspection in Previous Period	decimal	13	3
215	VMEIN	Restricted-Use Stock in Previous Period	decimal	13	3
216	VMSPE	Blocked stock of previous period	decimal	13	3
217	VMRET	Blocked Stock Returns in Previous Period	decimal	13	3
218	KZILL	Physical inventory indicator for whse stock in current year	nvarchar	3	0	Allow NULL?
219	KZILQ	Phys. inventory ind. f. stock in qual. insp. in current year	nvarchar	3	0	Allow NULL?
220	KZILE	Physical inventory indicator for restricted-use stock	nvarchar	3	0	Allow NULL?
221	KZILS	Physical inventory indicator for blocked stock	nvarchar	3	0	Allow NULL?
222	KZVLL	Physical inventory indicator for stock in previous year	nvarchar	3	0	Allow NULL?
223	KZVLQ	Phys. inventory ind. f. stock in qual. insp. in prev. period	nvarchar	3	0	Allow NULL?
224	KZVLE	Physical inventory ind. for restricted-use stock, prev.pd	nvarchar	3	0	Allow NULL?
225	KZVLS	Phys. inventory indicator for blocked stock in prev. period	nvarchar	3	0	Allow NULL?
226	DISKZ	Storage location MRP indicator	char	1	0	Allow NULL?
227	LSOBS	Special procurement type at storage location level	nvarchar	2	0	Allow NULL?
228	LMINB	Reorder point for storage location MRP	decimal	13	3
229	LBSTF	Replenishment quantity for storage location MRP	decimal	13	3
230	HERKL	Country of origin of the material	nvarchar	3	0	Allow NULL?
231	EXPPG	Preference indicator (deactivated)	char	1	0	Allow NULL?
232	EXVER	Export indicator (deactivated)	nvarchar	2	0	Allow NULL?
233	LGPBE	Storage Bin	nvarchar	10	0	Allow NULL?
234	KLABS	Unrestricted-Use Consignment Stock	decimal	13	3
235	KINSM	Consignment Stock in Quality Inspection	decimal	13	3
236	KEINM	Restricted-Use Consignment Stock	decimal	13	3
237	KSPEM	Blocked Consignment Stock	decimal	13	3
238	DLINL	Date of Last Posted Count for Unrestricted-Use Stock	nvarchar	8	0	Allow NULL?
239	PRCTL	Profit Center	nvarchar	10	0	Allow NULL?
240	ERSDA	Created On	nvarchar	8	0	Allow NULL?
241	VKLAB	Stock value of a value-only material at sales price	decimal	13	2
242	VKUML	Sales value in stock transfer (SLOc to SLoc)	decimal	13	2
243	LWMKB	Picking area for lean WM	nvarchar	3	0	Allow NULL?
244	BSKRF	Inventory correction factor	float	15	16
245	MDRUE	MARDH rec. already exists for per. before last of MARD per.	char	1	0	Allow NULL?
246	MDJIN	Fiscal year of current physical inventory indicator	nvarchar	4	0	Allow NULL?

TOP ERP 6.0 | /SMERP/STG_MM002 INDEXES

Name	Primary	Unique	Type	Columns
/SMERP/STG_MM00200	No	No	NONCLUSTERED	DSF_RECORD_ID, MANDT
/SMERP/STG_MM002A0	No	No	NONCLUSTERED	DSF_DSTORE_ID, MANDT
/SMERP/STG_MM002~0	Yes	Yes	CLUSTERED	DSF_GUID, 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

246 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_MM002 TABLE

TOP ERP 6.0 | /SMERP/STG_MM002 COLUMNS

TOP ERP 6.0 | /SMERP/STG_MM002 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

246 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_MM002 TABLE

TOPERP 6.0 | /SMERP/STG_MM002 COLUMNS

TOPERP 6.0 | /SMERP/STG_MM002 INDEXES

TOP ERP 6.0 | /SMERP/STG_MM002 COLUMNS

TOP ERP 6.0 | /SMERP/STG_MM002 INDEXES