A-Z Index of MS SQL Server Tables

The following tables exist in the database:

name description

ALLOWANCE_EVENT_CLASS The ALLOWANCE_EVENT_CLASS table contains the description of each allowance event class

ALLOWANCE_EVENT_CLASS_FIELD The ALLOWANCE_EVENT_CLASS_FIELD table describes the properties of an allowance event class

ALLOWANCE_PLAN The ALLOWANCE_PLAN table contains the basic definition of the allowance plans stored in the pricing catalog of a service provider

ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION The ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION table contains the charged item definition of the allowance plan

ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD The ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD table contains the properties of the charged item definition of the allowance plan

ALLOWANCE_PLAN_COMPUTED_PROPERTY The ALLOWANCE_PLAN_COMPUTED_PROPERTY table contains the computed properties generated by an allowance plan

ALLOWANCE_PLAN_COUNTER The ALLOWANCE_PLAN_COUNTER table contains the counters owned by an allowance plan

ALLOWANCE_PLAN_PARAMETER The ALLOWANCE_PLAN_PARAMETER table contains the parameters owned by an allowance plan

BILLABLE_ITEM_MAPPING_FIELD The BILLABLE_ITEM_MAPPING_FIELD table describes the fields of a billable item mapping

CATALOG The CATALOG table contains the pricing catalogs

CHARGEABLE_ITEM The CHARGEABLE_ITEM table contains the chargeable items used when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

CHARGEABLE_ITEM_CLASS The CHARGEABLE_ITEM_CLASS table contains the description of each chargeable item class

CHARGED_ITEM The CHARGED_ITEM table contains the charged items of the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

CHARGED_ITEM_CLASS The CHARGED_ITEM_CLASS table contains the configurations the charged item classes stored in the pricing catalogs

CHARGED_ITEM_CLASS_FIELD The CHARGED_ITEM_CLASS_FIELD table describes the fields of a charged item class

CHARGED_ITEM_DEFINITION The CHARGED_ITEM_DEFINITION table contains the charged item definition of the rate plan

CHARGED_ITEM_DEFINITION_FIELD The CHARGED_ITEM_DEFINITION_FIELD table contains the properties of the charged item definition of the rate plan

CHARGE_TREE The CHARGE_TREE table contains the charge tree or pricing tree of a rate plan charge

CHARGING_NOTIFICATION The CHARGING_NOTIFICATION table contains the rating/charging notifications and errors of the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

CHARGING_PROPERTY The CHARGING_PROPERTY table contains the charging properties entered by the user or generated when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

CHARGING_RESULT The CHARGING_RESULT table contains the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

CONSUMPTION_ITEM_MAPPING_FIELD The CONSUMPTION_ITEM_MAPPING_FIELD table contains the properties of the consumption item mapping of the chargeable item class

CONTEXT_PROPERTY The CONTEXT_PROPERTY table contains the context properties defined in a node content.

CURRENCY The CURRENCY table contains data definitions for the currencies (ISO or non-ISO) that are configured in SAP CC

IDENTIFIERS The IDENTIFIERS table contains the next unique identifiers to be used for all types of objects to create.

MAPPING_TABLE The MAPPING_TABLE table contains the mapping tables stored in the pricing catalog of a service provider

MAPPING_TABLE_ADDITIONAL_INFO The MAPPING_TABLE_ADDITIONAL_INFO table contains the additional info used by the mapping table.

MAPPING_TABLE_CLASS The MAPPING_TABLE_CLASS table contains the mapping table classes stored in the pricing catalog of a service provider

MAPPING_TABLE_CLASS_ADDITIONAL_INFO The MAPPING_TABLE_CLASS_ADDITIONAL_INFO table contains the additional info used by the mapping table class.

MAPPING_TABLE_CLASS_IN_COLUMN The MAPPING_TABLE_CLASS_IN_COLUMN table contains the description of the input columns of a mapping table class.

MAPPING_TABLE_CLASS_OUT_COLUMN The MAPPING_TABLE_CLASS_OUT_COLUMN table contains the description of the output columns of a mapping table class.

MAPPING_TABLE_ROW The MAPPING_TABLE_ROW table contains the rows of the mapping tables stored in the pricing catalog of a service provider

