RATA

Range Tables (Master Data)

Description

A range table is a master data related to a service provider and is stored in its pricing catalog. Consult the SAP CC Library (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.

Technical Data

Schema Version	4.5.13
Segment	CATALOG_DATA
Partitioned	No

Summary

The RATA table is defined by the following columns. See the column details for more information.

Name	PK	IX	Uses	Used by
OID	PK_RATA			RATA_ADDITIONAL_INFO (RATA_OID) RARO (RATA_OID)
ID
DESCRIPTION
OWNER
RACA_OID		IX_RATA	RACA (OID)

Column Details

OID

Definition	The unique identifier of the range table in the database
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RATA

ID

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

DESCRIPTION

Definition	The full description of the range table
Type	NVARCHAR(2000), NULL

OWNER

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

RACA_OID

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

Primary Key Details

PK_RATA

Column(s)	OID
Segment	CATALOG_INDX

Index Details

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:

IX_RATA

Indexed Column(s)	RACA_OID
Unique	No
Partitioned	No
Clustered	No
Segment	CATALOG_INDX