TIER_TABLE_OUT_ATTRIBUTE

Definition


The TIER_TABLE_OUT_ATTRIBUTE table contains the descriptions of the output attributes of the tier tables

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
TTAB_OID     IX_TIERTOA_TTAB_OID  TIER_TABLE (OID)
 
 
NAME          
DESCRIPTION          
INDEX_IN_TTAB          
VALUE_TYPE          
CALC_MODE          

Column Details


TTAB_OID

Definition The tier table unique ID. See the OID field of the TIER_TABLE database table.
Type DECIMAL(28), NOT NULL
Available Index IX_TIERTOA_TTAB_OID

NAME

Definition The name of the attribute
Type VARCHAR(256), NOT NULL

DESCRIPTION

Definition The description of the attribute
Type VARCHAR(2000), NULL

INDEX_IN_TTAB

Definition The index of the output attribute in the tier table
Type DECIMAL(3), NOT NULL

VALUE_TYPE

Definition The type of the attribute
Format

The possible values are:

  • 0: number
  • 1: string

Type DECIMAL(1), NOT NULL

CALC_MODE

Definition The calculation mode if the type of the attribute is number. See the VALUE_TYPE field.
Format

The possible values are:

  • -1: unset. Only if the type of the attribute is not number.
  • 0: single non linear
  • 1: single linear
  • 2: cumulative non linear
  • 3: cumulative linear

Type DECIMAL(1), NULL

Index Details


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

IX_TIERTOA_TTAB_OID

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