SAP HANA 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 and Business Data	Master Data Business Data End Customer Data	Power users create and maintain low volume of business data and master data to configure pricing catalogs of service providers. A master data is owned by a service provider and limited to this provider. Nobody owns the business data that is available in 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 Information	Technical Data and Audit Data	Power users and system administrators configure low volume of technical data. The SAP CC system stores high volume of audit data.
	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 4.0 Library (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 and Business Data

Master Data

This database contains the pricing catalog (master data) for each service provider defined in the SAP CC system.

Customer Master Data (in High Volume)

This database contains the customer master data of each service provider declared in the SAP CC system.

The following database tables relate to end customer information:

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

Business Data

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

• currencies
• holidays
• counter name dictionary
• VAT rates stored in the CONFIGURATION table
• VAT rules
• spending status descriptions

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

Technical Data and Audit 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.

• User Management: SAP CC users
• Audit Data: SAP CC user operations and object change logs

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