USER_OPERATION

Definition


The USER_OPERATION table contains all the audited operations

Technical Data


Schema Version 4.5.13
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 SECONDDATE, NOT NULL
Available Index IX_UOP_OPDATE

Primary Key Details


PK_USER_OPERATION

Column(s) OID
Tablespace 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

IX_UOP_OPNAME

Indexed Column(s) OPERATION_NAME
Unique No
Partitioned No