SAP table SIM_RSUSR200_ALV (Structure for the ALV Report RSUSR200)
SAP table SIM_RSUSR200_ALV has 1 primary key field being BNAME.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BNAME | User Name in User Master Record | CHAR | 12 | 0 | XUBNAME | ||||||||||||||
| SYSTEM | Receiving system for central user administration | CHAR | 10 | 0 | RFCRCVSYS | ||||||||||||||
| CLASS | User group in user master maintenance | CHAR | 12 | 0 | XUCLASS | ||||||||||||||
| USTYP | User Type | CHAR | 1 | 0 | XUUSTYP |
|
|||||||||||||
| ANAME | Creator of the User Master Record | CHAR | 12 | 0 | XUANAME | ||||||||||||||
| ERDAT | Creation Date of the User Master Record | DATS | 8 | 0 | XUERDAT | ||||||||||||||
| GLTGV | User valid from | DATS | 8 | 0 | XUGLTGV | ||||||||||||||
| GLTGB | User valid to | DATS | 8 | 0 | XUGLTGB | ||||||||||||||
| TRDAT1 | Date of Last Logon | CHAR | 30 | 0 | XULDATE_ALV | ||||||||||||||
| LTIME | Last Logon Time | TIMS | 6 | 0 | XULTIME | ||||||||||||||
| TRDAT_JOB | Last Login Date Job | DATS | 8 | 0 | XULDATE_JOB | ||||||||||||||
| LTIME_JOB | Last Logon Time Job | TIMS | 6 | 0 | XULTIME_JOB | ||||||||||||||
| TRDAT_RCT | Last Logon Date | DATS | 8 | 0 | XULDATE | ||||||||||||||
| ICON_STATE | Password Status | CHAR | 5 | 0 | XUBCDAT_STATALV | ||||||||||||||
| BCDA1 | Date of Last Password Change | DATS | 8 | 0 | XUBCDAT | ||||||||||||||
| ICON_LOCKED | User Lock Status | CHAR | 5 | 0 | XUUFLAG_ALV | ||||||||||||||
| LOCK_REASON | Reason for User Lock | CHAR | 80 | 0 | XUUREASON_ALV | ||||||||||||||
| LOCNT | Number of failed logon attempts | INT1 | 3 | 0 | XULOCNT | ||||||||||||||
| CODVN | Code Version of Password Hash Algorithm (Old Systems) | CHAR | 1 | 0 | XUCODEVERS |
|
|||||||||||||
| USR02FLAG | User Lock Status | INT1 | 3 | 0 | XUUFLAG |
|
|||||||||||||
| TRDAT | Last Logon Date | DATS | 8 | 0 | XULDATE | ||||||||||||||
| COLOR | TTYP | 0 | 0 | LVC_T_SCOL | |||||||||||||||
| PWDLOCKDATE | Date: Setting of Password Lock | DATS | 8 | 0 | XUPLDAT | ||||||||||||||
| RELEASE | SAP Release | CHAR | 10 | 0 | SAPRELEASE | ||||||||||||||
| SECURITY_POLICY | Security Policy Name | CHAR | 40 | 0 | SECURITY_POLICY_NAME | ||||||||||||||
| NAME_FIRST | First name | CHAR | 40 | 0 | AD_NAMEFIR | ||||||||||||||
| NAME_LAST | Last name | CHAR | 40 | 0 | AD_NAMELAS | ||||||||||||||
| DEPARTMENT | Department | CHAR | 40 | 0 | AD_DPRTMNT |