MATA
Definition
The MATA table contains all the mapping tables (master data related to end customers) stored by the SAP CC system
Description
The MATA table contains all the mapping tables (master data related to end customers)
stored by the SAP CC system.
The content of a mapping table is stored in the MARO table.
The structure of each mapping table is specified in a mapping table class (see the
MACA table).
Technical Data
| Schema Version | 4.6.2 | |
| Segment | CATALOG_DATA | |
| Partitioned | No | |
Summary
The MATA 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_MATA |
|
The unique identifier of the mapping table in the database | |||
| ID |
|
The identifier of the mapping table, corresponding to the name of the mapping table visible in the SAP CC Core Tool user interface. It must be unique in the SAP CC system | ||||
| OWNER |
|
The owner of the catalog containing the Mapping Table (the same as the owner of the Mapping Table Class) | ||||
| MACA_OID | IX_MATA | MACA (OID)
|
|
The identifier of the Mapping Table Class used as schema | ||
| VERSION_ID |
|
Determined at mapping table level, this identifier is incremented each time a modification is performed on the mapping table. | ||||
| DELETED_ROW_COUNT |
|
The total number of rows of the mapping table that have been deleted. |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| Definition | The unique identifier of the mapping table in the database |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_MATA |
ID
| Definition | The identifier of the mapping table, corresponding to the name of the mapping table visible in the SAP CC Core Tool user interface. It must be unique in the SAP CC system |
| Type | NVARCHAR(256), NOT NULL |
OWNER
| Definition | The owner of the catalog containing the Mapping Table (the same as the owner of the Mapping Table Class) |
| Type | NVARCHAR(256), NOT NULL |
MACA_OID
| Definition | The identifier of the Mapping Table Class used as schema |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_MATA |
VERSION_ID
| Definition | Determined at mapping table level, this identifier is incremented each time a modification is performed on the mapping table. |
| Type | DECIMAL(28), NOT NULL |
DELETED_ROW_COUNT
| Definition | The total number of rows of the mapping table that have been deleted. |
| Type | DECIMAL(28), NOT NULL |
Primary Key Details
See the primary key information:
PK_MATA
| Column(s) | OID |
| Segment | CATALOG_INDX |
Index Details
The following database indexes are available in the MATA database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_MATA
| Indexed Column(s) | MACA_OID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Segment | CATALOG_INDX |