USERS Locate the document in its SAP Library structure

This system table contains all users.

USERS

OWNER

CHAR(32)

Name of the owner of the user

GROUPNAME

CHAR(32)

Group name

USERNAME

CHAR(32)

User name

USERMODE

CHAR(8)

Class of the user (SYSDBA | DBA | RESOURCE | STANDARD)

CONNECTMODE

CHAR(8)

Type of connection (MULTIPLE | SINGLE)

MAXTIMEOUT

FIXED(10)

TIMEOUT value

COSTWARNING

FIXED(10)

COSTWARNING value

COSTLIMIT

FIXED(10)

COSTLIMIT value

DEFAULTCODE

CHAR(8)

Default value for code attribute

CREATEDATE

DATE(10)

Creation date of the user

CREATETIME

TIME(8)

Creation time of the user

ALTERDATE

DATE(10)

Change date of the user

ALTERTIME

TIME(8)

Change time of the user

PWCREADATE

DATE(10)

Creation date of the password

PWCREATIME

TIME(8)

Creation time of the password

SERVERDB

CHAR(18)

Name of the database instance

SERVERNODE

CHAR(64)

Server node name of the database instance

USER_ID

FIXED(10)

User identification

COMMENT

LONG

Comment on the user

See also:

Evaluating System Tables: SAP DB 7.4, Structure linkUSERS section