ESH_N_SUPPLIERS_M

Anchor view -SUPPLIERS_M | view: ESH_L_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 TEXT30
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 TEXT50
EMAILADDRESS E-Mail Address AD_SMTPADR
FAXNUMBER Fax Number TEXT31
INTERNATIONALLOCATIONNUMBER1 International location number (part 1) NUM07
INTERNATIONALLOCATIONNUMBER2 International location number (Part 2) NUM05
ORGANIZATIONBPNAME1 Name 1 NAME
ORGANIZATIONBPNAME2 Name 2 NAME
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 TEXT20
STREETNAME Street and House Number TEXT35
TAXNUMBER1 Tax Number 1 STCD1
VATREGISTRATION VAT Registration Number STCEG
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • ESH_N_SUPPLIERS_M.COUNTRY == T005.LAND1
  • ESH_N_SUPPLIERS_M.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • ESH_N_SUPPLIERS_M.INDUSTRY == T016.BRSCH
  • ESH_N_SUPPLIERS_M.MANDT == T016.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • ESH_N_SUPPLIERS_M.COUNTRY == T005S.LAND1
  • ESH_N_SUPPLIERS_M.MANDT == T005S.MANDT
  • ESH_N_SUPPLIERS_M.REGION == T005S.BLAND
Vendor account group
  • Vendor account group
  • Client
  • ESH_N_SUPPLIERS_M.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • ESH_N_SUPPLIERS_M.MANDT == T077K.MANDT
Language Key ESH_N_SUPPLIERS_M.SUPPLIERLANGUAGE == T002.SPRAS
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • ESH_N_SUPPLIERS_M.TAXJURISDICTION == TTXJ.TXJCD
  • ESH_N_SUPPLIERS_M.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • ESH_N_SUPPLIERS_M.MANDT == TTXJ.MANDT