ESH_N_CUSTOMERMATERIAL

Anchor view -CUSTOMERMATERIAL | view: ESH_L_CUSTMAT | Extraction: Not supported | Component: Customer Material Information
Tables used: KNA1KNMTTPRIOTPRITTVTWTVTWTMARAMAKTT001WTVKOTVKOTT006T006A
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
📏 Base Unit of Measure (BASEUNIT):
MINDELIVERYQTYINBASEUNIT Minimum Delivery Quantity in Delivery Note Processing
Column Name Description
Column Name Description
PARTIALDELIVERYISALLOWED Partial delivery at item level Show values
UNLIMITEDOVERDELIVERYISALLOWED Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
DELIVERYPRIORITYDESC Description TEXT20
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALDESCRIPTIONBYCUSTOMER Customer Description of Material TEXT40
MATERIALNAME Material Description TEXT40
MAXNMBROFPARTIALDELIVERY Maximum Number of Partial Deliveries Allowed Per Item ANTLF
ORGANIZATIONBPNAME1 Name 1 NAME
OVERDELIVTOLRTDLMTRATIOINPCT Overdelivery Tolerance PRZ21
PARTIALDELIVERYISALLOWEDTEXT Short Text for Fixed Values DDTEXT
PLANT Plant (Own or External) WERKS
PLANTNAME Plant Name TEXT30
SALESORGANIZATIONNAME Sales Organization Description TEXT20
UNDERDELIVTOLRTDLMTRATIOINPCT Underdelivery Tolerance PRZ21
UNITOFMEASURENAME Unit of Measurement Text (Maximum 10 Characters) TEXT10
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_N_CUSTOMERMATERIAL.MANDT == T006.MANDT
  • ESH_N_CUSTOMERMATERIAL.BASEUNIT == T006.MSEHI
Customer number
  • Client
  • Customer number
  • ESH_N_CUSTOMERMATERIAL.MANDT == KNA1.MANDT
  • ESH_N_CUSTOMERMATERIAL.CUSTOMER == KNA1.KUNNR
Item Usage
  • Client
  • Item Usage
  • ESH_N_CUSTOMERMATERIAL.MANDT == TVVW.MANDT
  • ESH_N_CUSTOMERMATERIAL.CUSTOMERMATERIALITEMUSAGE == TVVW.VWPOS
Delivery Priority
  • Client
  • Delivery Priority
  • ESH_N_CUSTOMERMATERIAL.MANDT == TPRIO.MANDT
  • ESH_N_CUSTOMERMATERIAL.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_CUSTOMERMATERIAL.MANDT == TVTW.MANDT
  • ESH_N_CUSTOMERMATERIAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Language Key ESH_N_CUSTOMERMATERIAL.LANGUAGE == T002.SPRAS
Material Number
  • Client
  • Material Number
  • Product Number
  • ESH_N_CUSTOMERMATERIAL.MANDT == MARA.MANDT
  • ESH_N_CUSTOMERMATERIAL.MATERIAL == MARA.MATNR
  • ESH_N_CUSTOMERMATERIAL.PRODUCT == MARA.MATNR
Product Number
  • Client
  • Material Number
  • Product Number
  • ESH_N_CUSTOMERMATERIAL.MANDT == MARA.MANDT
  • ESH_N_CUSTOMERMATERIAL.MATERIAL == MARA.MATNR
  • ESH_N_CUSTOMERMATERIAL.PRODUCT == MARA.MATNR
Sales Organization
  • Client
  • Sales Organization
  • ESH_N_CUSTOMERMATERIAL.MANDT == TVKO.MANDT
  • ESH_N_CUSTOMERMATERIAL.SALESORGANIZATION == TVKO.VKORG