USER_OPERATION

Audited User Operations (in Technical Data)

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.

Technical Data

Schema Version	2022.0.2
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				OBJECT_CHANGE_LOG (USER_OPERATION_OID)	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
INSTANCE_ID						The unique ID of the instance on which the user operation was performed More...

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

INSTANCE_ID

Definition	The unique ID of the instance on which the user operation was performed
Description	The unique instance ID. It is composed of three elements: the type of instance the separator: # a strictly positive integer that identifies the instance among instances of the same type. It is specified by the user during the installation. Example Example of instance ID: updater#1 identifies the updater number 1
Type	NVARCHAR(64), NULL

Primary Key Details

See the primary key information:

PK_USER_OPERATION

Column(s)	OID
Segment	CATALOG_INDX

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

IX_UOP_OPNAME

Indexed Column(s)	OPERATION_NAME
Unique	No
Partitioned	No
Clustered	No