SUMT

Subscriber Mapping Tables (Customer Master Data)

Description

mapping table subscriber account contracts

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	4.5.13
Segment	SUBSCRIBER_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

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

Name	PK	IX	Used by
OID	PK_SUMT		SUMT_ADDITIONAL_INFO (SUMT_OID) SUMT_MARO (SUMT_OID)
SUAC_OID		IX_SUMT_SUAC
PARTITION_ID
ID		IX_SUMT_ID
MACA_OID		IX_SUMT_MACA

Column Details

OID

Definition	The unique identifier of the subscriber mapping table in the databas
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SUMT

SUAC_OID

Definition	The unique identifier of the subscriber account holding the subscriber mapping table
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUMT_SUAC

PARTITION_ID

Definition	The partition of the Subscriber Account the Subscriber Mapping Table belongs to
Type	DECIMAL(4), NOT NULL

ID

Definition	The identifier of the Subscriber Mapping Table, corresponding to the name of the Subscriber Mapping Table visible the SAP CC Core Tool user interface
Type	NVARCHAR(256), NOT NULL
Available Index	IX_SUMT_ID

MACA_OID

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

Primary Key Details

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
Segment	SUBSCRIBER_INDX

IX_SUMT_SUAC

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

IX_SUMT_ID

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