SAP Reference

MAKT

text S/4HANA status: Active

Material Descriptions

Identity
Module: MM · Materials ManagementType: transparent
Language note

One row per language: MAKT adds the SPRAS language key to MARA’s business key — filter to one language or joins multiply. See text tables in the quirks guide.

What the badges mean
S/4HANA status: Active
Active and unchanged in S/4HANA.
S/4HANA status: Deprecated
Still readable today, but no longer SAP's strategic path — plan around it.
S/4HANA status: Replaced
Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
S/4HANA status: Migrating to IBP
Planning scope is moving from APO toward IBP.
S/4HANA status: Active (StRM) · Replaced (EWM)
Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
S/4HANA status: Replaced · Compat View
Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
S/4HANA status: Active · Proxy View
Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
master
Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
Linked type codes

CLNT — the client key; filter it explicitly and carry it through every join.

NUMC — fixed-width numeric text; keep it a string and keep the leading zeros.

DATS, TIMS — character date (YYYYMMDD) and time (HHMMSS), zero-filled when initial.

CURR, CUKY, QUAN, UNIT — amounts and quantities, meaningful only beside the currency key or unit that qualifies them.

LANG — a language key in a text table — one row per language.

In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.

Fields

5 fields · 3 key

5 fields.

Table fields: key flag, field name, description, data type (linked to the data quirks guide where the type carries a known trap), length, and check-table references. 5 fields.
KeyFieldDescriptionTypeLengthReferences
Primary keyMANDTClientCLNT3T000
Primary keyMATNRMaterial NumberCHAR18 / 40MARA
Primary keySPRASLanguage KeyLANG1T002
MAKTXMaterial Description (Short Text)CHAR40
MAKTGMaterial Description in Upper CaseCHAR40

Lengths shown as ECC / S/4HANA where the extended material number applies.

Linked type codes in the Type column jump to the matching section of the SAP data quirks guide.

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MAKT on Databricks. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

4 parameters not filled: <catalog>, <schema>, <MANDT>, <MATNR>

-- ============================================================
-- Table  : MAKT Material Descriptions
-- Purpose: Column-selected read of MAKT — auto-generated from field metadata
-- Grain  : One row per MATNR + SPRAS
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  mt.MANDT AS "Client",
  mt.MATNR AS "Material Number",
  mt.SPRAS AS "Language Key",
  mt.MAKTX AS "Material Description (Short Text)",
  mt.MAKTG AS "Material Description in Upper Case"
FROM <catalog>.<schema>.makt mt
WHERE
  mt.MANDT = '<MANDT>'
  -- AND mt.MATNR = '<MATNR>'
ORDER BY mt.MATNR;

Verified August 2026

More query patterns: MM01 MM02 MM03

Relationships

Diagram of 1-hop neighbors — join details below.

Join details

  • MARAMAKTtext table · 1:N
    ON mara.MATNR = makt.MATNR

Transaction Codes That Use This Table

R read · W write · R/W read + write

Secondary t-codes

More Materials Management tables