SPENDING_STATUS_MONITORING

Definition

The SPENDING_STATUS_MONITORING table contains all the necessary information to monitor the spending status of a charging contract. A spending status monitoring is identified by its spending status monitoring identifier and or its internal unique identifier.

Technical Data

Schema Version	2025.0.0
Tablespace	SESSION_RATING_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The SPENDING_STATUS_MONITORING 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	PK_SPENDSTATMON					The internal unique identifier of the spending status monitoring. It is generated by the SAP CC system.
CLIENT_NUMBER						The client number associated to the spending status monitoring
MONITORING_ID			IX_SSM_MONITORING_ID			The external identifier given by the client application
MONITORING_DATE						The starting date and time of the spending status monitoring
SSRL_ID						The identifier of the spending status report listener in charge of processing the spending statuses
CACO_OID			IX_SSM_CACO_OID			The identifier of the charging contract
EXPIRATION_DATE			IX_SSM_EXPIRATION_DATE			The date and time after which the spending status monitoring is not relevant anymore
SPENDING_STATUS_IDS						The list of the spending status IDs of the charging contract to monitor.
PARTITION_ID	PK_SPENDSTATMON					The database partition identifier of the subscriber account of the charging contract

Column Details

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

OID

Definition	The internal unique identifier of the spending status monitoring. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SPENDSTATMON

CLIENT_NUMBER

Definition	The client number associated to the spending status monitoring
Type	DECIMAL(3), NOT NULL

MONITORING_ID

Definition	The external identifier given by the client application
Type	VARCHAR(256), NOT NULL
Available Index	IX_SSM_MONITORING_ID

MONITORING_DATE

Definition	The starting date and time of the spending status monitoring
Type	TIMESTAMP, NOT NULL

SSRL_ID

Definition	The identifier of the spending status report listener in charge of processing the spending statuses
Type	DECIMAL(4), NOT NULL

CACO_OID

Definition	The identifier of the charging contract
Type	DECIMAL(28), NOT NULL
Available Index	IX_SSM_CACO_OID

EXPIRATION_DATE

Definition	The date and time after which the spending status monitoring is not relevant anymore
Type	TIMESTAMP, NOT NULL
Available Index	IX_SSM_EXPIRATION_DATE

SPENDING_STATUS_IDS

Definition	The list of the spending status IDs of the charging contract to monitor.
Type	BLOB, NULL

PARTITION_ID

Definition	The database partition identifier of the subscriber account of the charging contract
Type	DECIMAL(4), NOT NULL
Primary Key	PK_SPENDSTATMON

Primary Key Details

See the primary key information:

PK_SPENDSTATMON

Column(s)	PARTITION_ID,OID
Tablespace	SESSION_RATING_INDX

Index Details

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

IX_SSM_CACO_OID

Indexed Column(s)	CACO_OID
Unique	Yes
Partitioned	Yes
Tablespace	SESSION_RATING_INDX

IX_SSM_MONITORING_ID

Indexed Column(s)	MONITORING_ID
Unique	Yes
Partitioned	No
Tablespace	SESSION_RATING_INDX

IX_SSM_EXPIRATION_DATE

Indexed Column(s)	EXPIRATION_DATE
Unique	Yes
Partitioned	No
Tablespace	SESSION_RATING_INDX