USER_OPERATION_FILTER

Definition

The USER_OPERATION_FILTER contains the filters used to audit user operations requested by SAP CC users (individual or service) to the SAP CC system

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The USER_OPERATION_FILTER 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
OPERATION_NAME						The name of the operation to be audited
OPERATOR_NAME						The SAP CC user whose operations are audited
OPERAND_TYPE						The type of operation to be audited More...
OPERAND_REFERENCE						The operand of the operation (identifier, name, code, reference)
AUDI_OID			IX_OP_FILTER_AUDIT	AUDIT_CYCLE (OID)		The identifier of the audit containing the filter

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OPERATION_NAME

Definition	The name of the operation to be audited
Type	NVARCHAR(256), NULL

OPERATOR_NAME

Definition	The SAP CC user whose operations are audited
Type	NVARCHAR(256), NULL

OPERAND_TYPE

Definition	The type of operation to be audited
Format	The possible values are: 0: Normal operations 1: Operations with error 2: Both
Type	DECIMAL(1), NULL

OPERAND_REFERENCE

Definition	The operand of the operation (identifier, name, code, reference)
Type	NVARCHAR(256), NULL

AUDI_OID

Definition	The identifier of the audit containing the filter
Type	DECIMAL(28), NULL
Available Index	IX_OP_FILTER_AUDIT

Index Details

The following database indexes are available in the USER_OPERATION_FILTER database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_OP_FILTER_AUDIT

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