SAP ABAP Table /MDGMM/_S_MM_ES_MATERIAL (Structure for Enterprise Search)

Hierarchy

☛ MDG_APPL (Software Component) MDG Applications
   ⤷ CA-MDG-APP-MM (Application Component) MDG Material
     ⤷ /MDGMM/MDG_BS_MAT_STRUCTURES (Package) MDG: Material generated structures

Basic Data

Table Category	INTTAB	Structure
Structure	/MDGMM/_S_MM_ES_MATERIAL	Table Relationship Diagram
Short Description	Structure for Enterprise Search

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	USMD_ACTIVE	☐	USMD_ACTIVE	USMD_ACTIVE	CHAR	1	0	Active/Inactive Data Record
2	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
4	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
5	CADKZ	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
6	EAN_MARA	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
7	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
8	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
9	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
10	GEWEI_MAT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
11	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
12	GTIN_VAR1	☐	GTIN_VARIANT	GTIN_VARIANT	CHAR	2	0	Global Trade Item Number Variant
13	HAZMAT	☐	CIFHAZMAT	XFELD	CHAR	1	0	Relevant for Hazardous Substances
14	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	*
15	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
16	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
17	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
18	LVORM_MAT	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
19	MATFI	☐	MATFI	XFELD	CHAR	1	0	Material Is Locked
20	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
21	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
22	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
23	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
24	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
25	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
26	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
27	MTPOSMARA	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	*
28	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
29	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
30	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
31	NUMTP1	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
32	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
33	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
34	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
35	SERIAL	☐	CIFSERIAL	CIFSERIAL	CHAR	4	0	Serial Number Profile
36	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
37	TXTMI	☐	USMD_TXTMI	TEXT40	CHAR	40	0	Description (medium text)
38	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	*
39	XCHPFMARA	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
40	XGCHPMARA	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
41	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	605