SAP Table API_RSUSR200_ALV

Structure for the ALV Report RSUSR200

API_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 API_RSUSR200_ALV to other SAP tables.

API_RSUSR200_ALV table fields

Field Data element Checktable Datatype Length Decimals
BNAME User Name in User Master Record XUBNAME CHAR 12 0
CLASS User group in user master maintenance XUCLASS CHAR 12 0
USTYP User Type XUUSTYP CHAR 1 0
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
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
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
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