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.
| Schema Version | 5.0.6 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
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 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 plan | ||||
| ATTRIBUTES |
|
The attributes which qualify the plan (a set of binary flags). | ||||
| DESCRIPTION |
|
The description of the plan |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the plan. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_CAPA |
| 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 |
| Definition | The type of the plan |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The owner of the plan: the service provider and its pricing catalog |
| Type | NVARCHAR(256), NOT NULL |
| Available Index | IX_CAPA_OWNER |
| Definition | The status of the plan |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The attributes which qualify the plan (a set of binary flags). |
| Description |
The attributes which qualify the plan. Example: SHAREABLE flag indicates if an allowance
plan is shareable.
|
| Format |
This column is an unsigned short int whose each bit is attached to an existing attributes
or reserved for attributes implemented later on (see the bits NOT_USED).
If a bit is set to 1, the plan has the related attribute; otherwise, the bit is set
to 0.
Each new attribute is assigned to a bit from the LSB to the MSB.
For now, only the LSB is used for indicating if an allowance plan is shareable and
or a plan uses shared allowance.
MS Byte: [NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED]
LS Byte: [NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED][NOT_USED][USE_SHARED_ALLOWANCE][SHAREABLE]
|
| Type | DECIMAL(4), NOT NULL |
| Default | 0 |
| Definition | The description of the plan |
| Type | NVARCHAR(2000), NULL |
See the primary key information:
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
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:
| Indexed Column(s) | OWNER |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
| Indexed Column(s) | EXT_ID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | CATALOG_INDX |
