SAP Table KNMT
Customer-Material Info Record Data Table
KNMT (Customer-Material Info Record Data Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNMT to other SAP tables.
KNMT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVTW |
CHAR
|
2 | 0 | |||||||||||||
|
KUNNR
Customer number
|
KUNNR_V | KNA1 |
CHAR
|
10 | 0 | |||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||||
|
SORTL
Sort field
|
SORTL |
CHAR
|
10 | 0 | ||||||||||||||
|
KDMAT
Material Number Used by Customer
|
MATNR_KU |
CHAR
|
35 | 0 | ||||||||||||||
|
POSTX
Customer description of material
|
KDPTX |
CHAR
|
40 | 0 | ||||||||||||||
|
LPRIO
Delivery Priority
|
LPRIO | TPRIO |
NUMC
|
2 | 0 | |||||||||||||
|
MINLF
Minimum delivery quantity in delivery note processing
|
MINLF |
QUAN
|
13 | 3 | ||||||||||||||
|
MEINS
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
CHSPL
Batch split allowed
|
CHSPL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KZTLF
Partial delivery at item level
|
KZTLF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANTLF
Maximum Number of Partial Deliveries Allowed Per Item
|
ANTLF |
DEC
|
1 | 0 | ||||||||||||||
|
UNTTO
Underdelivery Tolerance Limit
|
UNTTO |
DEC
|
3 | 1 | ||||||||||||||
|
UEBTO
Overdelivery Tolerance Limit
|
UEBTO |
DEC
|
3 | 1 | ||||||||||||||
|
UEBTK
Unlimited overdelivery allowed
|
UEBTK_V |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
WERKS
Plant (Own or External)
|
WERKS_EXT |
CHAR
|
4 | 0 | ||||||||||||||
|
RDPRF
Rounding Profile
|
RDPRF | RDPR |
CHAR
|
4 | 0 | |||||||||||||
|
MEGRU
Unit of Measure Group
|
MEGRU |
CHAR
|
4 | 0 | ||||||||||||||
|
J_1BTXSDC
SD tax code
|
J_1BTXSDC_ | J_1BTXSDC |
CHAR
|
2 | 0 | |||||||||||||
|
VWPOS
Item usage
|
VWPOS | TVVW |
CHAR
|
4 | 0 | |||||||||||||
|
OIPTRM1
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM2
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM3
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM4
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM5
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM6
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM7
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM8
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIPTRM9
Payment terms for invoice cycle X
|
OIA_PTRM |
CHAR
|
4 | 0 | ||||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP | OIH5 |
CHAR
|
2 | 0 | |||||||||||||
|
OIINEX
Code for internal or external excise duty rate determination
|
OIH_INEX | OIH16 |
CHAR
|
2 | 0 | |||||||||||||
KNMT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNMT | J_1BTXSDC | KNMT | MANDT |
J_1BTXSDC
SD tax codes
|
MANDT |
| KNMT | J_1BTXSDC | KNMT | J_1BTXSDC |
J_1BTXSDC
SD tax codes
|
TAXCODE |
| KNMT | KUNNR | KNMT | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNMT | KUNNR | KNMT | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNMT | LPRIO | KNMT | MANDT |
TPRIO
Customers: Delivery Priorities
|
MANDT |
| KNMT | LPRIO | KNMT | LPRIO |
TPRIO
Customers: Delivery Priorities
|
LPRIO |
| KNMT | MANDT | KNMT | MANDT |
T000
Clients
|
MANDT |
| KNMT | MATNR | KNMT | MANDT |
MARA
General Material Data
|
MANDT |
| KNMT | MATNR | KNMT | MATNR |
MARA
General Material Data
|
MATNR |
| KNMT | MEINS | KNMT | MEINS |
T006
Units of Measurement
|
MSEHI |
| KNMT | MEINS | KNMT | MANDT |
T006
Units of Measurement
|
MANDT |
| KNMT | OIHANTYP | KNMT | MANDT |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
MANDT |
| KNMT | OIHANTYP | KNMT | OIHANTYP |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
HANTYP |
| KNMT | OIINEX | T000 | MANDT |
OIH16
Internal/external price conditions
|
MANDT |
| KNMT | OIINEX | KNMT | OIINEX |
OIH16
Internal/external price conditions
|
INEX |
| KNMT | RDPRF | KNMT | WERKS |
RDPR
Rounding profile
|
WERKS |
| KNMT | RDPRF | KNMT | RDPRF |
RDPR
Rounding profile
|
RDPRF |
| KNMT | RDPRF | * |
RDPR
Rounding profile
|
RDZAE | |
| KNMT | RDPRF | KNMT | MANDT |
RDPR
Rounding profile
|
MANDT |
| KNMT | VKORG | KNMT | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| KNMT | VKORG | KNMT | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| KNMT | VTWEG | KNMT | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| KNMT | VTWEG | KNMT | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| KNMT | VWPOS | KNMT | MANDT |
TVVW
Item Usage
|
MANDT |
| KNMT | VWPOS | KNMT | VWPOS |
TVVW
Item Usage
|
VWPOS |