CATALOG_ENTRY

Pricing Catalogs for Monetizing End-Customer Services (in SAP Master Data)

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

Reusable charges aka charge components
Refill logic objects
Pricing macros
Charge plan, refill plan, and allowance plans
Offers

And business data tables:

Technical Data

Schema Version	2025.0.0
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	IX	Uses	Used by	Definition
OID	PK_CATALOG_ENTRY			CATALOG_ENTRY (PARENT)	The unique identifier of a catalog entry. It is generated by the SAP CC system.
CLIENT_NUMBER		IX_CATA_CODE IX_CATA_OWNER			The client number associated to the catalog entry
PARENT		IX_CATA_PARENT	CATALOG_ENTRY (OID)		The OID of the parent catalog entry for this catalog subentry More...
INDEX_IN_CATA					The position of this entry in its parent catalog entry
ENTRY_NAME				HCI_USER (CATALOG_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. More...
ENTRY_TYPE					The type of the catalog entry More...
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. More...
OWNER		IX_CATA_OWNER		SUBSCRIBER_ACCOUNT (SERVICE_PROVIDER) PRICING_MACRO (OWNER) MACA (OWNER) MATA (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. More...

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. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CATALOG_ENTRY

CLIENT_NUMBER

Definition	The client number associated to the catalog entry
Type	DECIMAL(3), NOT NULL
Available Index	IX_CATA_CODE
Available Index	IX_CATA_OWNER

PARENT

Definition	The OID of the parent catalog entry for this catalog subentry
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 in its parent catalog entry
Type	DECIMAL(5), NOT NULL

ENTRY_NAME

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 (`root_directory`) or the folder name (`user_directory`). 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: Catalog name (this information is not visible in SAP CC 2025 Convergent Charging Cockpit) Folder name Otherwise the values in the ENTRY_NAME column must be equal to the values in the ENTRY_CODE column.
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 (pricing element) in a pricing 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 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 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`).
Format	It is `null` if the catalog subentry is a directory (root, user, system). 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

OWNER

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: provider contracts (see the charging view in SAP CC) subscriptions (in former data model) 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)	CLIENT_NUMBER, ENTRY_CODE
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_CATA_OWNER

Indexed Column(s)	CLIENT_NUMBER, 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