KNMT

Customer-Material Info Record Data Table | #masterdata | Component: Basic Functions
Column Name Description
MANDT FK Client
VKORG FK Sales Organization
VTWEG FK Distribution Channel
KUNNR FK Customer number
MATNR FK Material Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MINLF Minimum Delivery Quantity in Delivery Note Processing
Column Name Description
ERDAT Date on which the record was created
Column Name Description
CHSPL Batch split allowed Show values
KZTLF Partial delivery at item level Show values
UEBTK Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
SORTL ETag CHAR10
KDMAT Material Number Used by Customer IDNEX
POSTX Customer Description of Material TEXT40
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF
UNTTO Underdelivery Tolerance PRZ21
UEBTO Overdelivery Tolerance PRZ21
WERKS Plant (Own or External) WERKS
MEGRU Unit of Measure Group MEGRU
UMVKN_T Denominator (divisor) for conversion of sales Qty into SKU UMBSN
UMVKZ_T Numerator (factor) for conversion of sales quantity into SKU UMBSZ
GUID 16 Byte UUID in 16 Bytes (Raw Format) SYSUUID_X16
DUMMY_SLSCUSMAT_INCL_EEW_PS Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Foreign key for SD tax code
Customer number
  • KNMT.MANDT == KNA1.MANDT
  • KNMT.KUNNR == KNA1.KUNNR
Delivery Priority
  • KNMT.MANDT == TPRIO.MANDT
  • KNMT.LPRIO == TPRIO.LPRIO
Client KNMT.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • KNMT.MATNR == MARA.MATNR
  • KNMT.MANDT == MARA.MANDT
Base Unit of Measure
  • KNMT.MANDT == T006.MANDT
  • KNMT.MEINS == T006.MSEHI
Rounding profile
  • Plant (Own or External)
  • Rounding Profile
  • ?
  • KNMT.MANDT == RDPR.MANDT
  • KNMT.WERKS == RDPR.WERKS
  • KNMT.RDPRF == RDPR.RDPRF
  • KNMT.[column in domain "RDZAE"] == RDPR.RDZAE
Sales Organization
  • KNMT.MANDT == TVKO.MANDT
  • KNMT.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KNMT.VTWEG == TVTW.VTWEG
  • KNMT.MANDT == TVTW.MANDT
Item Usage
  • KNMT.MANDT == TVVW.MANDT
  • KNMT.VWPOS == TVVW.VWPOS