ESH_N_COMPANY_ADDRESS_ADDRESS

Node COMPANY_ADDRESS of search model COMPANY_ADDRESS_H | view: ESH_L_COMPA_RESS | Extraction: Not supported | Component: NetWeaver Enterprise Search
Tables used: ADRC
Column Name Description
addrnumber Address Number
date_from Valid-from date - in current Release only 00010101 possible
nation FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
date_from Valid-from date - in current Release only 00010101 possible
date_to Valid-to date in current Release only 99991231 possible
Column Name Description
Column Name Description Domain name
name1 Name 1 TEXT40
name2 Name 2 TEXT40
city1 City TEXT40
post_code1 City postal code CHAR10
po_box PO Box CHAR10
street Street TEXT60
house_num1 House Number TEXT10
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • ESH_N_COMPANY_ADDRESS_ADDRESS.MANDT == T005.MANDT
  • ESH_N_COMPANY_ADDRESS_ADDRESS.COUNTRY == T005.LAND1
Version ID for International Addresses ESH_N_COMPANY_ADDRESS_ADDRESS.NATION == TSADV.NATION
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • ESH_N_COMPANY_ADDRESS_ADDRESS.MANDT == T005S.MANDT
  • ESH_N_COMPANY_ADDRESS_ADDRESS.COUNTRY == T005S.LAND1
  • ESH_N_COMPANY_ADDRESS_ADDRESS.REGION == T005S.BLAND
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • ESH_N_COMPANY_ADDRESS_ADDRESS.MANDT == TSAD3.CLIENT
  • ESH_N_COMPANY_ADDRESS_ADDRESS.TITLE == TSAD3.TITLE