IT CanvassTalk to an advisor
SAP tables · LessonReviewed by Arjun, SAP Solution Architect · Updated · Published · 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

MAKT holds material descriptions by language: MATNR plus SPRAS is the key, MAKTX is the short text and MAKTG its uppercase form for searching. When a report shows a material name it usually joined MARA to MAKT on MATNR and filtered SPRAS to the logon language. SE11 shows its structure and SE16N its data.

Key takeaways
  • 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.
Already working on SAP and stuck on a live ticket?Get an expert SAP developer on screen-share to finish your daily tasks with you. Deliver on time, protect your reputation and your job. Monthly support only, no task-wise plans.Task assigned · no idea where to startStill stuck · your job on the lineExpert joins your screenDelivered on timeExplore On Job Support