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
Tablespace	CATALOG_DATA
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	VARCHAR(256), NULL

OPERATOR_NAME

Definition	The SAP CC user whose operations are audited
Type	VARCHAR(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	VARCHAR(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
Tablespace	CATALOG_INDX