P_USER002

User Address for All Users Including Business Partner | view: PUSER002 | Extraction: Not supported | Component: User and Authorization Management
Tables used: ADCP, ADR6, ADRC, ADRP, USR02, USR21
Column Name Description
bname FK User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
name_text Full Name of Person TEXT80
kostl Cost center CHAR8
department Department TEXT40
function Function TEXT40
building Building (number or code) TEXT10
floor Floor in building TEXT10
roomnumber Room or Apartment Number TEXT10
tel_number First telephone no.: dialling code+number CHAR30
tel_extens First Telephone No.: Extension CHAR10
INHOUSE_ML Internal Mail Postal Code TEXT10
name1 Name 1 TEXT40
city1 City TEXT40
post_code1 City postal code CHAR10
street Street TEXT60
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_USER002.BNAME == USR02.BNAME
  • P_USER002.MANDT == USR02.MANDT
User group
  • User group in user master maintenance
  • Client
  • P_USER002.CLASS == USGRP.USERGROUP
  • P_USER002.MANDT == USGRP.MANDT
Country key
  • Country/Region Key
  • Client
  • P_USER002.COUNTRY == T005.LAND1
  • P_USER002.MANDT == T005.MANDT