The RATA database table contains all the range tables (business data tables) managed
by SAP CC.
The detailed content (rows) of a range table is stored in the RARO database table.
Additional information is stored in the RATA_ADDITIONAL_INFO database table.
The structure of each range table is specified in a range table class stored in the
RACA table of the database.
A range table is a master data related to a service provider and is stored in its
pricing catalog.
Consult the SAP CC Application Help for more information about this concept.
Note
SAP CC can manage high volume of range tables assigned to subscriber accounts.
These business data tables are master data related to the end customers of the service
provider.
They are stored in the SURT table of the database.
| Schema Version | 5.0.6 | |
| Partitioned | No | |
The RATA 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_RATA |
|
The unique identifier of the range table in the database | |||
| ID |
|
The identifier of the range table, corresponding to the name of the range table visible in the SAP CC Core Tool user interface | ||||
| DESCRIPTION |
|
The full description of the range table | ||||
| AGREEMENT_ID | IX_RATA_AGREEMENT_ID |
|
The agreement ID of the range table | |||
| OWNER |
|
The owner of the catalog containing the range table (the same as the owner of the range table class) | ||||
| RACA_OID | IX_RATA | RACA (OID)
|
|
The identifier of the range table class that defines the structure of this range table |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the range table in the database |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RATA |
| Definition | The identifier of the range table, corresponding to the name of the range table visible in the SAP CC Core Tool user interface |
| Description |
The identifier of the range table, corresponding to the name of the range table visible
in the SAP CC Core Tool user interface. It must be unique in the SAP CC system.
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The full description of the range table |
| Type | NVARCHAR(2000), NULL |
| Definition | The agreement ID of the range table |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_RATA_AGREEMENT_ID |
| Definition | The owner of the catalog containing the range table (the same as the owner of the range table class) |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The identifier of the range table class that defines the structure of this range table |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_RATA |
See the primary key information:
| Column(s) | OID |
| Tablespace | CATALOG_INDX |
The following database indexes are available in the RATA database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | AGREEMENT_ID |
| Unique | No |
| Partitioned | No |
| Indexed Column(s) | RACA_OID |
| Unique | No |
| Partitioned | No |
