OBJECT_CHANGE_LOG

Object Change Logs (in Technical Data)

Definition

The OBJECT_CHANGE_LOG table contains the recordings of changes performed on data objects, including references to detailed information (related audited user operation and recorded object snapshots)

Description

The OBJECT_CHANGE_LOG table contains the recordings of changes performed on persistent data objects. Depending on the system configuration settings, the SAP CC system audits the data object changes automatically and stores an object change log entry into this database table.

Depending on the SAP CC system configuration, each object change log may include references to the related audited user operation (SAP user, operation detailed information) and recorded object snapshots (object copies before and after changes).

Note

This database table is part of the audit data recordings. Consider sizing (implementation phase) and purging (technical operations).

Technical Data

Schema Version	2022.0.2
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The OBJECT_CHANGE_LOG table is defined by the following columns in your back-end database. See the column details for more information.

Name	IX	Uses	Definition
OID	IX_OBJ_CHGLG_OID		The unique identifier of the object change log in the back-end database. It is generated by the SAP CC system.
RECORDING_DATE	IX_OBJ_CHGLG_OID		The date when the object change log was recorded and stored
OBJECT_ID_PART_1	IX_OBJ_CHGLG_OPDATE		The first part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
OBJECT_ID_PART_2			The second part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
OBJECT_ID_PART_3			The third part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
OBJECT_OID			The unique identifier of the object for this change log. It is NULL for technical data which is unique in the SAP CC Core Server system.
PARTITION_ID	IX_OBJ_CHGLG_OID		The partition identifier of the object associated to the change log. It is set to -1 for technical objects which are unique in the SAP CC system or for the objects without partition identifier.
OBJECT_TYPE			The type of the data object for this change log More...
USER_OPERATION_OID	IX_OBJ_CHGLG_OPOID	USER_OPERATION (OID)	The unique identifier of the related audited user operation. It is empty when the User Operation Auditing feature is disabled in the SAP CC system.
ACTION_TYPE			The type of performed action. The SAP system executed this treatment when processing the user operation request. More...
BEFORE_SNAPSHOT_OID		OBJECT_SNAPSHOT (OID)	The unique identifier of the object snapshot before the change. It is NULL if the action was a creation.
AFTER_SNAPSHOT_OID		OBJECT_SNAPSHOT (OID)	The unique identifier of the object snapshot after the change. It is NULL if the action was a deletion.
CHANGE_MESSAGE			The message which explains the change.

Column Details

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

OID

Definition	The unique identifier of the object change log in the back-end database. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Available Index	IX_OBJ_CHGLG_OID

RECORDING_DATE

Definition	The date when the object change log was recorded and stored
Type	DATETIME, NOT NULL
Available Index	IX_OBJ_CHGLG_OID

OBJECT_ID_PART_1

Definition	The first part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
Type	NVARCHAR(256), NULL
Available Index	IX_OBJ_CHGLG_OPDATE

OBJECT_ID_PART_2

Definition	The second part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
Type	NVARCHAR(256), NULL

OBJECT_ID_PART_3

Definition	The third part of the object identifier of the object change log. It is NULL for the object types that do not use this part.
Type	NVARCHAR(256), NULL

OBJECT_OID

Definition	The unique identifier of the object for this change log. It is NULL for technical data which is unique in the SAP CC Core Server system.
Type	DECIMAL(28), NULL

PARTITION_ID

Definition	The partition identifier of the object associated to the change log. It is set to -1 for technical objects which are unique in the SAP CC system or for the objects without partition identifier.
Type	DECIMAL(4), NOT NULL
Available Index	IX_OBJ_CHGLG_OID

OBJECT_TYPE

Definition The type of the data object for this change log

Format

The possible values are:

0: Pricing Macro
1: Translation Table
2: Tier Table
3: Mapping Table Class
4: Mapping Table
5: Range Table Class
6: Range Table
7: Chargeable Item Package (aka Product)
8: Offer
9: Chargeable Item Class
10: Charged Item Class
11: Charge Component (known as Reusable Charge)
12: Charge Plan
13: Refill Item Class
14: Refill Record Class
15: Refill Logic
16: Refill Plan
17: Charged Item Mapping
18: Refill Record Mapping
19: Chargeable Item Mapping
20: SAP CC User
21: Audit (Custom Filter and Cycle)
22: Currencies
23: ISO4217 Currencies
24: Public Holidays
25: Counter Names Dictionary
26: Access
27: Subscriber Account
28: Charging Contract (charging view of a Provider Contract)
29: Subscription
30: Subscriber Mapping Table
31: Subscriber Range Table
32: Charged Items Aggregation Policy
33: Allowance Plan
34: Allowance Logic
35: Allowance Interface
36: Allowance Event Class
37: Spending Status Description
38: Monitoring Plan

Type DECIMAL(3), NOT NULL

USER_OPERATION_OID

Definition	The unique identifier of the related audited user operation. It is empty when the User Operation Auditing feature is disabled in the SAP CC system.
Type	DECIMAL(28), NULL
Available Index	IX_OBJ_CHGLG_OPOID

ACTION_TYPE

Definition The type of performed action. The SAP system executed this treatment when processing the user operation request.

Format

The possible values are:

0: Creation
1: Modification
2: Deletion

Type DECIMAL(1), NOT NULL

BEFORE_SNAPSHOT_OID

Definition	The unique identifier of the object snapshot before the change. It is NULL if the action was a creation.
Type	DECIMAL(28), NULL

AFTER_SNAPSHOT_OID

Definition	The unique identifier of the object snapshot after the change. It is NULL if the action was a deletion.
Type	DECIMAL(28), NULL

CHANGE_MESSAGE

Definition	The message which explains the change.
Type	NVARCHAR(256), NULL

Index Details

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

IX_OBJ_CHGLG_OID

Indexed Column(s)	RECORDING_DATE,PARTITION_ID,OID
Unique	Yes
Partitioned	Yes
Clustered	Yes

IX_OBJ_CHGLG_OPOID

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

IX_OBJ_CHGLG_OPDATE

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