MOPA

Description

The MOPA table contains the basic definition of the monitoring plans stored in the monitoring catalog of a service provider.

These definitions are completed with information stored in the MOPA_xx database tables ( MOPA_COUNTER , MOPA_ACCOUNT_ASSIGNMENT , ...)

Technical Data

Schema Version	4.5.13
Segment	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_MOPA				MOPA_ADDITIONAL_INFO (MOPA_OID) MOPA_USER_TECH_ID (MOPA_OID) MOPA_SPENDING_STATUS_MAPPING (MOPA_OID) MOPA_PARAMETER (MOPA_OID) MOPP_ADDITIONAL_INFO (MOPA_OID)
EXT_ID			IX_MOPA_EXT_ID
OWNER			IX_MOPA_OWNER
STATUS
DESCRIPTION

Column Details

OID

Definition	The unique identifier of the monitoring plan (or refill plan). It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_MOPA

EXT_ID

Definition	The external identifier of the plan, corresponding to the name of the plan in the SAP CC Core Tool user interface
Type	NVARCHAR(256), NOT NULL
Available Index	IX_MOPA_EXT_ID

OWNER

Definition	The owner of the plan: the service provider and its pricing catalog
Type	NVARCHAR(256), NOT NULL
Available Index	IX_MOPA_OWNER

STATUS

Definition	The status of the monitoring plan (or refill plan)
Format	The possible values are: 0: open 1: released 2: obsolete
Type	DECIMAL(1), NOT NULL

DESCRIPTION

Definition	The description of the monitoring plan
Type	NVARCHAR(2000), NULL

Primary Key Details

PK_MOPA

Column(s)	OID
Segment	CATALOG_INDX

Index Details

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

IX_MOPA_OWNER

Indexed Column(s)	OWNER
Unique	Yes
Partitioned	No
Clustered	No
Segment	CATALOG_INDX

IX_MOPA_EXT_ID

Indexed Column(s)	EXT_ID
Unique	Yes
Partitioned	No
Clustered	No
Segment	CATALOG_INDX