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.
Related Tables
| Schema Version | 2022.0.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
The HCI_USER table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| OID | PK_HCI_USER |
|
The unique ID of an SAP CC user. It is generated by the SAP CC system. | |||
| LOGIN_ID | IX_LOGIN |
|
The SAP user logon | |||
| SALT |
|
The salt used to hash the password. If it is null or empty, then no salt is used. | ||||
| PASSWORD |
|
The hashed password of the SAP CC user. The hashing algorithm used is SHA-256. | ||||
| ROUNDS |
|
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. | ||||
| CATALOG_NAME | CATALOG_ENTRY (ENTRY_NAME)
|
|
The name of the pricing catalog the SAP CC user is associated to | |||
| LAST_ACTIVITY_DATE |
|
The date of the last activity of the SAP CC user. This field is not used if the user is a service user (another system). | ||||
| PASSWORD_CHANGE_DATE |
|
The last modification date of the password | ||||
| FAILED_LOGIN_COUNT |
|
The number of times the SAP user entered a wrong password when trying to log on | ||||
| LOCKED |
|
The information if the SAP CC user is locked or not in the system | ||||
| IS_HUMAN |
|
The information if the SAP CC user is an individual user (human user), or a service user (non-human user) | ||||
| CHANGE_PASSWORD |
|
The information if the SAP CC user must change the password at the next logon | ||||
| CREATION_DATE |
|
The date of the creation of the SAP CC user. | ||||
| LAST_MODIFICATION_DATE |
|
The date of the last modification of the SAP CC user. | ||||
| VALID_FROM |
|
The start date of the SAP CC user validity, inclusive. This field is not used if the user is a service user. | ||||
| VALID_TO |
|
The end date of the SAP CC user validity, exclusive. This field is not used if the user is a service user. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| 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 |
| Definition | The SAP user logon |
| Type | NVARCHAR(64), NOT NULL |
| Available Index | IX_LOGIN |
| Definition | The salt used to hash the password. If it is null or empty, then no salt is used. |
| Type | NVARCHAR(64), NULL |
| Definition | The hashed password of the SAP CC user. The hashing algorithm used is SHA-256. |
| Type | NVARCHAR(1000), NULL |
| 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 |
| Definition | The name of the pricing catalog the SAP CC user is associated to |
| Description |
The field CATALOG_NAME is the identification codename
|
| Format |
|
| Type | NVARCHAR(64), NULL |
| Definition | The date of the last activity of the SAP CC user. This field is not used if the user is a service user (another system). |
| Type | DATETIME, NULL |
| Definition | The last modification date of the password |
| Description |
The field PASSWORD_CHANGE_DATE is the last modification date of the password.
This field is used only if the advanced password management is enabled.
|
| Format |
The |
| Type | DATETIME, NULL |
| Definition | The number of times the SAP user entered a wrong password when trying to log on |
| Description |
The field FAILED_LOGIN_COUNT is 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 |
| Type | DECIMAL(3), NOT NULL |
| Definition | The information if the SAP CC user is locked or not in the system |
| 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 |
| Definition | The information if the SAP CC user is an individual user (human user), or a service user (non-human user) |
| Description |
The field IS_HUMAN specifies if the SAP CC user is:
Service users have fewer constraints relative to their passwords:
they cannot be locked due to authentication failures, and their password never expire.
See the SAP CC Security Guide for more information.
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The information if the SAP CC user must change the password at the next logon |
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
| Definition | The date of the creation of the SAP CC user. |
| Type | DATETIME, NULL |
| Definition | The date of the last modification of the SAP CC user. |
| Type | DATETIME, NULL |
| Definition | The start date of the SAP CC user validity, inclusive. This field is not used if the user is a service user. |
| Type | DATETIME, NULL |
| Definition | The end date of the SAP CC user validity, exclusive. This field is not used if the user is a service user. |
| Type | DATETIME, NULL |
See the primary key information:
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
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:
| Indexed Column(s) | LOGIN_ID |
| Unique | Yes |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
