Table: CCPP_ADDITIONAL_INFO

Table Name CCPP_ADDITIONAL_INFO
Table Description The CCPP_ADDITIONAL_INFO table contains the additional information for rating context properties in the price plan.
Tablespace CATALOG_DATA
Database Core Database
Columns
PLAN_OID
INDEX_IN_PLAN
NAME
VALUE_TYPE
NUMBER_VALUE
STRING_VALUE
DATE_VALUE

Columns of the Table

The CCPP_ADDITIONAL_INFO database table is defined by the following columns.

Column: PLAN_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: PRICE_PLAN
  • Foreign field(s): OID

Column Description The identifier of the price plan.


Column: INDEX_IN_PLAN

Value Type DECIMAL, NOT NULL
Column Description The index of the properties in the pricing macro.


Column: NAME

Value Type VARCHAR(256), NOT NULL
Column Description The name of the additional information.


Column: VALUE_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of the additional information. Possible values are:
  • 0: number
  • 1: string
  • 2: date


Column: NUMBER_VALUE

Value Type DECIMAL(28,6)
Column Description The value of the additional information when it is a number.


Column: STRING_VALUE

Value Type VARCHAR(2000)
Column Description The value of the additional information when it is a string.


Column: DATE_VALUE

Value Type DATE
Column Description The value of the additional information when it is a date.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.