The CAPI table contains the basic definitions of the items of the charge plans and refill plans stored in the pricing catalog of a service provider.
These definitions are completed with information stored in the CAPI_xx database tables
( CAPI_CHARGE_COMPONENT_REF, ...).
Note For compatibility reasons, the name of this table remains unchanged even if the table
concerns also the refill items used in the SAP CC system.
| Schema Version | 5.0.6 | |
| Partitioned | No | |
The CAPI 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_CAPI |
|
The unique identifier of the charge plan item | |||
| CAPA_OID | IX_CAPA_ITM | CAPA (OID)
|
|
The identifier of the charge plan | ||
| ID |
|
The identification name of the charge plan item in the charge plan | ||||
| RELATIONSHIP_TYPE |
|
The type of relationship with the service provider | ||||
| OPERATION_TYPE |
|
This field indicates whether the account of the client or the partner involved will be credited or debited |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the charge plan item |
| Description |
The unique identifier of the charge plan item. It is generated by the SAP CC system.
|
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_CAPI |
| Definition | The identifier of the charge plan |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_CAPA_ITM |
| Definition | The identification name of the charge plan item in the charge plan |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The type of relationship with the service provider |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | This field indicates whether the account of the client or the partner involved will be credited or debited |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
See the primary key information:
| Column(s) | OID |
| Segment | CATALOG_INDX |
The following database indexes are available in the CAPI database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | CAPA_OID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
