ESH_S_SOR_CUSTOMER

Search view -SOR_CUSTOMER | view: ESH_U_SOR_CUST | Extraction: Not supported | Component: Sales Document Creation Based on Unstructured Data
Tables used: ADCPADRCADR6BUT000T005T005TKNA1CVI_CUST_LINKT005ST005U
Column Name Description
CUSTOMER Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
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
DISTRICT District TEXT40
EMAILADDRESS E-Mail Address AD_SMTPADR
FAXNUMBER Fax Number TEXT31
FIRSTNAME First name of business partner (person) BU_NAME
HOUSENUMBER House Number TEXT10
LASTNAME Last name of business partner (person) BU_NAME
ORGANIZATIONBPNAME1 Name 1 NAME
ORGANIZATIONBPNAME2 Name 2 NAME
POSTALCODE Postal Code PSTLZ
REGIONNAME Description TEXT20
STREETNAME Street and House Number
TAXNUMBER1 Tax Number 1 STCD1
TAXNUMBER2 Tax Number 2 STCD2
TAXNUMBER3 Tax Number 3 CHAR18
TAXNUMBER4 Tax Number 4 CHAR18
TAXNUMBER5 Tax Number 5 CHAR60
TELEPHONENUMBER1 First telephone number TEXT16
TELEPHONENUMBER2 Second telephone number TEXT16
VATREGISTRATION VAT Registration Number STCEG
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • ESH_S_SOR_CUSTOMER.COUNTRY == T005.LAND1
  • ESH_S_SOR_CUSTOMER.MANDT == T005.MANDT
Customer Account Group
  • Client
  • Customer Account Group
  • ESH_S_SOR_CUSTOMER.MANDT == T077D.MANDT
  • ESH_S_SOR_CUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Language Key ESH_S_SOR_CUSTOMER.LANGUAGE == T002.SPRAS
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • ESH_S_SOR_CUSTOMER.COUNTRY == T005S.LAND1
  • ESH_S_SOR_CUSTOMER.MANDT == T005S.MANDT
  • ESH_S_SOR_CUSTOMER.REGION == T005S.BLAND