TIER_TABLE

Definition

The TIER_TABLE database table contains information about tier tables

Technical Data

Schema Version	4.5.13
Tablespace	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	IX	Used by
OID	PK_TIERT		TIER_TABLE_OUT_ATTRIBUTE (TTAB_OID) TIER_TABLE_INSTANCE (TTAB_OID)
CODE		IX_TIERT_CODE
DESCRIPTION
OWNER		IX_TIERT_OWNER

Column Details

OID

Definition	The tier table unique identifier. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_TIERT

CODE

Definition	The code of the tier table
Type	VARCHAR2(256 CHAR), NOT NULL
Available Index	IX_TIERT_CODE

DESCRIPTION

Definition	The description of the tier table
Type	VARCHAR2(2000 CHAR), NULL

OWNER

Definition	The owner of the tier table
Type	VARCHAR2(64 CHAR), NOT NULL
Available Index	IX_TIERT_OWNER

Primary Key Details

PK_TIERT

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

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

IX_TIERT_OWNER

Indexed Column(s)	OWNER
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX

IX_TIERT_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Tablespace	CATALOG_INDX