I_CustomerMaterial

Customer Material Information | view: ISDCUSTMATLINFO | ATTR | Extraction: Full only | Component: Material Maintenance
Tables used: KNMT
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Customer FK Customer number
Material FK Material Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
Column Name Description
Column Name Description
PartialDeliveryIsAllowed Partial delivery at item level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
SortField ETag CHAR10
ETag ETag CHAR10
MaterialByCustomer Material Number Used by Customer IDNEX
MaterialDescriptionByCustomer Customer Description of Material TEXT40
Plant Plant (Own or External) WERKS
MaxNmbrOfPartialDelivery Maximum Number of Partial Deliveries Allowed Per Item ANTLF
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
SalesQtyToBaseQtyDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
SalesQtyToBaseQtyNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_CUSTOMERMATERIAL.MANDT == T006.MANDT
  • I_CUSTOMERMATERIAL.BASEUNIT == T006.MSEHI
Customer number
  • Customer number
  • Client
  • I_CUSTOMERMATERIAL.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERMATERIAL.MANDT == KNA1.MANDT
Item Usage
  • Client
  • Item Usage
  • I_CUSTOMERMATERIAL.MANDT == TVVW.MANDT
  • I_CUSTOMERMATERIAL.CUSTOMERMATERIALITEMUSAGE == TVVW.VWPOS
Delivery Priority
  • Client
  • Delivery Priority
  • I_CUSTOMERMATERIAL.MANDT == TPRIO.MANDT
  • I_CUSTOMERMATERIAL.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution Channel
  • Client
  • Distribution Channel
  • I_CUSTOMERMATERIAL.MANDT == TVTW.MANDT
  • I_CUSTOMERMATERIAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Material Number
  • Material Number
  • Product Number
  • Client
  • I_CUSTOMERMATERIAL.MATERIAL == MARA.MATNR
  • I_CUSTOMERMATERIAL.PRODUCT == MARA.MATNR
  • I_CUSTOMERMATERIAL.MANDT == MARA.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • I_CUSTOMERMATERIAL.MATERIAL == MARA.MATNR
  • I_CUSTOMERMATERIAL.PRODUCT == MARA.MATNR
  • I_CUSTOMERMATERIAL.MANDT == MARA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTOMERMATERIAL.MANDT == TVKO.MANDT
  • I_CUSTOMERMATERIAL.SALESORGANIZATION == TVKO.VKORG