TRANSLATION_TABLE
Description
The TRANSLATION_TABLE database table contains the basic definitions of the
translation tables stored in the pricing catalog of
a service provider.
Different instances exist in the database.
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
CATALOG_DATA |
| Partitioned |
No |
Summary
The TRANSLATION_TABLE table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique identifier of a translation table.
It is generated by the SAP CC system.
|
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_TRANSLATION_TABLE |
CODE
| Definition |
The code name of the translation table |
| Type |
VARCHAR2(256 CHAR), NOT NULL |
| Available Index |
IX_TT_CODE |
DESCRIPTION
| Definition |
The text description of the translation table |
| Type |
VARCHAR2(2000 CHAR), NULL |
OWNER
| Definition |
The owner of the translation table |
| Type |
VARCHAR2(64 CHAR), NOT NULL |
| Available Index |
IX_TT_OWNER |
USE_DATES
| Definition |
The USE_DATES field indicates if the translation table uses dates or not |
| Format |
The possible values are:
1: The translation table uses dates
0: Otherwise
|
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
DISABLE_DUPLICATE
| Definition |
The DISABLE_DUPLICATE field indicates if rows with duplicate values for all input
attributes are authorized in the translation table
|
| Format |
The possible values are:
1: Duplicate values authorized
0: Otherwise
|
| Type |
DECIMAL(1), NOT NULL |
| Default |
1 |
Primary Key Details
PK_TRANSLATION_TABLE
Index Details
The following database indexes are available in the
TRANSLATION_TABLE database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_TT_OWNER
| Indexed Column(s) |
OWNER |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
CATALOG_INDX |
IX_TT_CODE
| Indexed Column(s) |
CODE |
| Unique |
Yes |
| Partitioned |
No |
| Tablespace |
CATALOG_INDX |
