P_USER_ADDR

F4 Search Help for Users | view: PUSER_ADDR | Extraction: Not supported | Component: User and Authorization Management
Tables used: ADCP, ADRC, ADRP, USR02, USR21, USCOMPANY
Column Name Description
bname FK User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
idadtype Address Type of the Identity Show values
Column Name Description Domain name
name_first First name TEXT40
name_last Last name TEXT40
NAME_TEXTC Full Name of Person TEXT80
tel_extens First Telephone No.: Extension CHAR10
kostl Cost center CHAR8
building Building (number or code) TEXT10
roomnumber Room or Apartment Number TEXT10
department Department TEXT40
INHOUSE_ML Internal Mail Postal Code TEXT10
name1 Name 1 TEXT40
city1 City TEXT40
post_code1 City postal code CHAR10
mc_namefir First Name in Uppercase for Search Help CHAR25
mc_namelas Last Name in Uppercase for Search Help CHAR25
mc_name1 Name (Field NAME1) in Uppercase for Search Help CHAR25
mc_city1 City name in Uppercase for Search Help CHAR25
company Company address, cross-system key USCOMP
Master Data Relations Join Conditions
Address key assignment to users
  • Client
  • User Name in User Master Record
  • P_USER_ADDR.MANDT == USR02.MANDT
  • P_USER_ADDR.BNAME == USR02.BNAME
User group
  • User group in user master maintenance
  • Client
  • P_USER_ADDR.CLASS == USGRP.USERGROUP
  • P_USER_ADDR.MANDT == USGRP.MANDT