SAP ABAP Table MGV_M_MAT1MPN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_M_MAT1MPN	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR_HTN	☑	MATNR	MATNR	CHAR	18	0	Material Number
3	TEXT_HTN	☑	MAKTG	CHAR40	CHAR	40	0	Material description in upper case for matchcodes
4	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
6	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
7	MATNR_B	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
8	MATNR_HTN_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
9	MATNR_B_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_M_MAT1MPN	MANDT	T000	MANDT	KEY	1	CN
2	MGV_M_MAT1MPN	MATNR_B	MARA	MATNR
3	MGV_M_MAT1MPN	MFRNR	LFA1	LIFNR
4	MGV_M_MAT1MPN	SPRAS	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in