USR21

User Name/Address Key Assignment | #masterdata | Component: User and Authorization Management
Column Name Description
MANDT Client
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
TEMPLATE_ORGTYPE Organization Type Show values
Column Name Description Domain name
KOSTL Cost center CHAR8
START_MENU Start Menu SYCHAR30
BPPERSON Business Partner GUID SYSUUID
ORGANIZATION Business Partner GUID SYSUUID
RESPONSIBLE User Responsible for Technical User Account XUBNAME
TECHDESC Description of the Technical User Account SUIDTECHDESC
IDENTITY_GUID GUID of the Identity SYSUUID
TEMPLATE_ORGADDR Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Address number of a user
  • Address Number
  • ?
  • ?
  • USR21.MANDT == ADRC.CLIENT
  • USR21.ADDRNUMBER == ADRC.ADDRNUMBER
  • USR21.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • USR21.[column in domain "AD_NATION"] == ADRC.NATION
Address key assignment to users
  • USR21.MANDT == USR02.MANDT
  • USR21.BNAME == USR02.BNAME
Address number of a user
  • ?
  • ?
  • Client
  • Person Number
  • USR21.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • USR21.[column in domain "AD_NATION"] == ADRP.NATION
  • USR21.MANDT == ADRP.CLIENT
  • USR21.PERSNUMBER == ADRP.PERSNUMBER