COUNTER_SNAPSHOT
Description
The COUNTER_SNAPSHOT table contains counter values of subscriptions or charging contracts. The SAP CC system records the counter values in a snapshot during the charging and refilling operations.
Note
A subscription that is not set 'batch only' does not have any entry in this database table.
Technical Data
| Schema Version | 4.5.13 | |
| Tablespace | C_SNAPSHOT_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
Summary
The COUNTER_SNAPSHOT table is defined by the following columns. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| SNAPSHOT_SUB_OID | PK_COUNTER_SNAPSHOT | SUBSCRIPTION (OID)
CACO (OID) |
|||
| SNAPSHOT_ID | PK_COUNTER_SNAPSHOT | ||||
| SNAPSHOT_VALUE | |||||
| PARTITION_ID | PK_COUNTER_SNAPSHOT |
Column Details
SNAPSHOT_SUB_OID
| Definition | The ID of the subscription or charging contract which the counters belong to |
| Description |
The identifier of the subscription or charging contract that includes the counters recorded in the snapshot. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
SNAPSHOT_ID
| Definition | The ID of the snapshot |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
SNAPSHOT_VALUE
| Definition | The compound value of all the counters in the subscription or charging contract |
| Type | RAW(1000), NULL |
PARTITION_ID
| Definition | The partition ID of the subscriber account holding the subscription or charging contract |
| Description |
The identifier of the database partition of the subscriber account that holds the subscription or charging contract. |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
Primary Key Details
PK_COUNTER_SNAPSHOT
| Column(s) | PARTITION_ID,SNAPSHOT_SUB_OID,SNAPSHOT_ID |
| Tablespace | C_SNAPSHOT_INDX |