USER_OPERATION

Definition

The USER_OPERATION table contains all the audited operations

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_USER_OPERATION				OBJECT_CHANGE_LOG (USER_OPERATION_OID)
OPERATION_NAME			IX_UOP_OPNAME
OPERATOR_NAME
OPERAND_REFERENCE
MESSAGE
RECORDING_DATE			IX_UOP_OPDATE

Column Details

OID

Definition	The identifier of the audited operation
Type	DECIMAL(28), NOT NULL
Primary Key	PK_USER_OPERATION

OPERATION_NAME

Definition	The name of the audited operation
Type	NVARCHAR(256), NOT NULL
Available Index	IX_UOP_OPNAME

OPERATOR_NAME

Definition	The SAP CC user who performed the audited operation
Type	NVARCHAR(256), NULL

OPERAND_REFERENCE

Definition	The operand of the audited operation
Type	NVARCHAR(256), NULL

MESSAGE

Definition	The message describing the result of the audited operation
Type	NVARCHAR(2000), NULL

RECORDING_DATE

Definition	The date when the operation was performed
Type	DATETIME, NOT NULL
Available Index	IX_UOP_OPDATE

Primary Key Details

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