P_UserAddress002

User Address for All Users Including Business Partner | view: PUSADDR002 | Extraction: Not supported | Component: User and Authorization Management
Tables used: USR02USR21ADCPADR6ADRCADRPBUT000
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
partner Business Partner Number BU_PARTNER
smtp_addr E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address key assignment to users
  • User Name in User Master Record
  • Client
  • P_USERADDRESS002.BNAME == USR02.BNAME
  • P_USERADDRESS002.MANDT == USR02.MANDT
User group
  • User group in user master maintenance
  • Client
  • P_USERADDRESS002.CLASS == USGRP.USERGROUP
  • P_USERADDRESS002.MANDT == USGRP.MANDT