SUMT
Definition
The SUMT table contains the subscriber mapping tables stored by the SAP CC system
Description
The SUMT table contains 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 | 4.6.2 | |
| Filegroup | SUBSCRIBER_DATA | |
| 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 |
|
The unique identifier of the subscriber mapping table in the databas | |||
| SUAC_OID | IX_SUMT_SUAC |
|
The unique identifier of the subscriber account holding the subscriber mapping table | |||
| PARTITION_ID |
|
The partition of the Subscriber Account the Subscriber Mapping Table belongs to | ||||
| ID | IX_SUMT_ID |
|
The identifier of the Subscriber Mapping Table, corresponding to the name of the Subscriber Mapping Table visible the SAP CC Core Tool user interface | |||
| MACA_OID | IX_SUMT_MACA |
|
The identifier of the mapping table class used as schema |
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 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
See the primary key information:
PK_SUMT
| Column(s) | PARTITION_ID,OID |
| Filegroup | SUBSCRIBER_DATA |
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 |
| Filegroup | SUBSCRIBER_INDX |
IX_SUMT_SUAC
| Indexed Column(s) | SUAC_OID |
| Unique | No |
| Partitioned | Yes |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |
IX_SUMT_ID
| Indexed Column(s) | ID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |