P_SrvcProdComDistrChnl

Common distribution Channel for Product | view: PCOMDISTRCHNL | Extraction: Not supported | Component: S4CRM: Service Order Fiori-UI
Tables used: MARATVTWTVTWTTSPATTPTMTMARAMVKEMAKTTVTATVKOTVKOT
Column Name Description
Product 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
ProductName Product Description TEXT40
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
ItemCategoryGroupName Description TEXT20
Master Data Relations Join Conditions
Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SRVCPRODCOMDISTRCHNL.BASEUNIT == T006.MSEHI
  • P_SRVCPRODCOMDISTRCHNL.MANDT == T006.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SRVCPRODCOMDISTRCHNL.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SRVCPRODCOMDISTRCHNL.MANDT == TVKOV.MANDT
  • P_SRVCPRODCOMDISTRCHNL.SALESORGANIZATION == TVKOV.VKORG
Division
  • Division
  • Client
  • P_SRVCPRODCOMDISTRCHNL.DIVISION == TSPA.SPART
  • P_SRVCPRODCOMDISTRCHNL.MANDT == TSPA.MANDT
Item category group
  • Client
  • Item Category Group from Material Master
  • P_SRVCPRODCOMDISTRCHNL.MANDT == TPTM.MANDT
  • P_SRVCPRODCOMDISTRCHNL.ITEMCATEGORYGROUP == TPTM.MTPOS
Material No.
  • Client
  • Product Number
  • P_SRVCPRODCOMDISTRCHNL.MANDT == MARA.MANDT
  • P_SRVCPRODCOMDISTRCHNL.PRODUCT == MARA.MATNR
Unit of measure
  • Client
  • Sales unit
  • P_SRVCPRODCOMDISTRCHNL.MANDT == T006.MANDT
  • P_SRVCPRODCOMDISTRCHNL.SALESMEASUREUNIT == T006.MSEHI
Sales Organization
  • Client
  • Sales Organization
  • P_SRVCPRODCOMDISTRCHNL.MANDT == TVKO.MANDT
  • P_SRVCPRODCOMDISTRCHNL.SALESORGANIZATION == TVKO.VKORG