NODE The NODE table contains the definition of the nodes of a pricing tree.

NODE_CONTENT The NODE_CONTENT table contains the configuration of the nodes of a pricing tree.

NODE_METADATA The NODE_METADATA table contains metadata about the nodes of a pricing tree.

NOTIFICATION The NOTIFICATION table contains the user notifications and their group header (for a group of notifications having the same type) in SAP CC Cockpit user interface.

NOTIFICATIONSETTING The NOTIFICATIONSETTING table contains user settings for the management of user notifications in the Cockpit user interface.

PRICING_FUNCTION The PRICING_FUNCTION table contains the basic definition of the pricing functions stored in the pricing catalogs of service providers

PRICING_FUNCTION_COUNTER The PRICING_FUNCTION_COUNTER table contains the definitions of the counters of the pricing functions

PRICING_FUNCTION_INPUT_PROPERTY The PRICING_FUNCTION_INPUT_PROPERTY table contains the definitions of the input properties of the pricing functions

PRICING_FUNCTION_OUTPUT_PROPERTY The PRICING_FUNCTION_OUTPUT_PROPERTY table contains the definitions of the output properties of the pricing functions

PRICING_FUNCTION_TREE The PRICING_FUNCTION_TREE table contains the definition of the pricing trees of the pricing functions

PROPERTY_DESCRIPTION The PROPERTY_DESCRIPTION table describes the custom properties of a chargeable item class

RANGE_TABLE The RANGE_TABLE table contains the range tables stored in the pricing catalog of a service provider

RANGE_TABLE_ADDITIONAL_INFO The RANGE_TABLE_ADDITIONAL_INFO table contains the additional info used by the range table.

RANGE_TABLE_CLASS The RANGE_TABLE_CLASS table contains the range table classes stored in the pricing catalog of a service provider

RANGE_TABLE_CLASS_ADDITIONAL_INFO The RANGE_TABLE_CLASS_ADDITIONAL_INFO table contains the additional info used by the range table class.

RANGE_TABLE_CLASS_IN_COLUMN The RANGE_TABLE_CLASS_IN_COLUMN table contains the description of the input columns of a range table class.

RANGE_TABLE_CLASS_OUT_COLUMN The RANGE_TABLE_CLASS_OUT_COLUMN table contains the description of the output columns of a range table class.

RANGE_TABLE_RANGE The RANGE_TABLE_RANGE table contains the ranges of a range set key of a version of a range table.

RANGE_TABLE_RANGE_SET_KEY The RANGE_TABLE_RANGE_SET_KEY table contains the range set keys of the version of a range table.

RANGE_TABLE_VERSION The RANGE_TABLE_VERSION table contains the versions of a range table.

RATE_PLAN The RATE_PLAN table contains the basic definition of the rate plans stored in the pricing catalogs of service providers

RATE_PLAN_ADDITIONAL_INFO The RATE_PLAN_ADDITIONAL_INFO table contains the additional info used by the rate plan.

RATE_PLAN_CHARGE The RATE_PLAN_CHARGE table contains the basic definition of the charges used by the rate plan.

RATE_PLAN_COUNTER The RATE_PLAN_COUNTER table contains the counter definitions of the rate plans

RATE_PLAN_PARAMETER The RATE_PLAN_PARAMETER table contains the parameter definitions of the rate plans

RATE_PLAN_USER_TECHNICAL_IDENTIFIER The RATE_PLAN_USER_TECHNICAL_IDENTIFIER table contains the list of User Technical Identifier definitions of a Rate Plan

SETTING The SETTING table contains the SAP CC user settings (aka preferences) for the Cockpit user interface

SPRING_SESSION The SPRING_SESSION table contains the user sessions for the SAP CC Cockpit users.

SPRING_SESSION_ATTRIBUTES The SPRING_SESSION_ATTRIBUTES table contains the attributes for each user session for the SAP CC Cockpit users.

TREE The TREE table contains the definition of a pricing tree.

TREE_DEBUG_DATA The TREE_DEBUG_DATA table contains data for testing the execution of the logic defined in a pricing tree.

VERSION The VERSION table contains the history of the database schema changes performed on an installed SAP Convergent Charging (SAP CC) Cockpit Database.

