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 does not recommend that you use direct SQL queries for statistics or monitoring an SAP CC production system.
Consult first your SAP Support Team.
Recommendation
SAP recommends that you consult the SAP CC 2022 Application Help for more information about the possible use conditions and technical implementation limitations that relate to your database.
This SAP product documentation is a complete reference of the schema of SAP CC Cockpit Database, a component of the SAP Convergent Charging 2022 software product. SAP CC Cockpit Database is the back-end database of the SAP CC Cockpit web application.
It contains the different data related to the business and technical processes handled by the SAP CC Cockpit application. This data includes:
| Data in Database | Main Data | Comment |
|---|---|---|
| Business configuration data |
|
The SAP Master Data (MD) is owned by a service provider of digital services charged with SAP Convergent Charging (SAP CC). This Master Data is synchronized with the SAP CC Core Database in its RDBMS. |
|
The business/custom data is defined for the complete SAP CC system and all the service providers. This data is shared with all the pricing catalogs. This business/custom data is synchronized with the SAP CC Core Database in its RDBMS. |
|
| Business processing data | Processing results (real executions or simulations) with charged items (as outputs) and chargeable items (as inputs) | |
| Technical data |
|
Refer to this information when administering the SAP CC Cockpit application or its back-end database system, installing/upgrading, or updating/patching SAP CC tables in your database.
The database schema describes the structure, all the tables (entities), the columns (attributes), and the keys (relationships) in the SAP CC database. It defines the relevant database indexes to speed up the retrieval of data stored in the database tables.
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).
Refer to the SAP CC 2022 Application Help for more information about the concepts of SAP Convergent Charging:
This schema defines some reserved spaces to optimize the physical storage of data in the database system.
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.
Refer to the main database tables or view the index of tables.
PK: Primary Key
FK: Foreign Key
UK: Unique Key
IX: Indexed Field
This database schema defines the necessary database indexes to speed up the retrieval of data stored in the database tables. The initial installation of SAP CC creates these indexes that you manage during technical operations.
The Cockpit web application automatically manages the creation and maintenance of the database schema in the installed database system (RDBMS).
All the necessary SQL scripts are delivered with SAP Convergent Charging (SAP CC) to:
Delivered SQL scripts are packaged in the libraries of the deployed Cockpit web application. When starting, the web application runs the necessary SQL scripts.
Example
The Cockpit application runs the SQL scripts cockpitdb_v2021.0.2_hdb.sql and cockpitdb_v2022.0.0_hdb.sql to create the database schema stored in an SAP HANA Database system.
To implement this database in your SAP system landscape, consider the following activities:
Refer to the SAP CC 2022 Tuning and System Configuration Guide and Sizing Guidelines for SAP Convergent Charging for information about the the translation of your business requirements and IT strategy into hardware requirements based on predictions considering:
The sizes of the hardware and database are influenced by both business aspects and technological aspects.
Notes
Refer to the Installation Information for SAP Convergent Charging 2022 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.
Refer to the SAP CC 2022 System Parameter Reference and System Configuration Information for SAP Convergent Charging 2022 for more information about the configuration in SAP CC that relates to the databases. See the SQLHELPER_LOGIN system parameter.
During the project implementation phase or during the productive operation phase, consider the following activities:
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.
Install and use DBA Cockpit in SAP Solution Manager to monitor the back-end databases of SAP Convergent Charging. Refer to the Operations Information for SAP Convergent Charging 2022 for more information.
| Communication | From Logs | Performance |
|---|---|---|
|
You use SAP Solution Manager to detect connection or communication problems. You use the SAP CC Admin+ user interface: |
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. |