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 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||
| 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) | DATE_FROM | |
| USR21 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| USR21 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | CLIENT | |
| USR21 | ADDRNUMBER | USR21 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| 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) | NATION | |
| USR21 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | CLIENT | |
| USR21 | PERSNUMBER | USR21 | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| USR21 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
