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