PRODUCT

Definition

The PRODUCT table contains basic information about the chargeable item packages/products

Description

The PRODUCT table contains basic information about the chargeable item packages/products (description, codename, owner) managed by SAP Convergent Charging. A product represents a customer service, which can be charged according to its usage.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The PRODUCT 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_PRODUCT				CI_DESCRIPTION (PROD_OID)	The product unique ID. It is generated by the SAP CC system.
DESCRIPTION						The description of the product in plain text
CODE			IX_PRODUCT_CODE			The code of the product (chargeable item package
OWNER			IX_PRODUCT_VENDOR			The owner of the product

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The product unique ID. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_PRODUCT

DESCRIPTION

Definition	The description of the product in plain text
Type	NVARCHAR(2000), NULL

CODE

Definition	The code of the product (chargeable item package
Type	NVARCHAR(256), NOT NULL
Available Index	IX_PRODUCT_CODE

OWNER

Definition	The owner of the product
Type	NVARCHAR(64), NOT NULL
Available Index	IX_PRODUCT_VENDOR

Primary Key Details

See the primary key information:

PK_PRODUCT

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

The following database indexes are available in the PRODUCT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_PRODUCT_VENDOR

Indexed Column(s)	OWNER
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_PRODUCT_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX