SAP ABAP Table M_MAT2MPN (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | M_MAT2MPN |
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_B |
MPMAT | MATNR | CHAR | 18 | 0 | Number of firm's own (internal) inventory-managed material | MARA | |
| 3 | MATNR_HTN |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | MARA | |
| 4 | MFRNR |
MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | LFA1 | |
| 5 | WERKS |
WERKS_MASK | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 6 | DATUV |
AMPAB | DATUM | DATS | 8 | 0 | Date as of which the MPN materail may be procured | ||
| 7 | DATUB |
AMPBI | DATUM | DATS | 8 | 0 | Date until which the MPN material may be procured | ||
| 8 | REVLV |
REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
| 9 | AMPSP |
AMPSP | AMPSP | CHAR | 4 | 0 | Blocked manufacturer/part combinations | TAMPSP | |
| 10 | MFRPN |
MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | M_MAT2MPN | AMPSP |  TAMPSP |
AMPSP |
REF | 1 | CN |
| 2 | M_MAT2MPN | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 3 | M_MAT2MPN | MATNR_B | MARA |
MATNR |
KEY | 1 | CN |
| 4 | M_MAT2MPN | MATNR_HTN | MARA |
MATNR |
REF | 1 | CN |
| 5 | M_MAT2MPN | MFRNR | LFA1 |
LIFNR |
REF | 1 | CN |
| 6 | M_MAT2MPN | WERKS | T001W |
WERKS |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
