Core Database Reference (MS SQL Server)

Target Audience

IT system architect
Technology consultant
Implementation project team
Database system administrator (DBA)
Support specialist

Getting Started

This SAP product documentation is a complete reference of the schema of SAP CC Core Database, a component of the SAP Convergent Charging 4.0 software product. SAP CC Core Database is a back-end database of SAP CC Core Server.

It contains the different data related to the business and technical processes handled by the SAP CC Core Server system. This data includes:

Data in Database	Main Data	Comment
Master and business data	Pricing catalogs (with the pricing logic) for each digital service of the service providers Currencies, holidays, VAT rates	The master data is owned by a service provider of digital services charged with SAP Convergent Charging. The business data is defined for the complete SAP CC system and all the service providers.
Customer master data	Subscriber accounts Provider contracts or subscriptions and business data tables	The customer master data is owned by a service provider of digital services.
Business processing data	Charging session data (session-based charging services), counter snapshots	Consider also the counter and allowance data.
Technical information data	SAP CC users and audit data (user operations, object change logs) SAP CC System Settings

Refer to this information when administering the SAP CC system or the database system, installing/upgrading, or updpating/patching SAP CC tables in your database.

Database Schema

The database schema describes the structure, all the tables (entities), the columns (attributes), and the keys (relationships) of SAP CC Core Database.

Depending on your business requirements, there are two classes of schemas: a schema with business partitions (large business) and a schema without database partition.

Note

This schema is the logical schema. It informs the design of the database whatever the database system. It includes partial information about the physical schema (implementation in different database systems) and about the conceptual schema (concepts and relationships).

This schema defines some reserved spaces to optimize the physical storage of data in the database system.

Caution

Direct SQL queries on the database are not allowed. Do not modify the data stored in the database system.

Consult first your customer project team during the implementation phase of SAP CC.

Important Note

SAP SE does not recommend that you use direct SQL queries for statistics or monitoring an SAP CC production system.

Consult first your SAP Support Team.

Schema Version

The database schema is identified with a unique version. Refer to the VERSION table for more information about the version information format and version history.

Reserved Spaces

This database schema defines some reserved spaces to optimize the storage of data in the database system.

Schema Partitioning

SAP CC delivers two schemas of Core Database.

Class Scope

Schema With Database Partitions large and high volume of data, high performance

Schema Without Partition

small-sized business environments (production system landscapes)

or development system landscapes

Each relevant database table includes a PARTITION_ID column that refers to the partition ID of the associated subscriber account. Both objects belong to the same database partition.

Class	Scope
Schema With Database Partitions	large and high volume of data, high performance
Schema Without Partition	small-sized business environments (production system landscapes) or development system landscapes

For more information about the business partitioning in SAP Convergent Charging, consult the SAP CC 4.0 Library (Application Help) and the database section.

Note

SAP CC provides you with two corresponding sets of SQL scripts.

Main Database Tables

Refer to the main database tables or view the index of tables.

Legend and Abbreviations

PK: Primary Key
FK: Foreign Key
UK: Unique Key
IX: Indexed Field

SQL Scripts

All the necessary SQL scripts are delivered with SAP Convergent Charging to:

Administer your database and SAP CC tables (creation and deletion scripts)
Change some SAP CC tables in your database (patch scripts) during the software maintenance of SAP CC or during troubleshooting operations

Delivered SQL scripts are stored in one of the following SAP CC installation folders:

MS Windows: <DRIVE>:\usr\sap\<SID>\CCD<INST_NB>\exe\CC_CORE_SERVER\core_sql
UNIX and other operating systems: /usr/sap/<SID>/CCD<INST_NB>/exe/CC_CORE_SERVER/core_sql

SAP CC delivers two sets of SQL scripts. The naming convention uses the enterprise and standard terms:

Script Set Script Name Patern

With Partitions <DB_TECHNO_KEY>_enterprise_<DB_SCHEMA_KEY>_create

Without Partition <DB_TECHNO_KEY>_standard_<DB_SCHEMA_KEY>_create

Script Set	Script Name Patern
With Partitions	<DB_TECHNO_KEY>_enterprise_<DB_SCHEMA_KEY>_create
Without Partition	<DB_TECHNO_KEY>_standard_<DB_SCHEMA_KEY>_create

Note

The delivered SQL scripts are stored in the SAP Central Repository of the SAP CC system. This file repository is available on the SAP Global Host in the following directory:

MS Windows: \\<SAP_GLOBAL_HOST>\sapmnt\<SID>\SYS\
UNIX and other OSs: /sapmnt/<SID>/SYS/

Where <SID> is the SAP system ID.

Legend and Abbreviations

PK: Primary Key
FK: Foreign Key
UK: Unique Key
IX: Indexed Field

Sizing

Refer to the SAP CC 4.0 Sizing Guide and SAP CC 4.0 Sizing Guidelines for information about the the translation of your business requirements and IT strategy into hardware requirements based on predictions considering:

data volume
performance
robustness
scalability
high availability

The sizes of the hardware and database are influenced by both business aspects and technological aspects.

Note

The regular growth of data volume and the load of the network must be taken into account as conditions for the initial sizing.

Installation

Refer to the SAP CC 4.0 Installation Guide for information about the installation preparations, initial installation, and follow-up activities of this database system in your SAP CC system landscape.

Note

Refer to the information provided by the database supplier.

Technical Configuration

Refer to the SAP CC System Parameter Reference and SAP CC 4.0 Configuration Guide for more information about the configuration in SAP CC that relates to the databases. See the SQLHELPER_LOGIN system parameter.

Maintenance

Refer to the information provided by the database supplier for more information about the software maintenance of your database systems.

Note

The software maintenance of SAP Convergent Charging may change the database schema or the stored data. When the SAP CC system administrator implements a support package (SP) or a patch level of SAP Convergent Charging, the maintenance procedures modify the back-end database. Refer to the delivery notes (SAP Notes) provided with the new versions of SAP CC.

Monitoring

DBA Cockpit

Install and use DBA Cockpit in SAP Solution Manager for monitoring the databases of SAP Convergent Charging. Refer to the SAP CC 4.0 Operations Guide for more information.

Troubleshooting

Communication From Logs Performance

You use SAP Solution Manager to detect connection or communication problems.

You use the SAP CC Admin+ user interface:

admin_sql_connection - To disconnect from or to force the reconnection of the selected instances of the SAP CC system with a selected instance of the database system

refresh_sql_connections - To force the update of the connections to the database

You use the logs of the database system.

You use the logs and traces recorded in the SAP CC system.
You use SAP Solution Manager.