CAPA

Charge Plans, Refill Plans, and Allowance Plans (Master Data)

Description

The CAPA table contains the basic definition of the charge plans, refill plans, and allowance plans stored in the pricing catalog of a service provider.

These definitions are completed with information stored in the CAPA_xx database tables (CAPA_COUNTER, CAPA_ACCOUNT_ASSIGNMENT, ...) and in the database tables dedicated to the items of these plans (see the CAPI table).

Note

For compatibility reasons, the technical name (CAPA) of this database table remains unchanged even if the table concerns the refill plans and allowance plans configured in the SAP CC system.

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	IX	Used by
OID	PK_CAPA		CAPA_NAMES_DICT (CAPA_OID) CAPA_ADDITIONAL_INFO (CAPA_OID) CAPA_PARAMETER (CAPA_OID) CAPA_COUNTER (CAPA_OID) CAPA_USER_TECH_ID (CAPA_OID) CAPA_ACCOUNT_ASSIGNMENT (CAPA_OID) CAPA_CHARGE_DEPENDENCY (CAPA_OID) CAPI (CAPA_OID) CACI (CAPA_OID) ALLO (CAPA_OID)
EXT_ID		IX_CAPA_EXT_ID
TYPE
OWNER		IX_CAPA_OWNER
STATUS
DESCRIPTION

Column Details

OID

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

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_CAPA_EXT_ID

TYPE

Definition The type of the plan

Format

The possible values are:

0: Charge plan
1: Refill plan
2: Allowance Plan

Type DECIMAL(1), NOT NULL

OWNER

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

STATUS

Definition The status of the charge 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 charge plan
Type	NVARCHAR(2000), NULL

Primary Key Details

PK_CAPA

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_CAPA_OWNER

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

IX_CAPA_EXT_ID

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