Table: CCON_PARAMETER

Table Name CCON_PARAMETER
Table Description The CCON_PARAMETER table contains information about parameters in charge conditions. These parameters are first created in the price plan of the charge component corresponding to the charge condition. Then they are redefined in the charge condition.
Tablespace CATALOG_DATA
Database Core Database
Columns
INDEX_IN_CCON
NAME
DESCRIPTION
PARAMETER_NAME
VALUE_TYPE
NUMBER_VALUE
STRING_VALUE
DATE_VALUE
CCON_OID
VALIDATION_DATE

Columns of the Table

The CCON_PARAMETER database table is defined by the following columns.

Column: INDEX_IN_CCON

Value Type DECIMAL(5), NOT NULL
Column Description The index of the parameter in the charge condition.


Column: NAME

Value Type VARCHAR(256)
Column Description The name of the parameter.


Column: DESCRIPTION

Value Type VARCHAR(2000)
Column Description The description of the parameter.


Column: PARAMETER_NAME

Value Type VARCHAR(256)
Column Description The parameter in the charge condition can be linked to a parameter with the same type defined in the offer. The PARAMETER_NAME field gives the name of the parameter defined in the offer.


Column: VALUE_TYPE

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


Column: NUMBER_VALUE

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


Column: STRING_VALUE

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


Column: DATE_VALUE

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


Column: CCON_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

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

Index(es) IX_CCPA_CCON
Column Description The identifier of the charge condition owning the parameter.


Column: VALIDATION_DATE

Value Type DATE
Column Description The date when the parameter becomes valid.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

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