SAP Table MATERIALID
Material Identification
MATERIALID (Material Identification) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MATERIALID to other SAP tables.
MATERIALID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| MATNR_INT | Material Number | MATNR_INT | CHAR | 18 | 0 | |||||||||
| MATNR_EXT | External Long Material Number | MATNR_EXT | CHAR | 40 | 0 | |||||||||
| MATNR_VERS | Material Version Number | MATNR_VERS | CHAR | 10 | 0 | |||||||||
| MATNR_GUID | Material Number (Internal GUID) | MATNR_IGUID | RAW | 16 | 0 | |||||||||
| MATNR_TYPE | Material Number Type | MATNR_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||||
| MATNR_HEAD | Header Material for Version | MATNR_HEAD | CHAR | 18 | 0 | |||||||||
| SPTYP | Specialization Category | MGV_SPEC_TYPE | CHAR | 10 | 0 | |||||||||
| MATNR_SEL | External Material Number Plus Version for Selection | MATNR_SEL | CHAR | 51 | 0 | |||||||||
