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 5.0 Application Help for more information about the possible use conditions and technical implementation limitations that relate to your database.
This product documentation is a complete reference of the schema of SAP CC IEC Database of the SAP Convergent Charging software product. SAP CC IEC Database is the back-end database of an SAP CC IEC application.
The database schema describes the structure, all the tables (entities), the columns (attributes), and the keys (relationships) of SAP CC IEC Core Database.
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.
Consult first your SAP Support Team.
Refer to this information when administering, installing/upgrading, or updpating/patching SAP CC tables in your database.
To implement this database in your SAP system landscape, consider the following activities:
Refer to the SAP CC 5.0 Tuning 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 SAP CC 5.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.
Refer to the SAP CC System Parameter Reference and SAP CC 5.0 Configuration Guide 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 SAP CC 5.0 Operations Guide for more information.
You can monitor the performance and health metrics reported by the instances of the running SAP CC Core Server system. These instances are connected to the back-end database system and manage several internal functions. By using CA Introscope for SAP in SAP Solution Manager, you can view the back-end activities that relate to the database commits, rollbacks, and prepared SQL statements.
See the {Database Name} on {Hostname} ({Database Type} DB) metric node in the SAP CC 5.0 Metric Reference and Performance Troubleshooting for more information and user assistance.
| 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. |
