RARO

Definition

The RARO table contains the rows of the range tables managed by SAP Convergent Charging

Description

The RARO table contains the rows of the range tables managed by SAP Convergent Charging. The definitions of the range tables are stored in the RATA database table.

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The RARO 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
UPPER_BOUND						The upper bound of the range table row. It must be unique in the range table containing the row
IS_UNBOUNDED						For unbounded value
START_DATE						The start date for the range table row
END_DATE						The end date of the range table row
IN_S_01						The value of an input column (string type)
IN_S_02						The value of an input column (string type)
IN_S_03						The value of an input column (string type)
IN_S_04						The value of an input column (string type)
IN_S_05						The value of an input column (string 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)
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
RATA_OID			IX_RARO	RATA (OID)		The identifier of the range table containing the row

Column Details

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

UPPER_BOUND

Definition	The upper bound of the range table row. It must be unique in the range table containing the row
Type	DECIMAL(28,6), NULL

IS_UNBOUNDED

Definition	For unbounded value
Type	DECIMAL(1), NULL

START_DATE

Definition	The start date for the range table row
Type	DATETIME, NULL

END_DATE

Definition	The end date of the range table row
Type	DATETIME, NULL

IN_S_01

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_02

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_03

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_04

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_05

Definition	The value of an input column (string type)
Type	NVARCHAR(256), 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

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

RATA_OID

Definition	The identifier of the range table containing the row
Type	DECIMAL(28), NOT NULL
Available Index	IX_RARO

Index Details

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

IX_RARO

Indexed Column(s)	RATA_OID
Unique	No
Partitioned	No
Clustered	No