name	description
ALLOWANCE_EVENT_CLASS	The ALLOWANCE_EVENT_CLASS table contains the description of each allowance event class
ALLOWANCE_EVENT_CLASS_FIELD	The ALLOWANCE_EVENT_CLASS_FIELD table describes the properties of an allowance event class
ALLOWANCE_PLAN	The ALLOWANCE_PLAN table contains the basic definition of the allowance plans stored in the pricing catalog of a service provider
ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION	The ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION table contains the charged item definition of the allowance plan
ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD	The ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD table contains the properties of the charged item definition of the allowance plan
ALLOWANCE_PLAN_COMPUTED_PROPERTY	The ALLOWANCE_PLAN_COMPUTED_PROPERTY table contains the computed properties generated by an allowance plan
ALLOWANCE_PLAN_COUNTER	The ALLOWANCE_PLAN_COUNTER table contains the counters owned by an allowance plan
ALLOWANCE_PLAN_PARAMETER	The ALLOWANCE_PLAN_PARAMETER table contains the parameters owned by an allowance plan
BILLABLE_ITEM_MAPPING_FIELD	The BILLABLE_ITEM_MAPPING_FIELD table describes the fields of a billable item mapping
CATALOG	The CATALOG table contains the pricing catalogs
CHARGEABLE_ITEM	The CHARGEABLE_ITEM table contains the chargeable items used when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.
CHARGEABLE_ITEM_CLASS	The CHARGEABLE_ITEM_CLASS table contains the description of each chargeable item class
CHARGED_ITEM	The CHARGED_ITEM table contains the charged items of the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.
CHARGED_ITEM_CLASS	The CHARGED_ITEM_CLASS table contains the configurations the charged item classes stored in the pricing catalogs
CHARGED_ITEM_CLASS_FIELD	The CHARGED_ITEM_CLASS_FIELD table describes the fields of a charged item class
CHARGED_ITEM_DEFINITION	The CHARGED_ITEM_DEFINITION table contains the charged item definition of the rate plan
CHARGED_ITEM_DEFINITION_FIELD	The CHARGED_ITEM_DEFINITION_FIELD table contains the properties of the charged item definition of the rate plan
CHARGE_TREE	The CHARGE_TREE table contains the charge tree or pricing tree of a rate plan charge
CHARGING_NOTIFICATION	The CHARGING_NOTIFICATION table contains the rating/charging notifications and errors of the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.
CHARGING_PROPERTY	The CHARGING_PROPERTY table contains the charging properties entered by the user or generated when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.
CHARGING_RESULT	The CHARGING_RESULT table contains the processing result obtained when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.
CONSUMPTION_ITEM_MAPPING_FIELD	The CONSUMPTION_ITEM_MAPPING_FIELD table contains the properties of the consumption item mapping of the chargeable item class
CONTEXT_PROPERTY	The CONTEXT_PROPERTY table contains the context properties defined in a node content.
CURRENCY	The CURRENCY table contains data definitions for the currencies (ISO or non-ISO) that are configured in SAP CC
IDENTIFIERS	The IDENTIFIERS table contains the next unique identifiers to be used for all types of objects to create.
MAPPING_TABLE	The MAPPING_TABLE table contains the mapping tables stored in the pricing catalog of a service provider
MAPPING_TABLE_ADDITIONAL_INFO	The MAPPING_TABLE_ADDITIONAL_INFO table contains the additional info used by the mapping table.
MAPPING_TABLE_CLASS	The MAPPING_TABLE_CLASS table contains the mapping table classes stored in the pricing catalog of a service provider
MAPPING_TABLE_CLASS_ADDITIONAL_INFO	The MAPPING_TABLE_CLASS_ADDITIONAL_INFO table contains the additional info used by the mapping table class.
MAPPING_TABLE_CLASS_IN_COLUMN	The MAPPING_TABLE_CLASS_IN_COLUMN table contains the description of the input columns of a mapping table class.
MAPPING_TABLE_CLASS_OUT_COLUMN	The MAPPING_TABLE_CLASS_OUT_COLUMN table contains the description of the output columns of a mapping table class.
MAPPING_TABLE_ROW	The MAPPING_TABLE_ROW table contains the rows of the mapping tables stored in the pricing catalog of a service provider
NODE	The NODE table contains the definition of the nodes of a pricing tree.
NODE_CONTENT	The NODE_CONTENT table contains the configuration of the nodes of a pricing tree.
NODE_METADATA	The NODE_METADATA table contains metadata about the nodes of a pricing tree.
NOTIFICATION	The NOTIFICATION table contains the user notifications and their group header (for a group of notifications having the same type) in SAP CC Cockpit user interface.
NOTIFICATIONSETTING	The NOTIFICATIONSETTING table contains user settings for the management of user notifications in the Cockpit user interface.
PRICING_FUNCTION	The PRICING_FUNCTION table contains the basic definition of the pricing functions stored in the pricing catalogs of service providers
PRICING_FUNCTION_COUNTER	The PRICING_FUNCTION_COUNTER table contains the definitions of the counters of the pricing functions
PRICING_FUNCTION_INPUT_PROPERTY	The PRICING_FUNCTION_INPUT_PROPERTY table contains the definitions of the input properties of the pricing functions
PRICING_FUNCTION_OUTPUT_PROPERTY	The PRICING_FUNCTION_OUTPUT_PROPERTY table contains the definitions of the output properties of the pricing functions
PRICING_FUNCTION_TREE	The PRICING_FUNCTION_TREE table contains the definition of the pricing trees of the pricing functions
PROPERTY_DESCRIPTION	The PROPERTY_DESCRIPTION table describes the custom properties of a chargeable item class
RANGE_TABLE	The RANGE_TABLE table contains the range tables stored in the pricing catalog of a service provider
RANGE_TABLE_ADDITIONAL_INFO	The RANGE_TABLE_ADDITIONAL_INFO table contains the additional info used by the range table.
RANGE_TABLE_CLASS	The RANGE_TABLE_CLASS table contains the range table classes stored in the pricing catalog of a service provider
RANGE_TABLE_CLASS_ADDITIONAL_INFO	The RANGE_TABLE_CLASS_ADDITIONAL_INFO table contains the additional info used by the range table class.
RANGE_TABLE_CLASS_IN_COLUMN	The RANGE_TABLE_CLASS_IN_COLUMN table contains the description of the input columns of a range table class.
RANGE_TABLE_CLASS_OUT_COLUMN	The RANGE_TABLE_CLASS_OUT_COLUMN table contains the description of the output columns of a range table class.
RANGE_TABLE_RANGE	The RANGE_TABLE_RANGE table contains the ranges of a range set key of a version of a range table.
RANGE_TABLE_RANGE_SET_KEY	The RANGE_TABLE_RANGE_SET_KEY table contains the range set keys of the version of a range table.
RANGE_TABLE_VERSION	The RANGE_TABLE_VERSION table contains the versions of a range table.
RATE_PLAN	The RATE_PLAN table contains the basic definition of the rate plans stored in the pricing catalogs of service providers
RATE_PLAN_ADDITIONAL_INFO	The RATE_PLAN_ADDITIONAL_INFO table contains the additional info used by the rate plan.
RATE_PLAN_CHARGE	The RATE_PLAN_CHARGE table contains the basic definition of the charges used by the rate plan.
RATE_PLAN_COUNTER	The RATE_PLAN_COUNTER table contains the counter definitions of the rate plans
RATE_PLAN_PARAMETER	The RATE_PLAN_PARAMETER table contains the parameter definitions of the rate plans
RATE_PLAN_USER_TECHNICAL_IDENTIFIER	The RATE_PLAN_USER_TECHNICAL_IDENTIFIER table contains the list of User Technical Identifier definitions of a Rate Plan
SETTING	The SETTING table contains the SAP CC user settings (aka preferences) for the Cockpit user interface
SPRING_SESSION	The SPRING_SESSION table contains the user sessions for the SAP CC Cockpit users.
SPRING_SESSION_ATTRIBUTES	The SPRING_SESSION_ATTRIBUTES table contains the attributes for each user session for the SAP CC Cockpit users.
TREE	The TREE table contains the definition of a pricing tree.
TREE_DEBUG_DATA	The TREE_DEBUG_DATA table contains data for testing the execution of the logic defined in a pricing tree.
VERSION	The VERSION table contains the history of the database schema changes performed on an installed SAP Convergent Charging (SAP CC) Cockpit Database.