CATALOG_ENTRY
Definition
The CATALOG_ENTRY table contains all the elements for the pricing catalogs defined in master data owned by a service provider
Description
The CATALOG_ENTRY table contains all the elements for the pricing catalogs stored in SAP Master Data.
The service provider is the owner of the master data but there is no dedicated database table.
A pricing catalog contains several entries in this table.
It includes all the objects necessary to configure the pricing logic related to the
use of a customer service.
In each pricing catalog you can find all the pricing objects configured in the SAP
CC system for a service provider:
And business data tables:
Technical Data
| Schema Version | 4.6.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
Summary
The CATALOG_ENTRY table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| OID | PK_CATALOG_ENTRY |
|
The unique identifier of a catalog entry | |||
| PARENT | IX_CATA_PARENT | CATALOG_ENTRY (OID)
|
|
The OID of the parent catalog entry | ||
| INDEX_IN_CATA |
|
The position of this entry into its parent catalog | ||||
| ENTRY_NAME |
|
The identification codename of the entry in the catalog of a service provider | ||||
| ENTRY_TYPE |
|
The type of the catalog entry | ||||
| ENTRY_CODE | IX_CATA_CODE |
|
The identification code of the subentry in the catalog. It is null if the entry is the root | |||
| OWNER | IX_CATA_OWNER |
|
The owner of the pricing catalog: The service provider that offers the customer service to monetize and that owns the business agreements (provider contracts, subscriptions) based on this pricing catalog |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| Definition | The unique identifier of a catalog entry |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_CATALOG_ENTRY |
PARENT
| Definition | The OID of the parent catalog entry |
| Description | The OID of the parent catalog entry. It can be null if this entry is the root of a pricing catalog (entry type is root_directory).
|
| Type | DECIMAL(28), NULL |
| Available Index | IX_CATA_PARENT |
INDEX_IN_CATA
| Definition | The position of this entry into its parent catalog |
| Type | DECIMAL(5), NOT NULL |
ENTRY_NAME
| Definition | The identification codename of the entry in the catalog of a service provider |
| Type | NVARCHAR(256), NOT NULL |
ENTRY_TYPE
| Definition | The type of the catalog entry |
| Format |
The possible values for a directory are:
|
| Type | NVARCHAR(256), NULL |
ENTRY_CODE
| Definition | The identification code of the subentry in the catalog. It is null if the entry is the root |
| Description | The identification code of the subentry in the pricing catalog.
Notes
|
| Type | NVARCHAR(256), NULL |
| Available Index | IX_CATA_CODE |
OWNER
| Definition | The owner of the pricing catalog: The service provider that offers the customer service to monetize and that owns the business agreements (provider contracts, subscriptions) based on this pricing catalog |
| Description |
The legal owner of the pricing catalog: The service provider company that offers the customer service to monetize and that owns the business agreements based on this pricing catalog: Notes Each service provider owns the master data that includes all the data objects configured and managed in SAP CC. For example, consider the subscriber accounts in customer master data. |
| Type | NVARCHAR(64), NULL |
| Available Index | IX_CATA_OWNER |
Primary Key Details
See the primary key information:
PK_CATALOG_ENTRY
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
Index Details
The following database indexes are available in the CATALOG_ENTRY database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_CATA_CODE
| Indexed Column(s) | ENTRY_CODE |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
IX_CATA_OWNER
| Indexed Column(s) | OWNER |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
IX_CATA_PARENT
| Indexed Column(s) | PARENT |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |