SAP Table USR21
User Name/Address Key Assignment
USR21 (User Name/Address Key Assignment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link USR21 to other SAP tables.
USR21 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
BNAME
User Name in User Master Record
|
XUBNAME | USR02 |
CHAR
|
12 | 0 | |||||||||||||
|
PERSNUMBER
Person number
|
AD_PERSNUM | ADRP |
CHAR
|
10 | 0 | |||||||||||||
|
ADDRNUMBER
Address number
|
AD_ADDRNUM | ADRC |
CHAR
|
10 | 0 | |||||||||||||
|
KOSTL
Cost center
|
XUKOSTL |
CHAR
|
8 | 0 | ||||||||||||||
|
START_MENU
Start menu
|
XUSTART |
CHAR
|
30 | 0 | ||||||||||||||
|
IDADTYPE
Address Type of the Identity
|
SUIDADTYPE |
NUMC
|
2 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BPPERSON
Business Partner GUID
|
BU_PARTNER_GUID |
RAW
|
16 | 0 | ||||||||||||||
|
ORGANIZATION
Business Partner GUID
|
BU_PARTNER_GUID |
RAW
|
16 | 0 | ||||||||||||||
|
RESPONSIBLE
User Responsible for Technical User Account
|
SUIDRESPONSIBLE |
CHAR
|
12 | 0 | ||||||||||||||
|
TECHDESC
Description of the Technical User Account
|
SUIDTECHDESC |
CHAR
|
80 | 0 | ||||||||||||||
|
IDENTITY_GUID
GUID of the Identity
|
SUID_GUID |
RAW
|
16 | 0 | ||||||||||||||
USR21 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| USR21 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
CLIENT | |
| USR21 | ADDRNUMBER | USR21 | ADDRNUMBER |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| USR21 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| USR21 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| USR21 | BNAME | * |
USR02
Logon Data (Kernel-Side Use)
|
MANDT | |
| USR21 | BNAME | USR21 | BNAME |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| USR21 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
DATE_FROM | |
| USR21 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
NATION | |
| USR21 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
CLIENT | |
| USR21 | PERSNUMBER | USR21 | PERSNUMBER |
ADRP
Persons (Business Address Services)
|
PERSNUMBER |