P_UserAddress

User Address for All Users Including Business Partner | view: PUSERADDRESS | Extraction: Not supported | Component: User and Authorization Management
Tables used: USR02USR21
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
kostl Cost center CHAR8
bpperson Business Partner GUID SYSUUID
template_orgaddr Address Number AD_ADDRNUM
techdesc Description of the Technical User Account SUIDTECHDESC
Master Data Relations Join Conditions
Address number of a user
  • ?
  • ?
  • Address Number
  • Client
  • P_USERADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • P_USERADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_USERADDRESS.ADDRNUMBER == ADRC.ADDRNUMBER
  • P_USERADDRESS.MANDT == ADRC.CLIENT
Address key assignment to users
  • User Name in User Master Record
  • Client
  • P_USERADDRESS.BNAME == USR02.BNAME
  • P_USERADDRESS.MANDT == USR02.MANDT
User group
  • User group in user master maintenance
  • Client
  • P_USERADDRESS.CLASS == USGRP.USERGROUP
  • P_USERADDRESS.MANDT == USGRP.MANDT
Address number of a user
  • ?
  • ?
  • Person Number
  • Client
  • P_USERADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • P_USERADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_USERADDRESS.PERSNUMBER == ADRP.PERSNUMBER
  • P_USERADDRESS.MANDT == ADRP.CLIENT