MAPPING_TABLE_CLASS

Mapping Table Class

Definition

The MAPPING_TABLE_CLASS table contains the mapping table classes stored in the pricing catalog of a service provider

Description

The MAPPING_TABLE_CLASS table contains the basic definition of the mapping table classes stored in the pricing catalog of a service provider.

They define the structure of the mapping tables stored in the MAPPING_TABLE table.

Technical Data

Schema Version	2025.0.0
Partitioned	No

Summary

The MAPPING_TABLE_CLASS 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_MAPPING_TABLE_CLASS					The unique identifier of the mapping table class. It is generated by the SAP CC Cockpit application.
CLIENT_NUMBER			IX_MAPPING_TABLE_CLASS_NAMEIX_MAPPING_TABLE_CLASS_STATE			The client number associated to the mapping table class
NAME			IX_MAPPING_TABLE_CLASS_NAME			The name of the mapping table class
CATALOG						The name of the pricing catalog that owns the mapping table class
CC_OID						The unique identifier of the mapping table class in the SAP CC Core Server system
DESCRIPTION						The description of the mapping table class
IN_ERROR_STATE						Indicates whether the mapping table class is in error or not More...
IS_LOCKED_BY_ME						This value is never stored in database. It is computed by the SAP CC Cockpit back-end application.
LOCKING_USER						The name of the SAP CC user who opened the mapping table class in creation or modification
OBJECT_CHANGE_NUMBER						The change number of the mapping table class More...
RELEASED_OID						The unique identifier of the released mapping table class when its is being modified
STATE			IX_MAPPING_TABLE_CLASS_STATE			The state of the mapping table class More...
UNSAVED_CHANGES						This value is never stored in database. It is computed by the SAP CC Cockpit back-end application.
LAST_CHANGE						The last creation or modification date of the mapping table class

Column Details

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

OID

Definition	The unique identifier of the mapping table class. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_MAPPING_TABLE_CLASS

CLIENT_NUMBER

Definition	The client number associated to the mapping table class
Type	DECIMAL(3), NULL
Available Index	IX_MAPPING_TABLE_CLASS_NAME
Available Index	IX_MAPPING_TABLE_CLASS_STATE

NAME

Definition	The name of the mapping table class
Type	NVARCHAR(256), NULL
Available Index	IX_MAPPING_TABLE_CLASS_NAME

CATALOG

Definition	The name of the pricing catalog that owns the mapping table class
Type	NVARCHAR(256), NULL

CC_OID

Definition	The unique identifier of the mapping table class in the SAP CC Core Server system
Type	DECIMAL(28), NULL

DESCRIPTION

Definition	The description of the mapping table class
Type	NVARCHAR(2000), NULL

IN_ERROR_STATE

Definition	Indicates whether the mapping table class is in error or not
Format	The possible values are: 0: No errors 1: One or more errors
Type	BOOLEAN, NULL

IS_LOCKED_BY_ME

Definition	This value is never stored in database. It is computed by the SAP CC Cockpit back-end application.
Type	BOOLEAN, NULL

LOCKING_USER

Definition	The name of the SAP CC user who opened the mapping table class in creation or modification
Type	NVARCHAR(256), NULL

OBJECT_CHANGE_NUMBER

Definition	The change number of the mapping table class
Description	The change number of the mapping table class. Used to detect object desynchronization with the SAP CC Core Server system.
Type	DECIMAL(28), NULL

RELEASED_OID

Definition	The unique identifier of the released mapping table class when its is being modified
Type	DECIMAL(28), NULL

STATE

Definition	The state of the mapping table class
Format	The possible values are: 0: CREATED 1: MODIFIED 2: RELEASED
Type	DECIMAL(3), NULL
Available Index	IX_MAPPING_TABLE_CLASS_STATE

UNSAVED_CHANGES

Definition	This value is never stored in database. It is computed by the SAP CC Cockpit back-end application.
Type	BOOLEAN, NULL

LAST_CHANGE

Definition	The last creation or modification date of the mapping table class
Type	SECONDDATE, NULL

Primary Key Details

See the primary key information:

PK_MAPPING_TABLE_CLASS

Column(s)	OID
Tablespace	COCKPIT_INDX

Index Details

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

IX_MAPPING_TABLE_CLASS_NAME

Indexed Column(s)	CLIENT_NUMBER,NAME
Unique	No
Partitioned	No

IX_MAPPING_TABLE_CLASS_STATE

Indexed Column(s)	CLIENT_NUMBER,STATE
Unique	No
Partitioned	No