SURT

Subscriber Range Tables (in Customer Master Data)

Description

The SURT table contains all the subscriber range tables in the customer master data managed by SAP Convergent Charging (SAP CC). The structure of a subscriber range table is defined by a range table class (see the RACA table) belonging to the same service provider that owns the pricing catalog, the subscriber accounts, and the provider contracts. The detailed content of a subscriber range table is stored in the SURT_RARO table of the database.

Note

A subscriber range table is very similar to a range table but it is assigned to a subscriber account and can be used by the provider contracts belonging to this subscriber account.

A subscriber range table is a master data related to an end customer and it belongs to a subscriber account.

Technical Data

Schema Version	4.5.13
Segment	SUBSCRIBER_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The SURT table is defined by the following columns. See the column details for more information.

Name	PK	IX	Uses	Used by
OID	PK_SURT			SURT_ADDITIONAL_INFO (SURT_OID) SURT_RARO (SURT_OID)
SUAC_OID		IX_SURT_SUAC	SUBSCRIBER_ACCOUNT (OID)
PARTITION_ID
ID		IX_SURT_ID
RACA_OID		IX_SURT_RACA
DESCRIPTION

Column Details

OID

Definition	The unique identifier of the subscriber range table in the database
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SURT

SUAC_OID

Definition	The unique identifier of the subscriber account that the subscriber range table belongs to
Type	DECIMAL(28), NOT NULL
Available Index	IX_SURT_SUAC

PARTITION_ID

Definition	The partition of the subscriber account that the subscriber range table belongs to
Type	DECIMAL(4), NOT NULL

ID

Definition	The identifier of the subscriber range table, corresponding to the name of the subscriber range table visible in the SAP CC Core Tool user interface
Description	The identifier of the subscriber range table, corresponding to the name of the subscriber range table visible in the SAP CC Core Tool user interface. It must be unique in the SAP CC system.
Type	NVARCHAR(256), NOT NULL
Available Index	IX_SURT_ID

RACA_OID

Definition	The identifier of the range table class used as schema
Type	DECIMAL(28), NOT NULL
Available Index	IX_SURT_RACA

DESCRIPTION

Definition	The full description of the range table
Type	NVARCHAR(2000), NULL

Primary Key Details

PK_SURT

Column(s)	OID
Segment	SUBSCRIBER_INDX

Index Details

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

IX_SURT_RACA

Indexed Column(s)	RACA_OID
Unique	No
Partitioned	Yes
Clustered	No
Segment	SUBSCRIBER_INDX

IX_SURT_SUAC

Indexed Column(s)	SUAC_OID
Unique	No
Partitioned	Yes
Clustered	No
Segment	SUBSCRIBER_INDX

IX_SURT_ID

Indexed Column(s)	ID
Unique	No
Partitioned	No
Clustered	No
Segment	SUBSCRIBER_INDX