| 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') | No | | XUGLTGV | Allow NULL? |
| 5 | GLTGB | User valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | XUGLTGB | Allow NULL? |
| 6 | USTYP | User Type | char | 1 | 0 | CHAR | (N' ') | No | | XUUSTYP | Allow NULL? |
| 7 | CLASS | User group in user master maintenance | nvarchar | 12 | 0 | CHAR | (N' ') | No | USGRP | XUCLASS | Allow NULL? |
| 8 | LOCNT | Number of failed logon attempts | tinyint | 3 | 0 | INT1 | ((0)) | No | | XULOCNT | |
| 9 | UFLAG | User Lock Status | tinyint | 3 | 0 | INT1 | ((0)) | No | | XUUFLAG | |
| 10 | ACCNT | Account ID | nvarchar | 12 | 0 | CHAR | (N' ') | No | | XUACCNT | Allow NULL? |
| 11 | ANAME | Creator of the User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | No | | XUANAME | Allow NULL? |
| 12 | ERDAT | Creation Date of the User Master Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | XUERDAT | Allow NULL? |
| 13 | TRDAT | Last Logon Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | XULDATE | Allow NULL? |
| 14 | LTIME | Last Logon Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | 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') | No | | XUBCDAT | Allow NULL? |
| 17 | CODV1 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | 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') | No | | XUBCDAT | Allow NULL? |
| 20 | CODV2 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | 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') | No | | XUBCDAT | Allow NULL? |
| 23 | CODV3 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | 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') | No | | XUBCDAT | Allow NULL? |
| 26 | CODV4 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | 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') | No | | XUBCDAT | Allow NULL? |
| 29 | CODV5 | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | XUCODEVERS | Allow NULL? |
| 30 | VERSN | User master record version | nvarchar | 3 | 0 | CHAR | (N' ') | No | | XUVERSION | Allow NULL? |
| 31 | CODVN | Code Version of Password Hash Algorithm (Old Systems) | char | 1 | 0 | CHAR | (N' ') | No | | XUCODEVERS | Allow NULL? |
| 32 | TZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | TZNZONE | Allow NULL? |
| 33 | ZBVMASTER | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
