SUMT

Subscriber Mapping Tables (Customer Master Data)

Definition

The SUMT table contains the subscriber mapping tables stored by the SAP CC system

Description

The SUMT database table contains all the subscriber mapping tables stored by the SAP CC system in the customer master data. A subscriber mapping table is very similar to a mapping table but it is assigned to a subscriber account and can be used by the contracts belonging to this subscriber account.

The structure of a subscriber mapping table is defined by a mapping table class (see the MACA table). The content of a subscriber mapping table is stored in the SUMT_MARO table of the database.

Technical Data

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

Summary

The SUMT 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_SUMT				SUMT_ADDITIONAL_INFO (SUMT_OID) SUMT_MARO (SUMT_OID)	The unique identifier of the subscriber mapping table in the SAP CC system and its database
SUAC_OID			IX_SUMT_SUAC	SUBSCRIBER_ACCOUNT (OID)		The unique identifier of the subscriber account holding a subscriber mapping table that is configured in this database table
PARTITION_ID				SUBSCRIBER_ACCOUNT (PARTITION_ID)		The data partition of the subscriber account this subscriber mapping table belongs to
ID			IX_SUMT_ID			The identifier or name of the subscriber mapping table. It corresponds to the name of the subscriber mapping table visible in the SAP CC Core Tool user interface.
MACA_OID			IX_SUMT_MACA	MACA (OID)		The identifier (OID) of the mapping table class used as schema and that defines the structure of this subscriber mapping table
DESCRIPTION						The full description of the range table

Column Details

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

OID

Definition	The unique identifier of the subscriber mapping table in the SAP CC system and its database
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SUMT

SUAC_OID

Definition	The unique identifier of the subscriber account holding a subscriber mapping table that is configured in this database table
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUMT_SUAC

PARTITION_ID

Definition	The data partition of the subscriber account this subscriber mapping table belongs to
Type	DECIMAL(4), NOT NULL

ID

Definition	The identifier or name of the subscriber mapping table. It corresponds to the name of the subscriber mapping table visible in the SAP CC Core Tool user interface.
Type	NVARCHAR(256), NOT NULL
Available Index	IX_SUMT_ID

MACA_OID

Definition	The identifier (OID) of the mapping table class used as schema and that defines the structure of this subscriber mapping table
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUMT_MACA

DESCRIPTION

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

Primary Key Details

See the primary key information:

PK_SUMT

Column(s)	OID
Segment	SUBSCRIBER_INDX

Index Details

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

IX_SUMT_MACA

Indexed Column(s)	MACA_OID
Unique	No
Partitioned	Yes
Clustered	No

IX_SUMT_SUAC

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

IX_SUMT_ID

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