The OBJECT_SNAPSHOT table contains copies of data objects, which are created either
before or after the execution of
a user operation that changed the object (creation, modification, or deletion).
A data object snapshot belongs to an object change log recorded as technical data.
Note
This database table is part of the audit data recordings.
Consider sizing (implementation phase) and purging (technical operations).
| Schema Version | 5.0.6 | |
| Filegroup | OBJECT_CHANGE_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The OBJECT_SNAPSHOT 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 |
|---|---|---|---|---|---|---|
| OID | IX_OBJ_SNPSH_OID |
|
The unique identifier of the data object snapshot in the back-end database. It is generated by the SAP CC system. | |||
| PARTITION_ID | IX_OBJ_SNPSH_OID |
|
The partition identifier of the object associated to the snapshot. It is set to -1 for technical objects which are unique in the SAP CC system or for the objects without partition identifier. | |||
| RECORDING_DATE | IX_OBJ_SNPSH_OID |
|
The date when the object snapshot was recorded and stored in the back-end database system | |||
| VERSION_ID |
|
The technical version number of the SAP CC Core Server system when the object change log was recorded. It is the version configured in the VERSION system parameter. | ||||
| VALUE |
|
The content of the object snapshot |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the data object snapshot in the back-end database. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_OBJ_SNPSH_OID |
| Definition | The partition identifier of the object associated to the snapshot. 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_SNPSH_OID |
| Definition | The date when the object snapshot was recorded and stored in the back-end database system |
| Type | DATETIME, NOT NULL |
| Available Index | IX_OBJ_SNPSH_OID |
| Definition | The technical version number of the SAP CC Core Server system when the object change log was recorded. It is the version configured in the VERSION system parameter. |
| Type | NVARCHAR(20), NOT NULL |
| Definition | The content of the object snapshot |
| Type | VARBINARY(MAX), NOT NULL |
The following database indexes are available in the OBJECT_SNAPSHOT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | PARTITION_ID,OID,RECORDING_DATE |
| Unique | Yes |
| Partitioned | Yes |
| Clustered | Yes |
| Filegroup | OBJECT_CHANGE_INDX |
