USER_OPERATION
Definition
The USER_OPERATION table contains the recordings of all the audited user operations that were executed by the SAP CC system
Description
The USER_OPERATION table contains the execution recordings all the audited and tracked
user operations requested by the SAP CC users (individual or service users).
Depending on the system configuration, the SAP CC Core Server system audits a selection
of user operations by recording an entry in the database table.
Consult the SAP CC Application Help for more information about the audit concept and
features.
The USER_OPERATION table relates to the OBJECT_CHANGE_LOG table.
Note
This database table is part of the audit data recordings.
Consider sizing (implementation phase) and purging (technical operations).
Technical Data
| Schema Version | 4.6.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
Summary
The USER_OPERATION 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_USER_OPERATION |
|
The identifier of the audited operation record | |||
| OPERATION_NAME | IX_UOP_OPNAME |
|
A technical name of the audited user operation | |||
| OPERATOR_NAME | HCI_USER (LOGIN_ID)
|
|
The SAP CC user who requested the user operation that was audited by the SAP CC system | |||
| OPERAND_REFERENCE |
|
An identifier of the audited user operation. It is a name, code, or a reference. | ||||
| MESSAGE |
|
The message describing the result of the execution of the audited operation | ||||
| RECORDING_DATE | IX_UOP_OPDATE |
|
The date when the audited operation was executed by the SAP CC system |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| Definition | The identifier of the audited operation record |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_USER_OPERATION |
OPERATION_NAME
| Definition | A technical name of the audited user operation |
| Type | NVARCHAR(256), NOT NULL |
| Available Index | IX_UOP_OPNAME |
OPERATOR_NAME
| Definition | The SAP CC user who requested the user operation that was audited by the SAP CC system |
| Type | NVARCHAR(256), NULL |
OPERAND_REFERENCE
| Definition | An identifier of the audited user operation. It is a name, code, or a reference. |
| Type | NVARCHAR(256), NULL |
MESSAGE
| Definition | The message describing the result of the execution of the audited operation |
| Type | NVARCHAR(2000), NULL |
RECORDING_DATE
| Definition | The date when the audited operation was executed by the SAP CC system |
| Type | DATETIME, NOT NULL |
| Available Index | IX_UOP_OPDATE |
Primary Key Details
See the primary key information:
PK_USER_OPERATION
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
Index Details
The following database indexes are available in the USER_OPERATION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_UOP_OPDATE
| Indexed Column(s) | RECORDING_DATE |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
IX_UOP_OPNAME
| Indexed Column(s) | OPERATION_NAME |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |