MS SQL Server Tables

Important Note

The business and technical concepts of SAP Convergent Charging are directly managed by the SAP CC system and not in the back-end database system. Do not use this SAP product documentation to understand the functional concepts of SAP CC. Always refer to the SAP CC 4.0 Library (Application Help).

Operations

Note

Refer to the SAP CC 4.0 Operations Guide for more information about:

data purging and archiving
database monitoring
troubleshooting
other production operations (system maintenance, software maintenance)

Tables In Database Schema

To facilitate the understanding of the database schema, the following elements represent the structure of the database:

Data in Database Subdata Description

Master and Business Data

Master Data

Business Data

End Customer Data

Power users create and maintain low volume of business data and master data to configure pricing catalogs of service providers. A master data is owned by a service provider and limited to this provider. Nobody owns the business data that is available in complete SAP CC system for configuring master data or performing business operations (charging and refillin operations).

The SAP CC system stores high volume of master data related to end customers of service providers created by an interfaced CRM application or provisioning system.

Business Processing Data The SAP CC Core Server system stores high volume of business processing data for different periods.

Technical Information Technical Data and Audit Data
Power users and system administrators configure low volume of technical data. The SAP CC system stores high volume of audit data.

SAP CC System Settings Core Database includes most of the configuration settings of the connected Core Server system. The implementation project team configures and customizes this information depending on the business requirements of the system landscape.

Data in Database	Subdata	Description
Master and Business Data	Master Data Business Data End Customer Data	Power users create and maintain low volume of business data and master data to configure pricing catalogs of service providers. A master data is owned by a service provider and limited to this provider. Nobody owns the business data that is available in complete SAP CC system for configuring master data or performing business operations (charging and refillin operations). The SAP CC system stores high volume of master data related to end customers of service providers created by an interfaced CRM application or provisioning system.
Business Processing Data		The SAP CC Core Server system stores high volume of business processing data for different periods.
Technical Information	Technical Data and Audit Data	Power users and system administrators configure low volume of technical data. The SAP CC system stores high volume of audit data.
SAP CC System Settings	Core Database includes most of the configuration settings of the connected Core Server system. The implementation project team configures and customizes this information depending on the business requirements of the system landscape.

For more information, refer to the schema details and to the SAP CC 4.0 Library (Application Help).

A-Z Index

See the A-Z index to view a particular table quickly.

Schema Details

Consider the following database table categories:

Master and Business Data

Recommendation

For more information about the master data and customer master data in SAP Convergent Charging, consult the SAP CC 4.0 Library (Application Help).

Master Data

This database contains the pricing catalog (master data) for each service provider defined in the SAP CC system.

Customer Master Data (in High Volume)

This database contains the customer master data of each service provider declared in the SAP CC system.

The following database tables relate to end customer information:

Business Partner Management: subscriber accounts and business data tables (subscriber mapping tables and subscriber range tables)
Business Agreement Management: prepaid accounts and external postpaid accounts specified in the subscriber accounts
Order Capture and Contract Management: charging data of the provider contracts, business data tables, allowances, and subscriptions (old data model of SAP CC)

Business Data

This database contains some business data used by the SAP CC Core Server system to configure master data or to process business operations (charging, refilling):

currencies
holidays
counter name dictionary
VAT rates stored in the CONFIGURATION table
VAT rules
spending status descriptions

Business Processing Data

This database contains some tables used to store a lot of data records resulting from the business processing by the SAP CC Core Server system:

Session-based charging services (real-time): charging session data
Re-charging (and rerating) services: counter snapshots
Prerating services (deprecated): rating record data (deprecated)

A storage space is reserved for each type of data records: SESSION_RATING_DATA, C_SNAPSHOT_DATA, and PRERATING_DATA.

The Core Server system updates this data frequently.

Note

Consider also the counter data and allowance data associated to a contract or subscription.

The Core Server system updates frequently this data during charging and refilling operations. They have dedicated reserved spaces in the database.

Technical Data and Audit Data

This database contains some tables used to store technical data generated by the SAP CC Core Server system. It includes also the configuration of SAP CC users.

User Management: SAP CC users
Audit Data: SAP CC user operations and object change logs

SAP CC System Settings

This database contains some tables used to manage the system configuration of the SAP CC Core Server system connected to the back-end database system: