E_CustomerMaterial

Extension View for KNMT | view: ESDCUSTMATLINFO | Extraction: Not supported | Component: Material Maintenance
Tables used: KNMT
Column Name Description
Material FK Material Number
Customer FK Customer number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Customer number
  • Customer number
  • Client
  • E_CUSTOMERMATERIAL.CUSTOMER == KNA1.KUNNR
  • E_CUSTOMERMATERIAL.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • E_CUSTOMERMATERIAL.MANDT == TVTW.MANDT
  • E_CUSTOMERMATERIAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Material Number
  • Material Number
  • Client
  • E_CUSTOMERMATERIAL.MATERIAL == MARA.MATNR
  • E_CUSTOMERMATERIAL.MANDT == MARA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • E_CUSTOMERMATERIAL.MANDT == TVKO.MANDT
  • E_CUSTOMERMATERIAL.SALESORGANIZATION == TVKO.VKORG