| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | BNAME | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | XUBNAME | Allow NULL? |
| 3 | BCODE | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 4 | GLTGV | User valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUGLTGV | Allow NULL? |
| 5 | GLTGB | User valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUGLTGB | Allow NULL? |
| 6 | USTYP | User Type | char | 1 | 0 | CHAR | (N' ') | Yes | | XUUSTYP | Allow NULL? |
| 7 | CLASS | User group in user master maintenance | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUCLASS | Allow NULL? |
| 8 | LOCNT | Number of failed logon attempts | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | XULOCNT | |
| 9 | UFLAG | User Lock Status | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | XUUFLAG | |
| 10 | ACCNT | Account ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XUACCNT | Allow NULL? |
| 11 | ANAME | Creator of the User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XUANAME | Allow NULL? |
| 12 | ERDAT | Creation Date of the User Master Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUERDAT | Allow NULL? |
| 13 | TRDAT | Last Logon Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XULDATE | Allow NULL? |
| 14 | LTIME | Last Logon Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | XULTIME | Allow NULL? |
| 15 | OCOD1 | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 16 | BCDA1 | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 17 | CODV1 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVERS | Allow NULL? |
| 18 | OCOD2 | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 19 | BCDA2 | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 20 | CODV2 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVERS | Allow NULL? |
| 21 | OCOD3 | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 22 | BCDA3 | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 23 | CODV3 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVERS | Allow NULL? |
| 24 | OCOD4 | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 25 | BCDA4 | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 26 | CODV4 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVERS | Allow NULL? |
| 27 | OCOD5 | Password Hash Key | varbinary | 8 | 0 | RAW | | Yes | | XUCODE | |
| 28 | BCDA5 | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 29 | CODV5 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVERS | Allow NULL? |
| 30 | VERSN | User master record version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | XUVERSION | Allow NULL? |
| 31 | CODVN | Code Version of Password Hash Algorithm (New Systems) | char | 1 | 0 | CHAR | (N' ') | Yes | | XUCODEVER2 | Allow NULL? |
| 32 | TZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TZNZONE | Allow NULL? |
| 33 | ZBVMASTER | CUA User Template: Logon Not Possible Here | char | 1 | 0 | CHAR | (N' ') | Yes | | XUZBVFLAG | Allow NULL? |
| 34 | PASSCODE | Password Hash Value (SHA1, 160 Bit) | varbinary | 20 | 0 | RAW | | Yes | | PWD_SHA1 | |
| 35 | PWDCHGDATE | Date of Last Password Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUBCDAT | Allow NULL? |
| 36 | PWDSTATE | Password Change: Required / Allowed / Not Possible | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | PWDCHGSTATE | |
| 37 | RESERVED | CUA Control Information | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | XUCUACNTL | |
| 38 | PWDHISTORY | Indicator: Password History Stored in Table USRPWDHISTORY | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | XUPWDHIST | |
| 39 | PWDLGNDATE | Date of Last Password Logon | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XULPDAT | Allow NULL? |
| 40 | PWDSETDATE | Date: Password Reset by Administrator | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUSPDAT | Allow NULL? |
| 41 | PWDINITIAL | Indicator: Password Is Initial (= Set by Administrator) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | XUPWDINIT | |
| 42 | PWDLOCKDATE | Date: Setting of Password Lock | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XUPLDAT | Allow NULL? |
| 43 | PWDSALTEDHASH | Password Hash Value (Various Algorithms and Codings) | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | PWD_HASH_STRING | Allow NULL? |
| 44 | SECURITY_POLICY | Security Policy Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | SECURITY_POLICY_NAME | Allow NULL? |
