SAP Table MSTA
Material Master Status
MSTA (Material Master Status) 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 MSTA to other SAP tables.
MSTA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| STATM | Maintenance status of material master record | STATM | T132 | CHAR | 1 | 0 | ||
| ZHLER | Counter | DZHLER | CHAR | 5 | 0 | |||
| ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | 0 | |||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||
| WERKS | Plant | WERKS_D | MARC | CHAR | 4 | 0 | ||
| LGORT | Storage Location | LGORT_D | MARD | CHAR | 4 | 0 | ||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | MLGN | CHAR | 3 | 0 | ||
| LGTYP | Storage Type | LGTYP | MLGT | CHAR | 3 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | MVKE | CHAR | 2 | 0 | ||
| BWKEY | Valuation Area | BWKEY | T001K | CHAR | 4 | 0 | ||
| BWTAR | Valuation Type | BWTAR_D | MBEW | CHAR | 10 | 0 | ||
MSTA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MSTA | BWKEY | MSTA | MANDT | T001K | Valuation area | MANDT |
| MSTA | BWKEY | MSTA | BWKEY | T001K | Valuation area | BWKEY |
| MSTA | BWTAR | MSTA | BWKEY | MBEW | Material Valuation | BWKEY |
| MSTA | BWTAR | MSTA | BWTAR | MBEW | Material Valuation | BWTAR |
| MSTA | BWTAR | MSTA | MANDT | MBEW | Material Valuation | MANDT |
| MSTA | BWTAR | MSTA | MATNR | MBEW | Material Valuation | MATNR |
| MSTA | LGNUM | MSTA | MANDT | MLGN | Material Data for Each Warehouse Number | MANDT |
| MSTA | LGNUM | MSTA | MATNR | MLGN | Material Data for Each Warehouse Number | MATNR |
| MSTA | LGNUM | MSTA | LGNUM | MLGN | Material Data for Each Warehouse Number | LGNUM |
| MSTA | LGORT | MSTA | MATNR | MARD | Storage Location Data for Material | MATNR |
| MSTA | LGORT | MSTA | WERKS | MARD | Storage Location Data for Material | WERKS |
| MSTA | LGORT | MSTA | LGORT | MARD | Storage Location Data for Material | LGORT |
| MSTA | LGORT | MSTA | MANDT | MARD | Storage Location Data for Material | MANDT |
| MSTA | LGTYP | MSTA | MANDT | MLGT | Material Data for Each Storage Type | MANDT |
| MSTA | LGTYP | MSTA | MATNR | MLGT | Material Data for Each Storage Type | MATNR |
| MSTA | LGTYP | MSTA | LGNUM | MLGT | Material Data for Each Storage Type | LGNUM |
| MSTA | LGTYP | MSTA | LGTYP | MLGT | Material Data for Each Storage Type | LGTYP |
| MSTA | MATNR | MSTA | MANDT | MARA | General Material Data | MANDT |
| MSTA | MATNR | MSTA | MATNR | MARA | General Material Data | MATNR |
| MSTA | STATM | MSTA | STATM | T132 | Status definition | STATM |
| MSTA | STATM | MSTA | MANDT | T132 | Status definition | MANDT |
| MSTA | VKORG | MSTA | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| MSTA | VKORG | MSTA | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| MSTA | VTWEG | MSTA | VKORG | MVKE | Sales Data for Material | VKORG |
| MSTA | VTWEG | MSTA | VTWEG | MVKE | Sales Data for Material | VTWEG |
| MSTA | VTWEG | MSTA | MANDT | MVKE | Sales Data for Material | MANDT |
| MSTA | VTWEG | MSTA | MATNR | MVKE | Sales Data for Material | MATNR |
| MSTA | WERKS | MSTA | MANDT | MARC | Plant Data for Material | MANDT |
| MSTA | WERKS | MSTA | MATNR | MARC | Plant Data for Material | MATNR |
| MSTA | WERKS | MSTA | WERKS | MARC | Plant Data for Material | WERKS |
