ESH_N_CUSTOMERS_T

Anchor view -CUSTOMERS_T | view: ESH_L_CUSTOMERST | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, ADR6, BUT000, ADRP, KNVK, T005, T005T, KNA1, KNB1, KNB5, KNVV, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, T005S, T005U, TVKO, TVKOT
Column Name Description
CUSTOMER Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DELETIONINDICATOR Central Deletion Flag for Master Record Show values
POSTINGISBLOCKED Central posting block Show values
Column Name Description Domain name
ADDRESSID Address ADRNR
AUTHORIZATIONGROUP Authorization Group BRGRU
BUSINESSPARTNER Business Partner Number BU_PARTNER
CITYNAME City TEXT35
COUNTRYNAME Country/Region Name TEXT50
CREATEDBYUSER Name of Person who Created the Object USNAM
DISTRIBUTIONCHANNEL Distribution Channel VTWEG
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
DIVISION Division SPART
DIVISIONNAME Division Description TEXT20
EMAILADDRESS E-Mail Address AD_SMTPADR
FAXNUMBER Fax Number TEXT31
FIRSTNAME First name of business partner (person) BU_NAME
CONTACTPERSONFIRSTNAME First name TEXT40
HOUSENUMBER House Number TEXT10
INTERNATIONALLOCATIONNUMBER1 International location number (part 1) NUM07
LASTNAME Last name of business partner (person) BU_NAME
ORGANIZATIONBPNAME1 Name 1 NAME
ORGANIZATIONBPNAME2 Name 2 NAME
POSTALCODE Postal Code PSTLZ
REGIONNAME Description TEXT20
SALESORGANIZATION Sales Organization VKORG
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SEARCHTERM1 Search Term 1 for Business Partner BU_SORT1
STREETNAME Street and House Number TEXT35
TAXNUMBER1 Tax Number 1 STCD1
VATREGISTRATION VAT Registration Number STCEG
Master Data Relations Join Conditions
Central billing block for customer
  • Client
  • Central billing block for customer
  • ESH_N_CUSTOMERS_T.MANDT == TVFS.MANDT
  • ESH_N_CUSTOMERS_T.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Company Code
  • Client
  • Company Code
  • ESH_N_CUSTOMERS_T.MANDT == T001.MANDT
  • ESH_N_CUSTOMERS_T.COMPANYCODE == T001.BUKRS
Contact person department
  • Contact person department
  • Client
  • ESH_N_CUSTOMERS_T.CONTACTPERSONDEPARTMENT == TSAB.ABTNR
  • ESH_N_CUSTOMERS_T.MANDT == TSAB.MANDT
Contact person function
  • Client
  • Contact person function
  • ESH_N_CUSTOMERS_T.MANDT == TPFK.MANDT
  • ESH_N_CUSTOMERS_T.CONTACTPERSONFUNCTION == TPFK.PAFKT
Country/Region Key
  • Client
  • Country/Region Key
  • ESH_N_CUSTOMERS_T.MANDT == T005.MANDT
  • ESH_N_CUSTOMERS_T.COUNTRY == T005.LAND1
Customer Account Group
  • Client
  • Customer Account Group
  • ESH_N_CUSTOMERS_T.MANDT == T077D.MANDT
  • ESH_N_CUSTOMERS_T.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • ESH_N_CUSTOMERS_T.MANDT == TVLS.MANDT
  • ESH_N_CUSTOMERS_T.DELIVERYISBLOCKED == TVLS.LIFSP
Industry key
  • Client
  • Industry key
  • ESH_N_CUSTOMERS_T.MANDT == T016.MANDT
  • ESH_N_CUSTOMERS_T.INDUSTRY == T016.BRSCH
Language Key ESH_N_CUSTOMERS_T.LANGUAGE == T002.SPRAS
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • ESH_N_CUSTOMERS_T.MANDT == T005S.MANDT
  • ESH_N_CUSTOMERS_T.REGION == T005S.BLAND
  • ESH_N_CUSTOMERS_T.COUNTRY == T005S.LAND1