/SMERP/STG_MM004 - Data staging - Material warehouse view complex table

Data staging - Material warehouse view complex table information is stored in SAP table /SMERP/STG_MM004.
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_MM004

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
LGNUM	Warehouse Number / Warehouse Complex		LGNUM	CHAR	6
.INCLUDE				EMLGN	0
LVORM	Deletion flag for all material data of a warehouse number		LVOLN	CHAR	2
LGBKZ	Storage Section Indicators		LVS_LGBKZ	CHAR	6	T304
LTKZE	Storage type indicator for stock placement		MLGN_LTKZE	CHAR	6	T305
LTKZA	Storage type indicator for stock removal		MLGN_LTKZA	CHAR	6	T305
LHMG1	Loading equipment quantity 1		LVS_LHMNG1	QUAN	7
LHMG2	Loading equipment quantity 2		LVS_LHMNG2	QUAN	7
LHMG3	Loading equipment quantity 3		LVS_LHMNG3	QUAN	7
LHME1	Unit of measure for loading equipment quantity 1		LHMEH1	UNIT	6	T006
LHME2	Unit of measure for loading equipment quantity 2		LHMEH2	UNIT	6	T006
LHME3	Unit of measure for loading equipment quantity 3		LHMEH3	UNIT	6	T006
LETY1	1st storage unit type		LVS_LETYP1	CHAR	6	T307
LETY2	2nd storage unit type		LVS_LETYP2	CHAR	6	T307
LETY3	3rd storage unit type		LVS_LETYP3	CHAR	6	T307
LVSME	Warehouse Management Unit of Measure		LVS_LVSME	UNIT	6	T006
KZZUL	Indicator: Allow addition to existing stock		MLGN_KZZUL	CHAR	2
BLOCK	Bulk Storage Indicators		LVS_BLOCK2	CHAR	4	T338
KZMBF	Indicator: Message to inventory management		KZMBF	CHAR	2
BSSKZ	Special movement indicator for warehouse management		LVS_BSSKZ	CHAR	2	T306
MKAPV	Capacity usage		MLGN_MKAPV	DEC	6
BEZME	Unit of measure for capacity consumption		MLGN_BEZME	UNIT	6	T006
PLKPT	Picking storage type for rough-cut and detailed planning		MLGN_PLKPT	CHAR	6	T301
VOMEM	Default for unit of measure from material master record		MLGN_VOMEM	CHAR	2
L2SKR	Material relevance for 2-step picking		MLGN_L2SKR	CHAR	2