CAPA
Definition
The CAPA table contains the basic definition of the logic plans (charge plans, refill plans, and allowance plans) stored in the pricing catalog of a service provider
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.6.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
Summary
The CAPA 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_CAPA |
|
The unique identifier of the charge plan (or refill plan). It is generated by the SAP CC system. | |||
| EXT_ID | IX_CAPA_EXT_ID |
|
The external identifier of the plan, corresponding to the name of the plan in the SAP CC Core Tool user interface | |||
| TYPE |
|
The type of the plan | ||||
| OWNER | IX_CAPA_OWNER |
|
The owner of the plan: the service provider and its pricing catalog | |||
| STATUS |
|
The status of the charge plan (or refill plan) | ||||
| DESCRIPTION |
|
The description of the charge plan |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
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:
|
| 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:
|
| Type | DECIMAL(1), NOT NULL |
DESCRIPTION
| Definition | The description of the charge plan |
| Type | NVARCHAR(2000), NULL |
Primary Key Details
See the primary key information:
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 |