SAP table USR21 (User Name/Address Key Assignment)

SAP table USR21 has 2 primary key fields being MANDT,BNAME.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BNAME User Name in User Master Record CHAR 12 0 USR02 XUBNAME
PERSNUMBER Person Number CHAR 10 0 ADRP AD_PERSNUM
ADDRNUMBER Address Number CHAR 10 0 ADRC AD_ADDRNUM
KOSTL Cost center CHAR 8 0 XUKOSTL
START_MENU Start Menu CHAR 30 0 XUSTART
IDADTYPE Address Type of the Identity NUMC 2 0 SUIDADTYPE
00 User's Old Type 3 Address
01 Technical User
02 Identity (User Account with BP Person)
03 Identity with BP Person, BP Organization and Type 3 Address
04 Identity with Workplace Address
BPPERSON Business Partner GUID RAW 16 0 BU_PARTNER_GUID
ORGANIZATION Business Partner GUID RAW 16 0 BU_PARTNER_GUID
RESPONSIBLE User Responsible for Technical User Account CHAR 12 0 SUIDRESPONSIBLE
TECHDESC Description of the Technical User Account CHAR 80 0 SUIDTECHDESC
IDENTITY_GUID GUID of the Identity RAW 16 0 SUID_GUID
TEMPLATE_ORGTYPE Organization Type CHAR 1 0 SUID_ORGTYPE
C Company
E Employee
O BP Organization
TEMPLATE_ORGADDR Address Number CHAR 10 0 AD_ADDRNUM

USR21 foreign key relationships

Table Field Check Table Check Field
0 USR21 ADDRNUMBER ADRC Addresses (Business Address Services) DATE_FROM
0 USR21 ADDRNUMBER ADRC Addresses (Business Address Services) NATION
1 USR21 BNAME USR02 Logon Data (Kernel-Side Use) BNAME
0 USR21 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
0 USR21 PERSNUMBER ADRP Persons (Business Address Services) DATE_FROM
0 USR21 PERSNUMBER ADRP Persons (Business Address Services) NATION