C_MaterialBySlsOrgDistrChnl

Materials By Sales Org and Distr Channel | view: CMATBYSLSORGDNCL | Extraction: Not supported | Component: Basic Functions
Tables used: MARAMARAMVKEMAKT
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Material Product Number
Column Name Description
Column Name Description
Column Name Description
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
Column Name Description
Column Name Description Domain name
MaterialName Product Description TEXT40
ProductOldID Old Product Number BISMT
Master Data Relations Join Conditions
Unit of Measure
  • Base Unit of Measure
  • Client
  • C_MATERIALBYSLSORGDISTRCHNL.BASEUNIT == T006.MSEHI
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == T006.MANDT
Distribution channel
  • Client
  • Distribution Channel
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == TVTW.MANDT
  • C_MATERIALBYSLSORGDISTRCHNL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Item category group
  • Client
  • Item Category Group from Material Master
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == TPTM.MANDT
  • C_MATERIALBYSLSORGDISTRCHNL.ITEMCATEGORYGROUP == TPTM.MTPOS
Material status for sales
  • Client
  • Distribution-chain-specific material status
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == TVMS.MANDT
  • C_MATERIALBYSLSORGDISTRCHNL.PRODUCTSALESSTATUS == TVMS.VMSTA
Unit of measure
  • Client
  • Sales unit
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == T006.MANDT
  • C_MATERIALBYSLSORGDISTRCHNL.SALESMEASUREUNIT == T006.MSEHI
Sales organization
  • Client
  • Sales Organization
  • C_MATERIALBYSLSORGDISTRCHNL.MANDT == TVKO.MANDT
  • C_MATERIALBYSLSORGDISTRCHNL.SALESORGANIZATION == TVKO.VKORG