SAP table KNMT (Customer-Material Info Record Data Table)
SAP table KNMT has 5 primary key fields being MANDT,VKORG,VTWEG,KUNNR,MATNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |||||||||||
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |||||||||||
| KUNNR | Customer number | CHAR | 10 | 0 | KNA1 | KUNNR_V | |||||||||||
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |||||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||||||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||||||
| SORTL | ETag | CHAR | 10 | 0 | KNMT_ETAG | ||||||||||||
| KDMAT | Material Number Used by Customer | CHAR | 35 | 0 | MATNR_KU | ||||||||||||
| POSTX | Customer Description of Material | CHAR | 40 | 0 | KDPTX | ||||||||||||
| LPRIO | Delivery Priority | NUMC | 2 | 0 | TPRIO | LPRIO | |||||||||||
| MINLF | Minimum Delivery Quantity in Delivery Note Processing | QUAN | 13 | 3 | MINLF | ||||||||||||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |||||||||||
| CHSPL | Batch split allowed | CHAR | 1 | 0 | CHSPL | ||||||||||||
| KZTLF | Partial delivery at item level | CHAR | 1 | 0 | KZTLF |
|
|||||||||||
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | DEC | 1 | 0 | ANTLF | ||||||||||||
| UNTTO | Underdelivery Tolerance | DEC | 3 | 1 | UNTTO | ||||||||||||
| UEBTO | Overdelivery Tolerance | DEC | 3 | 1 | UEBTO | ||||||||||||
| UEBTK | Unlimited Overdelivery Allowed | CHAR | 1 | 0 | UEBTK_V | ||||||||||||
| WERKS | Plant (Own or External) | CHAR | 4 | 0 | WERKS_EXT | ||||||||||||
| RDPRF | Rounding Profile | CHAR | 4 | 0 | RDPR | RDPRF | |||||||||||
| MEGRU | Unit of Measure Group | CHAR | 4 | 0 | MEGRU | ||||||||||||
| J_1BTXSDC | SD tax code | CHAR | 2 | 0 | J_1BTXSDC | J_1BTXSDC_ | |||||||||||
| VWPOS | Item Usage | CHAR | 4 | 0 | TVVW | VWPOS | |||||||||||
| VRKME_T | Sales unit | UNIT | 3 | 0 | VRKME | ||||||||||||
| UMVKN_T | Denominator (divisor) for conversion of sales Qty into SKU | DEC | 5 | 0 | UMVKN | ||||||||||||
| UMVKZ_T | Numerator (factor) for conversion of sales quantity into SKU | DEC | 5 | 0 | UMVKZ | ||||||||||||
| GUID | 16 Byte UUID in 16 Bytes (Raw Format) | RAW | 16 | 0 | SYSUUID_X16 | ||||||||||||
| DUMMY_SLSCUSMAT_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
KNMT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KNMT | J_1BTXSDC | J_1BTXSDC | SD tax codes | MANDT |
| 1 KNMT | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 KNMT | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 KNMT | LPRIO | TPRIO | Customers: Delivery Priorities | LPRIO |
| 1 KNMT | MANDT | T000 | Clients | MANDT |
| 0 KNMT | MATNR | MARA | General Material Data | MANDT |
| 0 KNMT | MATNR | MARA | General Material Data | MATNR |
| 1 KNMT | MEINS | T006 | Units of Measurement | MANDT |
| 1 KNMT | MEINS | T006 | Units of Measurement | MSEHI |
| 0 KNMT | RDPRF | RDPR | Rounding profile | MANDT |
| 0 KNMT | RDPRF | RDPR | Rounding profile | WERKS |
| 0 KNMT | RDPRF | RDPR | Rounding profile | RDPRF |
| 0 KNMT | RDPRF | RDPR | Rounding profile | RDZAE |
| 1 KNMT | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| 1 KNMT | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| 0 KNMT | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| 0 KNMT | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| 1 KNMT | VWPOS | TVVW | Item Usage | MANDT |