MS SQL Server Tables

Operations

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 Data and Business/Custom Data	Master Data Customer Master Data (in High Volume) Business and Custom Data	Power users create and maintain low volume of business/custom data and master data. They configure the pricing catalogs of service providers. A master data is owned by a service provider and limited to this provider. Nobody owns the business/custom data that is available in the 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 Data	Technical Information SAP CC User Data User Operation Auditing Data Data Object Auditing Data Usage Metrics	Power users and system administrators configure low volume of technical data (SAP users). The SAP CC Core Server system stores high volume of audit data (various types of recordings).
	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 5.0 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 Data and Business/Custom Data

Master Data

In SAP Convergent Charging, the SAP master data objects (Master Data) consist in two classes:

• the pricing catalogs of the digital services to be monetized for each service provider modeled in SAP CC
• the customer master data that represents the end customers of a service provider and for a particular digital service or service bundle

This back-end database contains all these master data objects. Note that no service provider is configured in the SAP CC database.

Pricing Catalogs

This back-end database contains the pricing catalogs as master data of each service provider. Depending on the business requirements and modeling results, a pricing catalog relates to a particular digital service or to a bundle of services to be monetized. The service provider offering the marketable services is the owner of this master data.

Customer Master Data (in High Volume)

This back-end database contains the customer master data of each service provider modeled in the SAP CC system. The customer master data is assigned to a pricing catalog configured in SAP CC.

The following database tables relate to end customer information:

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

Business and Custom Data

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

Business Data	Custom Data
Currencies Public holidays VAT rates stored in the CONFIGURATION table VAT rules	Allowance interface (see the ALLOWANCE_INTERFACE_PARAMETER table) Billable item mapping (see the EXPORTABLE_ITEM_MAPPING table) Counter name dictionary Spending status descriptions

Business and custom data is defined at the SAP CC sysem level. It cannot be customized for a particular service provider. It is shared by all the pricing catalogs and by all the objects in customer master data.

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 SAP CC Core Server system updates this data frequently.

Technical 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.

• SAP user management: SAP CC users and roles
• Audit management:
  • Custom filters and cycles: custom audit filters
  • Audit data recordings (in high volume):
    • audited user operations
    • object change logs
    • object snapshots
  • Recorded usage metrics (SAP system measurement)

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:

• System parameters of the SAP CC system instances
• System configuration records

See Also

The Core Database of SAP Convergent Charging includes the following database filegroups. They are defined to optimize the storage of data in the database system (MS SQL Server).