/SMERP/STG_MM002 - Data staging - Material storage location view complex table

Data staging - Material storage location view complex table information is stored in SAP table /SMERP/STG_MM002.
It is part of development package /SMERP/MDO_MM in software component MOB-APP-MAO-ERP. This development package consists of objects that can be grouped under "MDO Framework - Materials Management".

Fields for table /SMERP/STG_MM002

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DSF_GUID	DSF GUID	X	/SMFND/DSF_GUID_DTE	CHAR	64
.INCLUDE				/SMFND/DSF_REQ_FLDS_STR	0
DSF_DSTORE_ID	Data Store ID		/SMFND/DSF_DSTORE_ID_DTE	CHAR	80	*
USER_GUID	User GUID		/SYCLO/CORE_USER_GUID_DTE	CHAR	64
DSF_RECORD_ID	DSF Record ID		/SMFND/DSF_RECORD_ID_DTE	NUMC	20
DSF_CHANGED_BY	Last Changed By		/SYCLO/CORE_CHANGEDBY_DTE	CHAR	24
DSF_CHANGED_TS	Changed time stamp		/SYCLO/CORE_CHANGEDTS_DTE	DEC	8
MATNR	Material Number		MATNR	CHAR	80
.INCLUDE				/SYCLO/MM_MARA_COMMON_STR	0
VPSTA	Maintenance status of complete material		VPSTA	CHAR	30
MTART	Material type		MTART	CHAR	8	T134
MBRSH	Industry Sector		MBRSH	CHAR	2	T137
MATKL	Material Group		MATKL	CHAR	18	T023
BISMT	Old material number		BISMT	CHAR	80
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
BSTME	Purchase Order Unit of Measure		BSTME	UNIT	6	T006
AESZN	Document change number (without document management system)		AESZN	CHAR	12
BLATT	Page number of document (without Document Management system)		BLATT	CHAR	6
BLANZ	Number of sheets (without Document Management system)		BLANZ	NUMC	6
FERTH	Production/inspection memo		FERTH	CHAR	36
FORMT	Page Format of Production Memo		FORMT	CHAR	8
GROES	Size/dimensions		GROES	CHAR	64
WRKST	Basic Material		WRKST	CHAR	96	TWSPR
NORMT	Industry Standard Description (such as ANSI or ISO)		NORMT	CHAR	36
LABOR	Laboratory/design office		LABOR	CHAR	6	T024L
EKWSL	Purchasing Value Key		EKWSL	CHAR	8	T405
BRGEW	Gross weight		BRGEW	QUAN	7
NTGEW	Net weight		NTGEW	QUAN	7
GEWEI	Weight Unit		GEWEI	UNIT	6	T006
VOLUM	Volume		VOLUM	QUAN	7
VOLEH	Volume unit		VOLEH	UNIT	6	T006
BEHVO	Container requirements		BEHVO	CHAR	4	T144
RAUBE	Storage conditions		RAUBE	CHAR	4	T142
TEMPB	Temperature conditions indicator		TEMPB	CHAR	4	T143
DISST	Low-Level Code		DISST	CHAR	6
TRAGR	Transportation Group		TRAGR	CHAR	8	TTGR
STOFF	Hazardous material number		STOFF	CHAR	80	MGEF
SPART	Division		SPART	CHAR	4	TSPA
KUNNR	Competitor		WETTB	CHAR	20	V_KNA1WETT
EANNR	European Article Number (EAN) - obsolete!!!!!		EANNR	CHAR	26
WESCH	Quantity: Number of GR/GI slips to be printed		WESCH	QUAN	7
BWVOR	Procurement rule		BWVOR	CHAR	2	T6WP1
SAISO	Season Category		SAISO	CHAR	8	T6WSP
ETIAR	Label type		ETIAR	CHAR	4	T6WP3
ETIFO	Label form		ETIFO	CHAR	4	T6WP4
ENTAR	Deactivated		DUMMYENTAR	CHAR	2
EAN11	International Article Number (EAN/UPC)		EAN11	CHAR	36
NUMTP	Category of International Article Number (EAN)		NUMTP	CHAR	4	TNTP
LAENG	Length		LAENG	QUAN	7
BREIT	Width		BREIT	QUAN	7
HOEHE	Height		HOEHE	QUAN	7
MEABM	Unit of Dimension for Length/Width/Height		MEABM	UNIT	6	T006
PRDHA	Product hierarchy		PRODH_D	CHAR	36	T179
AEKLK	Stock Transfer Net Change Costing		CK_AEKLK	CHAR	2
CADKZ	CAD Indicator		CADKZ	CHAR	2
QMPUR	QM in Procurement Is Active		QMPUR	CHAR	2
ERGEW	Allowed packaging weight		ERGEW	QUAN	7
ERGEI	Unit of weight (allowed packaging weight)		ERGEI	UNIT	6	T006
ERVOL	Allowed packaging volume		ERVOL	QUAN	7
ERVOE	Volume unit (allowed packaging volume)		ERVOE	UNIT	6	T006
GEWTO	Excess Weight Tolerance for Handling unit		GEWTO	DEC	2
VOLTO	Excess Volume Tolerance of the Handling Unit		VOLTO	DEC	2
VABME	Variable Purchase Order Unit Active		VABME	CHAR	2
KZREV	Revision Level Has Been Assigned to the Material		KZREV	CHAR	2
KZKFG	Configurable Material		KZKFG	CHAR	2
VHART	Packaging Material Type		VHIART	CHAR	8	TVTY
FUELG	Maximum level (by volume)		FUELG	DEC	2
STFAK	Stacking factor		STFAK	INT2	2
MAGRV	Material Group: Packaging Materials		MAGRV	CHAR	8	TVEGR
BEGRU	Authorization Group		BEGRU	CHAR	8
DATAB	Valid-From Date		DATAB	DATS	16
LIQDT	Deletion date		LIQDT	DATS	16
SAISJ	Season Year		SAISJ	CHAR	8
PLGTP	Price Band Category		PLGTP	CHAR	4	TWPT
MLGUT	Empties Bill of Material		W_MITLEERG	CHAR	2
EXTWG	External Material Group		EXTWG	CHAR	36	TWEW
SATNR	Cross-Plant Configurable Material		SATNR	CHAR	80	MARA
ATTYP	Material Category		ATTYP	CHAR	4
KZNFM	Indicator: The material has a follow-up material		KZNFM	CHAR	2
PMATA	Pricing Reference Material		PMATN	CHAR	80	MARA
MSTAE	Cross-Plant Material Status		MSTAE	CHAR	4	T141
MSTAV	Cross-distribution-chain material status		MSTAV	CHAR	4	TVMS
MSTDE	Date from which the cross-plant material status is valid		MSTDE	DATS	16
MSTDV	Date from which the X-distr.-chain material status is valid		MSTDV	DATS	16
TAKLV	Tax classification of the material		TAKLV	CHAR	2	TSKM
RBNRM	Catalog Profile		RBNR	CHAR	18	T352B
MHDRZ	Minimum Remaining Shelf Life		MHDRZ	DEC	3
MHDHB	Total shelf life		MHDHB	DEC	3
MHDLP	Storage percentage		MHDLP	DEC	2
INHME	Content unit		INHME	UNIT	6	T006
INHAL	Net contents		INHAL	QUAN	7
VPREH	Comparison price unit		VPREH	DEC	3
ETIAG	IS-R Labeling: material grouping (deactivated in 4.0)		ETIAG	CHAR	36	*
INHBR	Gross contents		INHBR	QUAN	7
CMETH	Quantity Conversion Method		OIB_CMETH	CHAR	2
CUOBF	Internal object number		CUOBM	NUMC	36
KZUMW	Environmentally Relevant		KZUMW	CHAR	2
KOSCH	Product allocation determination procedure		KOSCH	CHAR	36	T190S
SPROF	Pricing profile for variants		SPROF	CHAR	2
NRFHG	Material qualifies for discount in kind		NRFHG	CHAR	2
MFRPN	Manufacturer Part Number		MFRPN	CHAR	80
MFRNR	Manufacturer number		MFRNR	CHAR	20	LFA1
BMATN	Number of firm's own (internal) inventory-managed material		MPMAT	CHAR	80	MARA
MPROF	Mfr part profile		MPROF	CHAR	8	TMPPF
KZWSM	Units of measure usage		KZWSO	CHAR	2
SAITY	Rollout in a Season		SAITY	CHAR	4	T6WSA
PROFL	Dangerous Goods Indicator Profile		ADGE_PROFL	CHAR	6	TDG41
IHIVI	Indicator: Highly Viscous		ADGE_IHIVI	CHAR	2
ILOOS	Indicator: In Bulk/Liquid		ADGE_ILOOS	CHAR	2
SERLV	Level of Explicitness for Serial Number		SERLV	CHAR	2
KZGVH	Packaging Material is Closed Packaging		KZGVH	CHAR	2
XGCHP	Approved Batch Record Required		XGCHP	CHAR	2
KZEFF	Assign effectivity parameter values/ override change numbers		CC_MTEFF	CHAR	2
IPRKZ	Period Indicator for Shelf Life Expiration Date		DATTP	CHAR	2
RDMHD	Rounding rule for calculation of SLED		RDMHD	CHAR	2
PRZUS	Indicator: Product composition printed on packaging		PRZUS	CHAR	2
MTPOS_MARA	General item category group		MTPOS_MARA	CHAR	8	TPTM
BFLME	Generic Material with Logistical Variants		BFLME	CHAR	2
MATFI	Material Is Locked		MATFI	CHAR	2
CMREL	Relevant for Configuration Management		DE_CM_RELEVANCE_FLAG	CHAR	2
BBTYP	Assortment List Type		BBTYP	CHAR	2	*
SLED_BBD	Expiration Date		SLED_BBD	CHAR	2
GTIN_VARIANT	Global Trade Item Number Variant		GTIN_VARIANT	CHAR	4
GENNR	Material Number of the Generic Material in Prepack Materials		WSTR_SATNR_PP	CHAR	80	MARA
RMATP	Reference material for materials packed in same way		PL_RMATP	CHAR	80	MARA
GDS_RELEVANT	Indicator: Global Data Synchronization-Relevant		GDS_RELEVANT	CHAR	2
WEORA	Acceptance At Origin		WEORA	CHAR	2
HUTYP_DFLT	Standard HU Type		CIFHUTYPDF	CHAR	8	THUTYP
PILFERABLE	Pilferable		CIFPILFRBL	CHAR	2
WHSTC	Warehouse Storage Condition		CIFWHSTC	CHAR	4	TWHSTC
WHMATGR	Warehouse Material Group		CIFWHMATGR	CHAR	8	TWHMATGR
HNDLCODE	Handling Indicator		CIFHDLCODE	CHAR	8	THNDLCD
HAZMAT	Relevant for Hazardous Substances		CIFHAZMAT	CHAR	2
HUTYP	Handling Unit Type		CIFHUTYP	CHAR	8	THUTYP
TARE_VAR	Variable Tare Weight		CIFTAREVAR	CHAR	2
MAXC	Maximum Allowed Capacity of Packaging Material		CIFMAXC	DEC	8
MAXC_TOL	Overcapacity Tolerance of the Handling Unit		CIFMAXCTOL	DEC	2
MAXL	Maximum Packing Length of Packaging Material		CIFMAXL	QUAN	8
MAXB	Maximum Packing Width of Packaging Material		CIFMAXB	QUAN	8
MAXH	Maximum Packing Height of Packaging Material		CIFMAXH	QUAN	8
MAXDIM_UOM	Unit of Measure for Maximum Packing Length/Width/Height		CIFMAXDUOM	UNIT	6	T006
QQTIME	Quarantine Period		CIFQQTIME	QUAN	2
QQTIMEUOM	Time Unit for Quarantine Period		CIFQQTIMEUOM	UNIT	6	T006
QGRP	Quality Inspection Group		CIFQGRP	CHAR	8	TQGRP
SERIAL	Serial Number Profile		CIFSERIAL	CHAR	8	TSERIAL
PS_SMARTFORM	Form Name		CIFPSSFNAME	CHAR	60	STXFADM
LOGUNIT	EWM CW: Logistics Unit of Measure		CIFLOGUNIT	UNIT	6	MARM
CWQREL	EWM CW: Material Is a Catch Weight Material		CIFCWQREL	CHAR	2
CWQPROC	EWM CW: Catch Weight Profile for Entering CW Quantity		CIFCWQPROC	CHAR	4	TCWQPROC
CWQTOLGR	Catch Weight Tolerance Group		CIFCWQTOLGR	CHAR	18	TCWQTOLGR
.INCLUDE				/BEV1/LUTRANSP	0
/BEV1/LULEINH	Loading Units		/BEV1/LULEINH	NUMC	16
/BEV1/LULDEGRP	Loading Unit Group: IS Beverage		/BEV1/LULDEGRP	CHAR	6	/BEV1/LUT906
.INCLUDE				/DSD/VC_MARA_I	0
/DSD/VC_GROUP	DSD Grouping		/DSD/VC_GROUP	CHAR	12	/DSD/VC_GRP
.INCLUDE				/VSO/R_MARA_I	0
/VSO/R_TILT_IND	Material may be Tilted (Vehicle Space Optimization)		/VSO/M_TILT_IND	CHAR	2
/VSO/R_STACK_IND	Stacking not Allowed (VSO)		/VSO/M_STACK_IND	CHAR	2
/VSO/R_BOT_IND	Bottom Layer (Vehicle Space Optimization)		/VSO/M_BOTTOM_IND	CHAR	2
/VSO/R_TOP_IND	Top Layer (VSO)		/VSO/M_TOP_IND	CHAR	2
/VSO/R_STACK_NO	Stacking Factor (Vehicle Space Optimization)		/VSO/M_STACK_NO	NUMC	6
/VSO/R_PAL_IND	Load without Packaging Material (VSO)		/VSO/M_PALLET_IND	CHAR	2
/VSO/R_PAL_OVR_D	Permissible Overhang (Depth) of Packaging Material (VSO)		/VSO/R_PAL_OVR_D	QUAN	7
/VSO/R_PAL_OVR_W	Permissible Overhang (Width) of Shipping Material (VSO)		/VSO/R_PAL_OVR_W	QUAN	7
/VSO/R_PAL_B_HT	Maximum Stacking Height of the Packaging Material (VSO)		/VSO/R_PAL_BIN_HGT	QUAN	7
/VSO/R_PAL_MIN_H	Minimum Stacking Height of the Packaging Material (VSO)		/VSO/R_PAL_MIN_HT	QUAN	7
/VSO/R_TOL_B_HT	Tolerance to Exceed the Max. Stacking Height (VSO)		/VSO/R_TOL_BIN_HT	QUAN	7
/VSO/R_NO_P_GVH	Number of Materials for each Closed PKM (VSO)		/VSO/M_ANZ_PER_GVH	NUMC	4
/VSO/R_QUAN_UNIT	Unit of Measure Vehicle Space Optimization		/VSO/R_QUAN_UNIT	UNIT	6
/VSO/R_KZGVH_IND	Closed Packaging Material Required (VSO)		/VSO/M_KZGVH_IND	CHAR	2
.INCLUDE				DFPS_MARA_STY	0
MCOND	Material Condition Management		DFPS_MCOND	CHAR	2
RETDELC	Return Code		DFPS_RETDELC	CHAR	2
LOGLEV_RETO	Return to Logistics Level		DFPS_LOGLEV_RETO	CHAR	2
NSNID	NATO Stock Number		DFPS_NSNID	CHAR	18
.INCLUDE				PICST003	0
IMATN	FFF class		IMATN	CHAR	80	*
PICNUM	Supersession chain number		PIC_PICNUM_SUS	CHAR	80
BSTAT	Creation Status - Seasonal Procurement		WRFBSTAT	CHAR	4	*
.INCLUDE				WRF_MARA_STY	0
COLOR_ATINN	Internal Charactieristic Number for Color Characteristics		WRF_COLOR_ATINN	NUMC	20	*
SIZE1_ATINN	Internal Char. Number for Characteristics for Main Sizes		WRF_SIZE1_ATINN	NUMC	20	*
SIZE2_ATINN	Internal Char. Number for Characteristics for Second Sizes		WRF_SIZE2_ATINN	NUMC	20	*
COLOR	Characteristic Value for Colors of Variants		WRF_COLOR	CHAR	36
SIZE1	Characteristic Value for Main Sizes of Variants		WRF_SIZE1	CHAR	36
SIZE2	Characteristic Value for Second Size for Variants		WRF_SIZE2	CHAR	36
FREE_CHAR	Characteristic Value for Evaluation Purposes		WRF_FREE_CHAR	CHAR	36
CARE_CODE	Care Codes (such as Washing Code, Ironing Code, etc.)		WRF_CARE_CODE	CHAR	32
BRAND_ID	Brand		WRF_BRAND_ID	CHAR	8	WRF_BRANDS
FIBER_CODE1	Fiber Code for Textiles (Component 1)		WRF_FIBER_CODE_1	CHAR	6	WRF_FIBER_CODES
FIBER_PART1	Percentage Share of Fiber (Component 1)		WRF_FIBER_PART_1	NUMC	6
FIBER_CODE2	Fiber Code for Textiles (Component 2)		WRF_FIBER_CODE_2	CHAR	6	WRF_FIBER_CODES
FIBER_PART2	Percentage Share of Fiber (Component 2)		WRF_FIBER_PART_2	NUMC	6
FIBER_CODE3	Fiber Code for Textiles (Component 3)		WRF_FIBER_CODE_3	CHAR	6	WRF_FIBER_CODES
FIBER_PART3	Percentage Share of Fiber (Component 3)		WRF_FIBER_PART_3	NUMC	6
FIBER_CODE4	Fiber Code for Textiles (Component 4)		WRF_FIBER_CODE_4	CHAR	6	WRF_FIBER_CODES
FIBER_PART4	Percentage Share of Fiber (Component 4)		WRF_FIBER_PART_4	NUMC	6
FIBER_CODE5	Fiber Code for Textiles (Component 5)		WRF_FIBER_CODE_5	CHAR	6	WRF_FIBER_CODES
FIBER_PART5	Percentage Share of Fiber (Component 5)		WRF_FIBER_PART_5	NUMC	6
FASHGRD	Fashion Grade		FASHGRD	CHAR	8
MAKTX	Material Description		MAKTX	CHAR	80
WERKS	Plant		WERKS_D	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8
.INCLUDE				EMARD	0
PSTAT	Maintenance status		PSTAT_D	CHAR	30
LVORM	Flag Material for Deletion at Storage Location Level		LVOLG	CHAR	2
LFGJA	Fiscal Year of Current Period		LFGJA	NUMC	8
LFMON	Current period (posting period)		LFMON	NUMC	4
SPERR	Physical Inventory Blocking Indicator		SPERR	CHAR	2
LABST	Valuated Unrestricted-Use Stock		LABST	QUAN	7
UMLME	Stock in transfer (from one storage location to another)		UMLMD	QUAN	7
INSME	Stock in Quality Inspection		INSME	QUAN	7
EINME	Total Stock of All Restricted Batches		EINME	QUAN	7
SPEME	Blocked Stock		SPEME	QUAN	7
RETME	Blocked Stock Returns		RETME	QUAN	7
VMLAB	Valuated unrestricted-use stock in previous period		VMLAB	QUAN	7
VMUML	Stock in Transfer in Previous Period		VMUML	QUAN	7
VMINS	Stock in Quality Inspection in Previous Period		VMINS	QUAN	7
VMEIN	Restricted-Use Stock in Previous Period		VMEIN	QUAN	7
VMSPE	Blocked stock of previous period		VMSPE	QUAN	7
VMRET	Blocked Stock Returns in Previous Period		VMRET	QUAN	7
KZILL	Physical inventory indicator for whse stock in current year		KZILL	CHAR	6
KZILQ	Phys. inventory ind. f. stock in qual. insp. in current year		KZILQ	CHAR	6
KZILE	Physical inventory indicator for restricted-use stock		KZILE	CHAR	6
KZILS	Physical inventory indicator for blocked stock		KZILS	CHAR	6
KZVLL	Physical inventory indicator for stock in previous year		KZVLL	CHAR	6
KZVLQ	Phys. inventory ind. f. stock in qual. insp. in prev. period		KZVLQ	CHAR	6
KZVLE	Physical inventory ind. for restricted-use stock, prev.pd		KZVLE	CHAR	6
KZVLS	Phys. inventory indicator for blocked stock in prev. period		KZVLS	CHAR	6
DISKZ	Storage location MRP indicator		DISKZ	CHAR	2
LSOBS	Special procurement type at storage location level		LSOBS	CHAR	4	T460A
LMINB	Reorder point for storage location MRP		LMINB	QUAN	7
LBSTF	Replenishment quantity for storage location MRP		LBSTF	QUAN	7
HERKL	Country/Region of Origin of Material (Non-Preferential Ori.)		HERKL	CHAR	6	T005
EXPPG	Preference indicator (deactivated)		EXPPG	CHAR	2
EXVER	Export indicator (deactivated)		EXVER	CHAR	4
LGPBE	Storage Bin		LGPBE	CHAR	20
KLABS	Unrestricted-Use Consignment Stock		KLABS	QUAN	7
KINSM	Consignment Stock in Quality Inspection		KINSM	QUAN	7
KEINM	Restricted-Use Consignment Stock		KEINM	QUAN	7
KSPEM	Blocked Consignment Stock		KSPEM	QUAN	7
DLINL	Date of Last Posted Count		DLINL	DATS	16
PRCTL	Profit Center		PRCTR	CHAR	20
ERSDA	Created On		ERSDA	DATS	16
VKLAB	Stock value of a value-only material at sales price		VKLAB	CURR	7
VKUML	Sales value in stock transfer (SLOc to SLoc)		VKUML	CURR	7
LWMKB	Picking area for lean WM		MARD_KOBER	CHAR	6	*
BSKRF	Inventory Correction Factor		BSKRF	FLTP	8
MDRUE	MARDH rec. already exists for per. before last of MARD per.		MDRUE	CHAR	2
MDJIN	Fiscal year of current physical inventory indicator		GJINV	NUMC	8
.INCLUDE				STL_INCL_EEW_PS	0
DUMMY_STL_INCL_EEW_PS	MD PRODUCT Storage location		STL_INCL_EEW	CHAR	2