RACA
Description
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 OUT_RACA_COLUMN table. 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:- RACA: RAnge table ClAsses
- RATA: RAnge TAbles
- RARO: Range table Rows
- SURT: SUbscriber Range Tables
- SURT_RARO: SUbscriber Range Table Rows
Technical Data
| Schema Version | 4.5.13 | |
| Segment | CATALOG_DATA | |
| Partitioned | No | |
Summary
The RACA table is defined by the following columns. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| OID | PK_RACA | RATA (RACA_OID)
OUT_RACA_COLUMN (RACA_OID) RACA_ADDITIONAL_INFO (RACA_OID) |
|||
| ID | |||||
| DESCRIPTION | |||||
| OWNER | |||||
| RANGE_UPPER_BOUND | |||||
| LAST_RANGE |
Column Details
OID
| Definition | The unique identifier of the range table class in the database |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RACA |
ID
| 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 |
DESCRIPTION
| Definition | The description of the range table class |
| Type | NVARCHAR(2000), NULL |
OWNER
| Definition | The owner of the catalog containing the range table class |
| Type | NVARCHAR(256), NOT NULL |
RANGE_UPPER_BOUND
| 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 |
LAST_RANGE
| 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 |
Primary Key Details
PK_RACA
| Column(s) | OID |
| Segment | CATALOG_INDX |