- Home
- Resources
- SAP Tables
- SIM_RSUSR200_ALV - Structure for the ALV Report RSUSR200
SAP Table SIM_RSUSR200_ALV
Structure for the ALV Report RSUSR200
SIM_RSUSR200_ALV (Structure for the ALV Report RSUSR200) 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 SIM_RSUSR200_ALV to other SAP tables.
Source: SIM_RSUSR200_ALV (Structure for the ALV Report RSUSR200)
SIM_RSUSR200_ALV table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| BNAME |
User Name in User Master Record |
XUBNAME |
|
CHAR |
|
12 |
0 |
|
| SYSTEM |
Receiving system for central user administration |
RFCRCVSYS |
|
CHAR |
|
10 |
0 |
|
| CLASS |
User group in user master maintenance |
XUCLASS |
|
CHAR |
|
12 |
0 |
|
| USTYP |
User Type |
XUUSTYP |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Dialog |
| B |
System |
| C |
Communications Data |
| L |
Reference (Logon not possible) |
| S |
Service |
|
| ANAME |
Creator of the User Master Record |
XUANAME |
|
CHAR |
|
12 |
0 |
|
| ERDAT |
Creation Date of the User Master Record |
XUERDAT |
|
DATS |
|
8 |
0 |
|
| GLTGV |
User valid from |
XUGLTGV |
|
DATS |
|
8 |
0 |
|
| GLTGB |
User valid to |
XUGLTGB |
|
DATS |
|
8 |
0 |
|
| TRDAT1 |
Date of Last Logon |
XULDATE_ALV |
|
CHAR |
|
30 |
0 |
|
| LTIME |
Last Logon Time |
XULTIME |
|
TIMS |
|
6 |
0 |
|
| ICON_STATE |
Password Status |
XUBCDAT_STATALV |
|
CHAR |
|
5 |
0 |
|
| BCDA1 |
Date of Last Password Change |
XUBCDAT |
|
DATS |
|
8 |
0 |
|
| ICON_LOCKED |
User Lock Status |
XUUFLAG_ALV |
|
CHAR |
|
5 |
0 |
|
| LOCK_REASON |
Reason for User Lock |
XUUREASON_ALV |
|
CHAR |
|
80 |
0 |
|
| LOCNT |
Number of failed logon attempts |
XULOCNT |
|
INT1 |
|
3 |
0 |
|
| CODVN |
Code Version of Password Hash Algorithm (Old Systems) |
XUCODEVERS |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Code Version A (Obsolete) |
| B |
Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII) |
| C |
Code Version C (Not Implemented) |
| D |
Code Version D (MD5-Based, 8 Characters, Upper-Case, UTF-8) |
| E |
Code Version E (Corrected Code Version D) |
| X |
Password Deactivated |
|
| USR02FLAG |
User Lock Status |
XUUFLAG |
|
INT1 |
|
3 |
0 |
Possible values
| 0 |
Not Locked |
| 32 |
Locked Globally By Administrator |
| 64 |
Locked Locally By Administrator |
| 128 |
Locked Due To Incorrect Logons (Limited Term) |
|
| TRDAT |
Last Logon Date |
XULDATE |
|
DATS |
|
8 |
0 |
|
| COLOR |
|
LVC_T_SCOL |
|
TTYP |
|
0 |
0 |
|
| PWDLOCKDATE |
Date: Setting of Password Lock |
XUPLDAT |
|
DATS |
|
8 |
0 |
|
| RELEASE |
SAP Release |
SAPRELEASE |
|
CHAR |
|
10 |
0 |
|
| SECURITY_POLICY |
Security Policy Name |
SECURITY_POLICY_NAME |
|
CHAR |
|
40 |
0 |
|
