ESH_S_SOR_CUSTMAT

Search view -SOR_CUSTMAT | view: ESH_U_SORCUSTMAT | Extraction: Not supported | Component: Sales Document Creation Based on Unstructured Data
Tables used: KNMTKNMTAKNA1KNMT
Column Name Description
CUSTOMER FK Customer number
DISTRIBUTIONCHANNEL FK Distribution Channel
MATERIAL FK Material Number
SALESORGANIZATION FK Sales Organization
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AUTHORIZATIONGROUP Authorization Group BRGRU
ADDIMATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
ADDIMATERIALDEBYCUSTOMER Alternative Customer Description of Material TEXT40
MATERIALDESCRIPTIONBYCUSTOMER Customer Description of Material TEXT40
Master Data Relations Join Conditions
Customer number
  • Customer number
  • Client
  • ESH_S_SOR_CUSTMAT.CUSTOMER == KNA1.KUNNR
  • ESH_S_SOR_CUSTMAT.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_S_SOR_CUSTMAT.MANDT == TVTW.MANDT
  • ESH_S_SOR_CUSTMAT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Material Number
  • Client
  • Material Number
  • ESH_S_SOR_CUSTMAT.MANDT == MARA.MANDT
  • ESH_S_SOR_CUSTMAT.MATERIAL == MARA.MATNR
Sales Organization
  • Client
  • Sales Organization
  • ESH_S_SOR_CUSTMAT.MANDT == TVKO.MANDT
  • ESH_S_SOR_CUSTMAT.SALESORGANIZATION == TVKO.VKORG