SAP tables · LessonBy Arjun, SAP Solution Architect · Published · Updated · SAP S/4HANA 2023 · all levels
SAP MAKT
MAKT is a key SAP table in MM (Materials). It stores material descriptions (short texts) by language, so a material has a readable name in each maintained language.
Quick answer
When a report shows material descriptions, they usually come from MAKT for the logon language.
Key takeaways
- The key is MATNR + SPRAS, one description per material per language.
- SPRAS, language key (key).
- MARA, general material data.
- Watch out: one row per language, so a missing language makes a material look as though it has no name.
What it stores
It stores material descriptions (short texts) by language, so a material has a readable name in each maintained language.
Key fields
- MATNR, material (key).
- SPRAS, language key (key).
- MAKTX, material description (short text).
- MAKTG, description in uppercase (search).
Keys and relationships
The key is MATNR + SPRAS, one description per material per language. It is the go-to table to get a material’s readable name for reports.
Working with it
When a report shows material descriptions, they usually come from MAKT for the logon language. Join MARA-MAKT on MATNR (and filter SPRAS) for numbers with names. View its structure in SE11 and its data (with authorization) in SE16N.
Common pitfalls
- Reading tables directly instead of using CDS/reports where appropriate.
- Ignoring header/item relationships.
- Performance: querying large tables without indexed selection.
Practice challenge
+0 XPStreak ×0
Question 1 of 3
Which statement is true of MAKT?