Table: SUMT

Table Name SUMT
Table Description The SUMT table contains the subscriber mapping tables. A subscriber mapping table is very similar to a mapping table but it is attached to a subscriber account and can be used by the contracts belonging to this subscriber account. It is an instance of a mapping table class and it contains rows.
Tablespace SUBSCRIBER_DATA
Database Core Database
Partitioned Yes
Columns
OID
SUAC_OID
PARTITION_ID
ID
MACA_OID

Columns of the Table

The SUMT database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_SUMT

Foreign K.:

  • Foreign table: MACA
  • Foreign field(s): OID

Index(es) IX_SUMT_MACA
IX_SUMT_SUAC
Column Description The unique identifier of the subscriber mapping table in the database.


Column: SUAC_OID

Value Type BIGINT, NOT NULL
Index(es) IX_SUMT_SUAC
Column Description The unique identifier of the subscriber account the subscriber mapping table belongs to.


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Column Description The partition of the subscriber account the subscriber mapping table belongs to.


Column: ID

Value Type VARCHAR(256), NOT NULL
Key(s) Primary Key: PK_SUMT

Foreign K.:

  • Foreign table: MACA
  • Foreign field(s): OID

Index(es) IX_SUMT_MACA
IX_SUMT_SUAC
Column Description The identifier of the subscriber mapping table, corresponding to the name of the subscriber mapping table in the Core Tool.


Column: MACA_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: MACA
  • Foreign field(s): OID

Index(es) IX_SUMT_MACA
Column Description The identifier of the mapping table class used as schema.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.