BART Database Reference (MS SQL Server)

Target Audience

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

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.

Getting Started

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

The database schema describes the structure, all the tables (entities), the columns (attributes), and the keys (relationships) of SAP CC BART 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 or upgrading
updating or patching SAP CC tables in your database

Database Schema

Database Indexes

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.

Reserved Space in Filegroups

This database schema defines some reserved spaces to optimize the physical storage of data in your database system. You configure and maintain these spaces.

Database Partitioning

SAP Convergent Charging provides advanced functions to ensure the highest level of performance (high volume of data, very high end-to-end throughput and latency) and high availability. These functions require database partitioning to improve the database performance with large and very large databases.

SAP CC associates a business partitioning mechanism to isolate some data during business operations.

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

Schemas and Database Partitioning

SAP CC delivers two schemas of BART Database.

SQL Scripts

Implementation

To implement this database in your SAP system landscape, consider the following activities:

Sizing
Installation
Technical configuration in SAP CC
Validations
Technical operations (administration, software maintenance, purging and archiving, monitoring, and troubleshooting)

Sizing

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:

Data volume
Performance
Robustness
Scalability
High availability

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

Notes

The regular growth of data volume and the load of the network must be taken into account as conditions for the initial sizing.
Confirm and adapt your initial sizing with performance and validation tests.

Installation

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.

Technical Configuration in SAP CC

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.

Technical Operations

During the project implementation phase or during the productive operation phase, consider the following activities:

Administration
Software maintenance
Purging and archiving
Monitoring
Troubleshooting

Software 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 to monitor the back-end databases of SAP Convergent Charging. Refer to the Operations Information for SAP Convergent Charging 2022 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.