RANGE_TABLE_RANGE

Range Table Range

Definition

The RANGE_TABLE_RANGE table contains the ranges of a range set key of a version of a range table.

Technical Data

Schema Version	2023.0.2
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

The RANGE_TABLE_RANGE 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_RANGE					The unique identifier of the range table range. It is generated by the SAP CC Cockpit application.
NAME						The name of the range table range
IN_ERROR_STATE						Indicates whether the range table range is in error or not More...
ERROR_CODE						The error code for the range table range, 32 bits are used.
OUT_N_01						The value of an output column (Number type)
OUT_N_02						The value of an output column (Number type)
OUT_N_03						The value of an output column (Number type)
OUT_N_04						The value of an output column (Number type)
OUT_N_05						The value of an output column (Number type)
OUT_N_06						The value of an output column (Number type)
OUT_N_07						The value of an output column (Number type)
OUT_N_08						The value of an output column (Number type)
OUT_N_09						The value of an output column (Number type)
OUT_N_10						The value of an output column (Number type)
OUT_N_11						The value of an output column (Number type)
OUT_N_12						The value of an output column (Number type)
OUT_N_13						The value of an output column (Number type)
OUT_N_14						The value of an output column (Number type)
OUT_N_15						The value of an output column (Number type)
OUT_S_01						The value of an output column (String or currency type)
OUT_S_02						The value of an output column (String or currency type)
OUT_S_03						The value of an output column (String or currency type)
OUT_S_04						The value of an output column (String or currency type)
OUT_S_05						The value of an output column (String or currency type)
OUT_S_06						The value of an output column (String or currency type)
OUT_S_07						The value of an output column (String or currency type)
OUT_S_08						The value of an output column (String or currency type)
OUT_S_09						The value of an output column (String or currency type)
OUT_S_10						The value of an output column (String or currency type)
OUT_S_11						The value of an output column (String or currency type)
OUT_S_12						The value of an output column (String or currency type)
OUT_S_13						The value of an output column (String or currency type)
OUT_S_14						The value of an output column (String or currency type)
OUT_S_15						The value of an output column (String or currency type)
UPPER_BOUND						The upper bound of the range table range. The value -1 is used for infinite.
RANGETABLERANGESETKEY_OID						The unique identifier of the range set key that owns the range table range
RELEASED_OID			IX_RANGE_TABLE_RANGE_RELEASED_OID			The unique identifier of the released range table range when its is being modified
STATE			IX_RANGE_TABLE_RANGE_STATE			The state of the range table range More...

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 range. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RANGE_TABLE_RANGE

NAME

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

IN_ERROR_STATE

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

ERROR_CODE

Definition	The error code for the range table range, 32 bits are used.
Type	DECIMAL(28), NOT NULL

OUT_N_01

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_02

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_03

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_04

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_05

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_06

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_07

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_08

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_09

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_10

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_11

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_12

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_13

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_14

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_15

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_S_01

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_02

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_03

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_04

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_05

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_06

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_07

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_08

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_09

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_10

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_11

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_12

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_13

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_14

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

OUT_S_15

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), NULL

UPPER_BOUND

Definition	The upper bound of the range table range. The value -1 is used for infinite.
Type	DECIMAL(28,6), NULL

RANGETABLERANGESETKEY_OID

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

RELEASED_OID

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

STATE

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

Primary Key Details

See the primary key information:

PK_RANGE_TABLE_RANGE

Column(s)	OID
Filegroup	COCKPIT_DATA

Index Details

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

IX_RANGE_TABLE_RANGE_RELEASED_OID

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

IX_RANGE_TABLE_RANGE_STATE

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