SAP table MAKT (Material Descriptions)
The SAP table MAKT is a critical component in the SAP database, primarily used for storing the short texts and descriptions of materials in various languages. Each entry in the MAKT table includes key fields such as the Material Number (MATNR), Language Key (SPRAS), and the corresponding Material Description (MAKTX). This table enables the management of material descriptions across different languages, facilitating multilingual support for material master data. It plays a vital role in ensuring that accurate and localized material descriptions are available for various business processes like procurement, sales, and inventory management, thus enhancing the global operability and user experience of the SAP system.
SAP table MAKT has 3 primary key fields being MANDT,MATNR,SPRAS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
---|---|---|---|---|---|---|---|
MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
MAKTX | Material Description | CHAR | 40 | 0 | MAKTX | ||
MAKTG | Material Description in Uppercase for Matchcodes | CHAR | 40 | 0 | MAKTG |
MAKT foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 MAKT | MANDT | T000 | Clients | MANDT |
1 MAKT | MATNR | MARA | General Material Data | MANDT |
1 MAKT | MATNR | MARA | General Material Data | MATNR |