RANGE_TABLE_VERSION

Range Table Version

Definition

The RANGE_TABLE_VERSION table contains the versions of a range table.

Description

They are composed of range table range set keys. See the RANGE_TABLE_RANGE_SET_KEY table.

Technical Data

Schema Version	2023.0.2
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

The RANGE_TABLE_VERSION 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_RANGE_TABLE_VERSION					The unique identifier of the range table version. It is generated by the SAP CC Cockpit application.
NAME						The name of the range table version
IN_ERROR_STATE						Indicates whether the range table version is in error or not More...
CHILD_IN_ERROR						The number of range set keys in error in the range tables version
RELEASED_OID			IX_RANGE_TABLE_VERSION_RELEASED_OID			The unique identifier of the released range table version when its is being modified
START_DATE						The start date of the validity period of the range table version
STATE			IX_RANGE_TABLE_VERSION_STATE			The state of the range table version More...
END_DATE						The end date of the validity period of the range table version
RANGETABLE_OID						The unique identifier of the range table that owns the range table version

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The unique identifier of the range table version. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RANGE_TABLE_VERSION

NAME

Definition	The name of the range table version
Type	NVARCHAR(256), NULL

IN_ERROR_STATE

Definition	Indicates whether the range table version is in error or not
Format	The possible values are: 0: No errors 1: One or more errors
Type	BIT, NULL

CHILD_IN_ERROR

Definition	The number of range set keys in error in the range tables version
Type	DECIMAL(10), NOT NULL

RELEASED_OID

Definition	The unique identifier of the released range table version when its is being modified
Type	DECIMAL(28), NULL
Available Index	IX_RANGE_TABLE_VERSION_RELEASED_OID

START_DATE

Definition	The start date of the validity period of the range table version
Type	DATETIME, NULL

STATE

Definition	The state of the range table version
Format	The possible values are: 0: CREATED 1: MODIFIED 2: RELEASED
Type	DECIMAL(3), NULL
Available Index	IX_RANGE_TABLE_VERSION_STATE

END_DATE

Definition	The end date of the validity period of the range table version
Type	DATETIME, NULL

RANGETABLE_OID

Definition	The unique identifier of the range table that owns the range table version
Type	DECIMAL(28), NOT NULL

Primary Key Details

See the primary key information:

PK_RANGE_TABLE_VERSION

Column(s)	OID
Filegroup	COCKPIT_DATA

Index Details

The following database indexes are available in the RANGE_TABLE_VERSION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_RANGE_TABLE_VERSION_RELEASED_OID

Indexed Column(s)	RELEASED_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX

IX_RANGE_TABLE_VERSION_STATE

Indexed Column(s)	STATE
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX