HCI_USER

SAP CC Users (Technical Settings)

Description

The HCI_USER table contains information about the authorized users of the connected SAP CC system. They can be humans or systems (individual users or service users). The USER_RIGHT table includes the authorization roles assigned to an SAP CC user.

Technical Data

Schema Version	4.5.13
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The HCI_USER table is defined by the following columns. See the column details for more information.

Name	PK	IX	Uses	Used by
OID	PK_HCI_USER			USER_RIGHT (USER_OID) USER_PASSWORD (USER_OID) USER_FAILED_AUTHENTICATION (USER_OID)
LOGIN_ID		IX_LOGIN
SALT
PASSWORD
ROUNDS
CATALOG_NAME			CATALOG_ENTRY (ENTRY_NAME)
LAST_ACTIVITY_DATE
PASSWORD_CHANGE_DATE
FAILED_LOGIN_COUNT
LOCKED
IS_HUMAN
CHANGE_PASSWORD

Column Details

OID

Definition	The unique ID of an SAP CC user. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_HCI_USER

LOGIN_ID

Definition	The SAP user logon
Type	VARCHAR(64), NOT NULL
Available Index	IX_LOGIN

SALT

Definition	The salt used to hash the password. If it is null or empty, then no salt is used.
Type	VARCHAR(64), NULL

PASSWORD

Definition	The hashed password of the SAP CC user. The hashing algorithm used is SHA-256.
Type	VARCHAR(1000), NULL

ROUNDS

Definition	The number of rounds applied to the plain text password to obtain the hashed password. The value 0 means that the former hashing algorithm (one round of SHA-1) is in use for this user.
Type	DECIMAL(5), NOT NULL
Default	0

CATALOG_NAME

Definition

The name of the pricing catalog the SAP CC user is associated to

Format

If this field is not set, the SAP CC user has access to objects from every pricing catalog defined in the SAP CC system.
If this field is set with the name of a catalog, the user only has access to the objects contained in this catalog.

Type

VARCHAR(64), NULL

LAST_ACTIVITY_DATE

Definition	The date of the last activity of the SAP CC user
Type	TIMESTAMP, NULL

PASSWORD_CHANGE_DATE

Definition	The last modification date of the password
Description	The last modification date of the password. This field is used only if the advanced password management is enabled.
Format	The `NULL` value can be used to force the expiration of the password. At the creation of a new SAP CC user, the field is filled with the NULL value, so that the user must change his password at the first logon.
Type	TIMESTAMP, NULL

FAILED_LOGIN_COUNT

Definition	The number of times the user entered a wrong password when trying to log in
Description	The number of times the user entered a wrong password when trying to log in. If the advanced password management is enabled and if the value of FAILED_LOGIN_COUNT is greater than the maximum number of allowed errors (defined by the parameter PASSWORD_MANAGEMENT_FAIL_LIMIT), the user account is locked. The user cannot do anything until it is unlocked by an administrator.
Format	The initial value of this field is `0`, and it is reset every time the password of the SAP user is modified.
Type	DECIMAL(3), NOT NULL

LOCKED

Definition	The field LOCKED specifies if the user is locked or not
Description	The field LOCKED specifies if the user is locked or not. This field is used only if the advanced password management function is enabled.
Type	DECIMAL(1), NOT NULL

IS_HUMAN

Definition	The field IS_HUMAN specifies if the SAP CC user is a human user, or a non-human (service) user
Description	The field IS_HUMAN specifies if the SAP CC user is a human user, or a non-human (service) user. Service users have fewer constraints relative to their passwords: they cannot be locked due to authentication failures, and their password never expire.
Type	DECIMAL(1), NOT NULL

CHANGE_PASSWORD

Definition	The field CHANGE_PASSWORD specifies if the SAP user must change its password at the next logon
Type	DECIMAL(1), NOT NULL
Default	0

Primary Key Details

PK_HCI_USER

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

The following database indexes are available in the HCI_USER database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_LOGIN

Indexed Column(s)	LOGIN_ID
Unique	Yes
Partitioned	No
Tablespace	CATALOG_INDX