ESH_S_CUSTOMERS_T

Search view -CUSTOMERS_T | view: ESH_U_CUSTOMERST | Extraction: Not supported | Component: Business Partners
Tables used: ADCPADRCADR6BUT000ADRPKNVKT005T005TKNA1KNB1KNB5KNVVCVI_CUST_LINKTVTWTVTWTTSPATSPATT005ST005UTVKOTVKOT
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
CREATEDBYUSER Name of Person who Created the Object USNAM
DISTRIBUTIONCHANNEL Distribution Channel VTWEG
DISTRIBUTIONCHANNELNAME Distribution Channel Description
DIVISION Division SPART
DIVISIONNAME Division Description
EMAILADDRESS E-Mail Address
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
POSTALCODE Postal Code PSTLZ
REGIONNAME Description
SALESORGANIZATION Sales Organization VKORG
SALESORGANIZATIONNAME Sales Organization Description
SEARCHTERM1 Search Term 1 for Business Partner
STREETNAME Street and House Number
TAXNUMBER1 Tax Number 1
VATREGISTRATION VAT Registration Number STCEG
Master Data Relations Join Conditions
Central billing block for customer
  • Central billing block for customer
  • Client
  • ESH_S_CUSTOMERS_T.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
  • ESH_S_CUSTOMERS_T.MANDT == TVFS.MANDT
Company Code
  • Company Code
  • Client
  • ESH_S_CUSTOMERS_T.COMPANYCODE == T001.BUKRS
  • ESH_S_CUSTOMERS_T.MANDT == T001.MANDT
Contact person department
  • Contact person department
  • Client
  • ESH_S_CUSTOMERS_T.CONTACTPERSONDEPARTMENT == TSAB.ABTNR
  • ESH_S_CUSTOMERS_T.MANDT == TSAB.MANDT
Contact person function
  • Client
  • Contact person function
  • ESH_S_CUSTOMERS_T.MANDT == TPFK.MANDT
  • ESH_S_CUSTOMERS_T.CONTACTPERSONFUNCTION == TPFK.PAFKT
Country/Region Key
  • Country/Region Key
  • Client
  • ESH_S_CUSTOMERS_T.COUNTRY == T005.LAND1
  • ESH_S_CUSTOMERS_T.MANDT == T005.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • ESH_S_CUSTOMERS_T.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • ESH_S_CUSTOMERS_T.MANDT == T077D.MANDT
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • ESH_S_CUSTOMERS_T.DELIVERYISBLOCKED == TVLS.LIFSP
  • ESH_S_CUSTOMERS_T.MANDT == TVLS.MANDT
Industry key
  • Industry key
  • Client
  • ESH_S_CUSTOMERS_T.INDUSTRY == T016.BRSCH
  • ESH_S_CUSTOMERS_T.MANDT == T016.MANDT
Language Key ESH_S_CUSTOMERS_T.LANGUAGE == T002.SPRAS
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • ESH_S_CUSTOMERS_T.COUNTRY == T005S.LAND1
  • ESH_S_CUSTOMERS_T.MANDT == T005S.MANDT
  • ESH_S_CUSTOMERS_T.REGION == T005S.BLAND