CAPI
Description
charge plans and refill plans
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.
Technical Data
| Schema Version | 4.5.13 | |
| Partitioned | No | |
Summary
The CAPI table is defined by the following columns. See the column details for more information.
Column Details
OID
| 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 |
CAPA_OID
| Definition | The identifier of the charge plan |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_CAPA_ITM |
ID
| Definition | The identification name of the charge plan item in the charge plan |
| Type | NVARCHAR(256), NOT NULL |
RELATIONSHIP_TYPE
| Definition | The type of relationship with the service provider |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
OPERATION_TYPE
| 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 |
Primary Key Details
PK_CAPI
| Column(s) | OID |
| Tablespace | CATALOG_INDX |
Index Details
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:
IX_CAPA_ITM
| Indexed Column(s) | CAPA_OID |
| Unique | No |
| Partitioned | No |