I_CustomerMaterialValueHelp

Customer Material Value Help | view: ICUSTMATVH | Extraction: Not supported | Component: Customer Material Information
Tables used: KNMT
Column Name Description
MaterialByCustomer Material Number Used by Customer
Customer FK Customer number
Material FK Material Number
Product FK Product Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
MaterialDescriptionByCustomer Customer Description of Material
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
  • I_CUSTOMERMATERIALVALUEHELP.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERMATERIALVALUEHELP.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_CUSTOMERMATERIALVALUEHELP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CUSTOMERMATERIALVALUEHELP.MANDT == TVTW.MANDT
Material Number
  • Product Number
  • Material Number
  • Client
  • I_CUSTOMERMATERIALVALUEHELP.PRODUCT == MARA.MATNR
  • I_CUSTOMERMATERIALVALUEHELP.MATERIAL == MARA.MATNR
  • I_CUSTOMERMATERIALVALUEHELP.MANDT == MARA.MANDT
Product Number
  • Product Number
  • Material Number
  • Client
  • I_CUSTOMERMATERIALVALUEHELP.PRODUCT == MARA.MATNR
  • I_CUSTOMERMATERIALVALUEHELP.MATERIAL == MARA.MATNR
  • I_CUSTOMERMATERIALVALUEHELP.MANDT == MARA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTOMERMATERIALVALUEHELP.MANDT == TVKO.MANDT
  • I_CUSTOMERMATERIALVALUEHELP.SALESORGANIZATION == TVKO.VKORG