ESH_S_SUPPLIERS_M

Search view -SUPPLIERS_M | view: ESH_U_SUPPLIERSM | Extraction: Not supported | Component: Business Partners
Tables used: ADCPADRCADR6ADR2BUT000T005T005TT005ST005ULFA1T077KT077YCVI_VEND_LINK
Column Name Description
SUPPLIER Account Number of Supplier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POSTINGISBLOCKED Central posting block Show values
PURCHASINGISBLOCKED Centrally imposed purchasing block Show values
Column Name Description Domain name
ACCOUNTGROUPNAME Account Group Name
ADDITIONALLASTNAME Other Last Name of a Person BU_NAME
ADDRESSID Address ADRNR
AUTHORIZATIONGROUP Authorization Group BRGRU
BUSINESSPARTNER Business Partner Number BU_PARTNER
CITYNAME City TEXT35
COUNTRYNAME Country/Region Name
EMAILADDRESS E-Mail Address
FAXNUMBER Fax Number
INTERNATIONALLOCATIONNUMBER1 International location number (part 1) NUM07
INTERNATIONALLOCATIONNUMBER2 International location number (Part 2) NUM05
ORGANIZATIONBPNAME1 Name 1 NAME
ORGANIZATIONBPNAME2 Name 2
MOBILE Telephone no.: dialling code+number CHAR30
PHONE Telephone no.: dialling code+number CHAR30
PHONENUMBER2 Second telephone number TEXT16
POSTALCODE Postal Code PSTLZ
REGIONNAME Description
STREETNAME Street and House Number TEXT35
TAXNUMBER1 Tax Number 1
VATREGISTRATION VAT Registration Number
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • ESH_S_SUPPLIERS_M.MANDT == T005.MANDT
  • ESH_S_SUPPLIERS_M.COUNTRY == T005.LAND1
Industry key
  • Industry key
  • Client
  • ESH_S_SUPPLIERS_M.INDUSTRY == T016.BRSCH
  • ESH_S_SUPPLIERS_M.MANDT == T016.MANDT
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • ESH_S_SUPPLIERS_M.MANDT == T005S.MANDT
  • ESH_S_SUPPLIERS_M.COUNTRY == T005S.LAND1
  • ESH_S_SUPPLIERS_M.REGION == T005S.BLAND
Vendor account group
  • Client
  • Vendor account group
  • ESH_S_SUPPLIERS_M.MANDT == T077K.MANDT
  • ESH_S_SUPPLIERS_M.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Language Key ESH_S_SUPPLIERS_M.SUPPLIERLANGUAGE == T002.SPRAS
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • ESH_S_SUPPLIERS_M.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • ESH_S_SUPPLIERS_M.MANDT == TTXJ.MANDT
  • ESH_S_SUPPLIERS_M.TAXJURISDICTION == TTXJ.TXJCD