SAP KNMT Customer-Material Info Record Data Table Table data and field list

KNMT is a standard SAP Table which is used to store Customer-Material Info Record Data Table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The KNMT table consists of various fields, each holding specific information or linking keys about Customer-Material Info Record Data Table data available in SAP. These include VKORG (Sales Organization), VTWEG (Distribution Channel), KUNNR (Customer number), MATNR (Material Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

KNMT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP KNMT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the KNMT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
KUNNR	Customer number	KUNNR_V	CHAR	10	KNA1	ALPHA	KUNNR	KUN
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
SORTL	Sort field	SORTL	CHAR	10			CHAR10
KDMAT	Material Number Used by Customer	MATNR_KU	CHAR	35			IDNEX
POSTX	Customer description of material	KDPTX	CHAR	40			TEXT40
LPRIO	Delivery Priority	LPRIO	NUMC	2	TPRIO		LPRIO
MINLF	Minimum delivery quantity in delivery note processing	MINLF	QUAN	13(3)			MENG13
MEINS	Base Unit of Measure	MEINS	UNIT	3	T006	CUNIT	MEINS
CHSPL	Batch split allowed	CHSPL	CHAR	1			XFELD
KZTLF	Partial delivery at item level	KZTLF	CHAR	1			KZTLF
ANTLF	Maximum Number of Partial Deliveries Allowed Per Item	ANTLF	DEC	1			ANTLF
UNTTO	Underdelivery Tolerance Limit	UNTTO	DEC	3(1)			PRZ21
UEBTO	Overdelivery Tolerance Limit	UEBTO	DEC	3(1)			PRZ21
UEBTK	Unlimited overdelivery allowed	UEBTK_V	CHAR	1			XFELD
WERKS	Plant (Own or External)	WERKS_EXT	CHAR	4	Assigned to domain		WERKS	WRK	SH_T001W_EXTS
RDPRF	Rounding Profile	RDPRF	CHAR	4	RDPR		RDPRF
MEGRU	Unit of Measure Group	MEGRU	CHAR	4	Assigned to domain		MEGRU
J_1BTXSDC	SD tax code	J_1BTXSDC_	CHAR	2	J_1BTXSDC		J_1BTXSDC
VWPOS	Item usage	VWPOS	CHAR	4	TVVW		VWPOS

Key field

Non-key field

< KNKO_VB - KNKO extended by sales document for sales order archiving KNMTK - Customer-Material Info Record Header Table >

How do I retrieve data from SAP table KNMT using ABAP code

The following ABAP code Example will allow you to do a basic selection on KNMT to SELECT all data from the table
DATA: WA_KNMT TYPE KNMT.

SELECT SINGLE *
FROM KNMT
INTO CORRESPONDING FIELDS OF WA_KNMT
WHERE...

How to access SAP table KNMT

Within an ECC or HANA version of SAP you can also view further information about KNMT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to KNMT

KNMT - Customer-Material Info Record Data Table