CATALOG_ENTRY

Description

The CATALOG_ENTRY table contains all the elements for the pricing catalogs (master data related to a service provider as owner).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:

reusable charges
refill logic objects
pricing macros
charge plans and refill plans
offers

And

Technical Data

Schema Version	4.5.13
Partitioned	No

Summary

The CATALOG_ENTRY table is defined by the following columns. See the column details for more information.

Name	PK	IX	Uses	Used by
OID	PK_CATALOG_ENTRY			CATALOG_ENTRY (PARENT)
PARENT		IX_CATA_PARENT	CATALOG_ENTRY (OID)
INDEX_IN_CATA
ENTRY_NAME				HCI_USER (CATALOG_NAME)
ENTRY_TYPE
ENTRY_CODE		IX_CATA_CODE
OWNER		IX_CATA_OWNER

Column Details

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 name 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:

user_directory
system_directory
root_directory

The possible values for an object in a catalog are:

product
offer
pricingMacro
translationTable
tierTable
mappingTableClass
mappingTable
rangeTableClass
rangeTable
chargeableItemClass
chargeComponent
chargedItemClass
chargedItemAggregationPolicy
chargePlan
refillItemClass
refillLogic
refillRecordClass
refillPlan
allowanceEventClass
allowanceLogic
allowancePlan
monitoringPlan

Type NVARCHAR(256), NULL

ENTRY_CODE

Definition	The codename of the entry in the catalog
Description	The codename of the entry in the catalog. Note See the CODE column of the PRODUCT, TRANSLATION_TABLE, TIER_TABLE,OFFER, ... tables according to the type of entry. It can be null if this entry is the root of a catalog (entry type is `root_directory`).
Type	NVARCHAR(256), NULL
Available Index	IX_CATA_CODE

OWNER

Definition	The owner of the pricing catalog: The service provider that supplies the customer service to charge and that owns the business agreements (provider contracts, subscriptions)
Type	NVARCHAR(64), NULL
Available Index	IX_CATA_OWNER

Primary Key Details

PK_CATALOG_ENTRY

Column(s)	OID
Tablespace	CATALOG_INDX

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

IX_CATA_OWNER

Indexed Column(s)	OWNER
Unique	No
Partitioned	No

IX_CATA_PARENT

Indexed Column(s)	PARENT
Unique	No
Partitioned	No