KNMT table — Customer Material Info Record Table
KNMT stores the customer-material info record: the link between a customer's own material number and the SAP material number for a given sales area, plus delivery tolerances and partial delivery rules that apply only to that customer-material combination. One row is one customer-material-sales area override of standard defaults.
KNMT holds customer-specific overrides of material data used during sales order processing, mainly the customer's own material number and shipping tolerances. This page covers the fields consultants actually query, how the table joins into order and customer master data, and the recurring mistakes people make when they assume KNMT is authoritative for pricing or availability.
Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 915 words
What it stores
Each row in KNMT represents an agreement between one customer and one material, scoped to a specific sales organization and distribution channel, that overrides certain defaults from the material master or customer master when that customer orders that material. The most commonly used piece of data is the customer's own material number (their part number, not SAP's), which prints on order confirmations and delivery documents so the customer recognizes what they ordered. The table also carries delivery tolerance percentages and partial delivery limits specific to that customer-material pair. It does not drive pricing, does not drive availability, and does not exist for every material a customer buys — absence of a row is normal and simply means standard defaults apply.
Key fields
- MANDT - client
- KUNNR - customer number, part of the key
- MATNR - SAP material number, part of the key
- VKORG - sales organization, part of the key
- VTWEG - distribution channel, part of the key
- KDMAT - customer's own material number, free text as defined by the customer
- UEBTO - overdelivery tolerance percentage for this customer-material combination
- UNTTO - underdelivery tolerance percentage for this customer-material combination
- UEBTK - unlimited overdelivery allowed indicator
- ANTLF - maximum number of partial deliveries allowed
How it joins the data model
- KNMT-KUNNR = KNA1-KUNNR
- KNMT-KUNNR/VKORG/VTWEG = KNVV-KUNNR/VKORG/VTWEG
- KNMT-MATNR/KDMAT feeds VBAP-MATNR/KDMAT when a sales order line is created for that customer and material
- KNMT-KUNNR relates to VBAK-KUNNR via the sold-to on the order header
How to read it safely
KNMT is client-dependent; always restrict on MANDT implicitly through the standard client context. The full key is KUNNR, MATNR, VKORG, VTWEG, so a lookup with only KUNNR or only MATNR returns every sales area combination for that customer or material, which is rarely what is needed. For a single-order investigation, select on KUNNR and MATNR together first, then narrow to VKORG and VTWEG if multiple rows come back. The table is small relative to transactional tables like VBAP, so a scan by KUNNR alone is usually fine, but a scan by MATNR alone across all customers can return an unhelpfully long list on a widely-sold material.
How to prove it in the data
Symptom: the delivery note or order confirmation shows the wrong customer part number, or the customer complains their part number is missing entirely. Select KNMT with KUNNR equal to the sold-to, MATNR equal to the material in question, and VKORG/VTWEG matching the sales area of the order. Compare KDMAT against what the customer actually expects. If no row exists, the order used the SAP material number by default, which is expected behavior, not a data error.
ECC vs S/4HANA
KNMT continues to exist as a transparent table in S/4HANA and its structure has not been restructured the way partner or condition tables were. The maintenance transactions used in ECC for customer-material info records remain available, and a Fiori app for managing these records exists on newer S/4HANA releases, though the exact app identifier should be confirmed against the specific release rather than assumed. There is no known compatibility view that fully replaces direct table access for reporting purposes.
Common pitfalls
- Assuming a missing KNMT row is an error. It is the normal state for the majority of customer-material combinations; the order simply falls back to the SAP material number and standard tolerances.
- Treating KDMAT as validated data. It is free text maintained by whoever set up the record, not checked against any external catalog, so typos or stale customer part numbers persist silently.
- Querying without restricting VKORG and VTWEG. The same customer can have different KDMAT values or tolerances per sales area, and a query that ignores that returns multiple rows that look like a data inconsistency but are actually correct, separate agreements.
- Blaming order type or copy control configuration for tolerance violations that are actually driven by UEBTO and UNTTO on this table overriding the customer master or document type defaults for that one material.
- Confusing KNMT with KNVP (customer partner functions) or KNVI (customer tax classification). None of these tables share purpose; KNMT is specifically material-level overrides, the others are partner and tax data respectively.
- Expecting KNMT to influence pricing. It does not carry condition data; pricing differences for a customer-material combination live in the condition tables, not here.
Whose problem this is
Data quality on KNMT belongs to the SD master data or customer service team that maintains customer-facing agreements, since the customer's own part number and tolerance overrides are commercial terms, not system configuration. Order-to-cash functional consultants get pulled in only when the wrong value is flowing into an order or delivery document and the root cause needs tracing back to this table versus the material or customer master.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/knmtERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.