The RACA database table contains the main definitions of all the range table classes
managed by SAP Convergent Charging (SAP CC).
The definitions are completed with data stored in the IN_RACA_COLUMN and OUT_RACA_COLUMN tables.
Additional information is stored in the RACA_ADDITIONAL_INFO table.
A range table class defines the structure of range tables (RATA) and subscriber range tables (SURT).
A range table class is a master data related to a service provider and is stored in
its pricing catalog.
Note
You can remind the following database tables:
| Schema Version | 2025.0.1 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
The RACA 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_RACA |
|
The unique identifier of the range table class in the database | |||
| CLIENT_NUMBER |
|
The client number associated to the range table class | ||||
| ID |
|
The identifier of the range table class | ||||
| DESCRIPTION |
|
The description of the range table class | ||||
| OWNER |
|
The owner of the catalog containing the range table class | ||||
| FIRST_RANGE_LOWER_BOUND |
|
The flag to define if the first range in a range table (based on this class) is inclusive or exclusive | ||||
| RANGE_UPPER_BOUND |
|
The flag to define if each upper bound in a range table (based on this class) is inclusive or exclusive | ||||
| LAST_RANGE |
|
The flag to define if last range of each range table (based on this class) is bounded or unbounded |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the range table class in the database |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RACA |
| Definition | The client number associated to the range table class |
| Type | DECIMAL(3), NOT NULL |
| Definition | The identifier of the range table class |
| Description |
The identifier of the range table class, corresponding to the name of the range table
class 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 description of the range table class |
| Type | NVARCHAR(2000), NULL |
| Definition | The owner of the catalog containing the range table class |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The flag to define if the first range in a range table (based on this class) is inclusive or exclusive |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The flag to define if each upper bound in a range table (based on this class) is inclusive or exclusive |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The flag to define if last range of each range table (based on this class) is bounded or unbounded |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
See the primary key information:
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
