CACO
Charging Contracts (in Customer Master Data)
Description
The CACO table contains the definitions of all the charging contracts (charging view of the provider contracts): ID, external ID,
ID of the related subscriber account, ID of the parent contract if any (see ROCO_OID).
These definitions are completed with information stored in the CACO_xx database tables
and in the tables dedicated to
the contract items (see the CACI table).
Important Note
For performances, the counters and allowances belonging to the provider contracts
are stored in dedicated tables and reserved storage spaces.
Refer to the:
Technical Data
| Schema Version |
4.5.13 |
| Segment |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The CACO table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique identifier of the charging contract |
| Description |
The unique identifier of the charging contract. It is generated by the SAP CC system. |
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_CACO |
EXT_ID
| Definition |
The external identifier of the charging contract |
| Description |
The external identifier of the charging contract. It is set by an external provisioning
system at creation time.
|
| Type |
NVARCHAR(256), NOT NULL |
| Available Index |
IX_CACO_EXT_ID |
SUAC_OID
| Definition |
The unique identifier of the subscriber account relating to the charging contract |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_CACO_SUAC |
ROCO_OID
| Definition |
The identifier of the parent contract if the charging contract is linked this charging
contract to share a pool of counters with linked charging contracts that can debit
units
|
| Description |
The identifier of the parent contract if the charging contract is linked this charging
contract to share a pool of counters with linked charging contracts that can debit units.
Note
This ID can be the OID of the contract itself if the contract is a parent contract
or if the charging contract is not linked to a parent contract.
|
| Type |
DECIMAL(28), NULL |
| Available Index |
IX_CACO_ROCO |
OP_STATUS
| Definition |
The operational status of the parent charging contracts |
| Description |
The operational status indicates if you can modify a charging contract and its linked
contracts
and use them in the SAP CC processes.
The value of the operational status for the linked charging contracts is always set
to O but this
value is not used. The linked charging contracts inherit from the operational status
of their
parent charging contract.
|
| Format |
The operational status has one of the following values:
0: active. You can modify the contract and use it in the SAP CC standard processes.
1: locked. The contract is temporarily suspended. You cannot modify this contract.
Processes can no longer use this contract.
2: closed. The contract is permanently locked. You cannot modify this contract or its
operational status. Processes can no longer use this contract.
|
| Type |
DECIMAL(1), NOT NULL |
TECHNICAL_STATUS
| Definition |
The technical status of the charging contract. |
| Description |
The technical status indicates if some technical procedures have been applied to the
contract (for example, the packing procedure).
|
| Format |
This status is an unsigned short int whose each bit is attached to an existing technical
procedure or reserved for a future procedure.
If a bit is set to 1, the related procedure has been applied to the contract; otherwise,
the bit is set to 0.
Each new technical procedure is assigned to a bit from the LSB to the MSB.
For now, only the LSB is used for the PACKING technical procedure on contracts.
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][NOT_USED][PACKING]
|
| Type |
DECIMAL(4), NOT NULL |
| Default |
0 |
PARTITION_ID
| Definition |
The database partition identifier of the subscriber account of the charging contract |
| Type |
DECIMAL(4), NOT NULL |
Primary Key Details
PK_CACO
Index Details
The following database indexes are available in the
CACO database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_CACO_SUAC
| Indexed Column(s) |
SUAC_OID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Segment |
SUBSCRIBER_INDX |
IX_CACO_ROCO
| Indexed Column(s) |
ROCO_OID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Segment |
SUBSCRIBER_INDX |
IX_CACO_EXT_ID
| Indexed Column(s) |
EXT_ID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Segment |
SUBSCRIBER_INDX |
