ESH_S_SITE

Search view -SITE | view: ESH_U_SITE | Extraction: Not supported | Component: Sites
Tables used: ADCPADRCT005T005TTVTWTVTWTT001WT024ET005STVKOTVKOTWRF1LFA1
Column Name Description
SITE Plant
Column Name Description
Column Name Description
Column Name Description
SITEBLOCKINGFROMDATE Block from
SITEBLOCKINGTODATE Block to
Column Name Description
SITECATEGORY Site Category Show values
Column Name Description Domain name
CITYNAME City TEXT40
COUNTRY Country/Region Key
COUNTRYNAME Country/Region Name TEXT50
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
POSTALCODE City postal code
PURCHASING_ORGANIZATION Purchasing Organization EKORG
PURCHASING_ORGANIZATION_NAME Purchasing Organization Name TEXT20
REGION Region (State, Province, County) REGIO
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SITECATEGORYNAME Short Text for Fixed Values DDTEXT
SITENAME Site Name TEXT30
SUPPLIER Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_S_SITE.MANDT == TVTW.MANDT
  • ESH_S_SITE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Sales Organization
  • Client
  • Sales Organization
  • ESH_S_SITE.MANDT == TVKO.MANDT
  • ESH_S_SITE.SALESORGANIZATION == TVKO.VKORG
Blocking Reason
  • Blocking Reason
  • Client
  • ESH_S_SITE.SITEBLOCKINGREASON == TWRF11.SPGR1
  • ESH_S_SITE.MANDT == TWRF11.MANDT
Customer Number of Plant
  • Customer Number of Plant
  • Client
  • ESH_S_SITE.SITECUSTOMER == KNA1.KUNNR
  • ESH_S_SITE.MANDT == KNA1.MANDT