The CATALOG_ENTRY database table includes all the elements for the pricing catalogs that are 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 marketable end-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:
charge components
| Schema Version | 2022.0.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
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. It is generated by the SAP CC system. | |||
| PARENT | IX_CATA_PARENT | CATALOG_ENTRY (OID)
|
|
The OID of the parent catalog entry for this catalog subentry | ||
| INDEX_IN_CATA |
|
The position of this entry in its parent catalog entry | ||||
| ENTRY_NAME |
|
The identification code name of the catalog entry in the catalog. It is the catalog name, the directory name, or the copy of the ENTRY_CODE information. | ||||
| ENTRY_TYPE |
|
The type of the catalog entry | ||||
| ENTRY_CODE | IX_CATA_CODE | CHARGE_COMPONENT (CODE)
PRICING_MACRO (CODE) CAPA (EXT_ID) MACA (ID) MATA (ID) |
|
The target code name (or ID) of the catalog data/object (pricing element) that belongs to the catalog. It is null if the catalog entry is the catalog root or a user-defined directory. | ||
| OWNER | IX_CATA_OWNER |
|
The owner of the pricing catalog and all its pricing elements: It is the company name of the service provider or a textual reference to a bundle of services when some pricing configuration elements can be shared and reused. All the pricing configuration elements that are part of the same pricing catalog must have the same owner information. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of a catalog entry. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_CATALOG_ENTRY |
| Definition | The OID of the parent catalog entry for this catalog subentry |
| Description |
|
| Type | DECIMAL(28), NULL |
| Available Index | IX_CATA_PARENT |
| Definition | The position of this entry in its parent catalog entry |
| Type | DECIMAL(5), NOT NULL |
| Definition | The identification code name of the catalog entry in the catalog. It is the catalog name, the directory name, or the copy of the ENTRY_CODE information. |
| Description |
ENTRY_NAME has different meanings:
When the catalog subentry is type of directory, ENTRY_NAME is a legible name defined
by an SAP CC user who configures a pricing catalog.
It is the catalog name (
When the catalog subentry is a marker (reference) to a catalog object (pricing element),
ENTRY_NAME is equal to ENTRY_CODE.
Note
The ENTRY_NAME information is not the OWNER information.
|
| Format |
The possible values for a directory are:
Otherwise the values in the ENTRY_NAME column must be equal to the values in the ENTRY_CODE
column.
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The type of the catalog entry |
| Format |
The possible values for a directory are:
The possible values for an object (pricing element) in a pricing catalog are:
|
| Type | NVARCHAR(256), NULL |
| Definition | The target code name (or ID) of the catalog data/object (pricing element) that belongs to the catalog. It is null if the catalog entry is the catalog root or a user-defined directory. |
| Description |
The code name or ID that identifies the target catalog data/object (pricing element)
for which this catalog subentry is defined.
It is a legible name that is visible in the user interfaces.
Notes |
| Format |
It is
Otherwise ENTRY_CODE is the code name (or ID) that identifies the target catalog data/object
(pricing logic element).
Note that ENTRY_CODE is equal to ENTRY_NAME.
|
| Type | NVARCHAR(256), NULL |
| Available Index | IX_CATA_CODE |
| Definition | The owner of the pricing catalog and all its pricing elements: It is the company name of the service provider or a textual reference to a bundle of services when some pricing configuration elements can be shared and reused. All the pricing configuration elements that are part of the same pricing catalog must have the same owner information. |
| Description |
The owner of the pricing catalog: The service provider company that provides and monetizes
one or multiple the end-customer services
to monetize and that owns the business agreements (provider contracts, subscriptions)
based on this pricing catalog
The legal or technical 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 |
See the primary key information:
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
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:
| Indexed Column(s) | ENTRY_CODE |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
| Indexed Column(s) | OWNER |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
| Indexed Column(s) | PARENT |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
