C_SlsDocItemCustomerMaterialVH

Customer Material | view: CSLSITMCUSTMATVH | Extraction: Not supported | Component: Basic Functions
Tables used: MARAKNMTMARAMVKE
Column Name Description
MaterialByCustomer Material Number Used by Customer
Customer FK Customer number
Material FK Product 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
MaterialDescriptionByCustomer Customer Description of Material
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == T006.MANDT
  • C_SLSDOCITEMCUSTOMERMATERIALVH.BASEUNIT == T006.MSEHI
Customer number
  • Customer number
  • Client
  • C_SLSDOCITEMCUSTOMERMATERIALVH.CUSTOMER == KNA1.KUNNR
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == TVTW.MANDT
  • C_SLSDOCITEMCUSTOMERMATERIALVH.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Product Number
  • Client
  • Product Number
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == MARA.MANDT
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MATERIAL == MARA.MATNR
Unit of measure
  • Client
  • Sales unit
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == T006.MANDT
  • C_SLSDOCITEMCUSTOMERMATERIALVH.SALESMEASUREUNIT == T006.MSEHI
Sales Organization
  • Sales Organization
  • Client
  • C_SLSDOCITEMCUSTOMERMATERIALVH.SALESORGANIZATION == TVKO.VKORG
  • C_SLSDOCITEMCUSTOMERMATERIALVH.MANDT == TVKO.MANDT