ESH_N_USER_USER_DETAILS

Node USER_DETAILS of search model USER_H | view: ESH_L_USER_TAILS | Extraction: Not supported | Component: NetWeaver Enterprise Search
Tables used: ADCP
Column Name Description
addrnumber FK Address Number
persnumber FK Person Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
department Department TEXT40
function Function TEXT40
building Building (number or code) TEXT10
floor Floor in building TEXT10
roomnumber Room or Apartment Number TEXT10
ih_mail Internal Mail Postal Code TEXT10
Master Data Relations Join Conditions
Address key
  • Client
  • ?
  • ?
  • Address Number
  • ESH_N_USER_USER_DETAILS.MANDT == ADRC.CLIENT
  • ESH_N_USER_USER_DETAILS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ESH_N_USER_USER_DETAILS.[column in domain "AD_NATION"] == ADRC.NATION
  • ESH_N_USER_USER_DETAILS.ADDRNUMBER == ADRC.ADDRNUMBER
Key of person
  • Client
  • Person Number
  • ?
  • ?
  • ESH_N_USER_USER_DETAILS.MANDT == ADRP.CLIENT
  • ESH_N_USER_USER_DETAILS.PERSNUMBER == ADRP.PERSNUMBER
  • ESH_N_USER_USER_DETAILS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ESH_N_USER_USER_DETAILS.[column in domain "AD_NATION"] == ADRP.NATION