SAP ABAP Table MDG_BS_MAT_S_MP_SEARCH_ATTR (Node for search attributes)

Hierarchy

☛ MDG_APPL (Software Component) MDG Applications
   ⤷ CA-MDG-APP-MM (Application Component) MDG Material
     ⤷ MDG_BS_MAT_SP (Package) MDG: Material Service Provider

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_BS_MAT_S_MP_SEARCH_ATTR	Table Relationship Diagram
Short Description	Node for search attributes

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	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
2	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
3	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
4	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
5	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
6	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
8	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
10	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
11	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
12	TXTMI	☐	USMD_TXTMI	TEXT40	CHAR	40	0	Description (medium text)
13	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
14	EAN	☐	EAN	CHAR1	CHAR	1	0	Text: European (International) Article Number
15	USMD_ACTIVE	☐	USMD_ACTIVE	USMD_ACTIVE	CHAR	1	0	Active/Inactive Data Record
16	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDG_BS_MAT_S_MP_SEARCH_ATTR	EXTWG	TWEW	EXTWG	KEY
2	MDG_BS_MAT_S_MP_SEARCH_ATTR	LABOR	T024L	LABOR
3	MDG_BS_MAT_S_MP_SEARCH_ATTR	MATKL	T023	MATKL
4	MDG_BS_MAT_S_MP_SEARCH_ATTR	MBRSH	T137	MBRSH	KEY
5	MDG_BS_MAT_S_MP_SEARCH_ATTR	MEINS	T006	MSEHI
6	MDG_BS_MAT_S_MP_SEARCH_ATTR	MTART	T134	MTART
7	MDG_BS_MAT_S_MP_SEARCH_ATTR	PRDHA	T179	PRODH
8	MDG_BS_MAT_S_MP_SEARCH_ATTR	SATNR	MARA	MATNR
9	MDG_BS_MAT_S_MP_SEARCH_ATTR	WRKST	TWSPR	WRKST

History

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