CACO

Charging Contracts (in Customer Master Data)

Definition

The CACO table contains the definitions of all the charging contracts (charging view of the provider contracts) associated to a subscriber account

Description

The CACO database table stores the definitions for all the charging contracts (charging view of the provider contracts):

ID
External ID that is visible in the user interfaces
ID of the related subscriber account
ID of the parent contract if any (see ROCO_OID)

Each contract data belongs to an end customer for the service provider and its marketable services.

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 (tablespaces, filegroups).

Refer to the:

Technical Data

Schema Version	5.0.6
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The CACO table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Uses	Used by	Definition
OID	PK_CACO			COUNTER_SNAPSHOT (SNAPSHOT_SUB_OID) COAC (CACO_OID) CACO (ROCO_OID) CACO_ADDITIONAL_INFO (CACO_OID) CACO_SHARED_COUNTER (CACO_OID) CACI (CACO_OID) ALLO (CACO_OID) SHAL (CACO_OID)	The unique identifier of the charging contract More...
EXT_ID		IX_CACO_EXT_ID			The external identifier of the charging contract More...
SUAC_OID		IX_CACO_SUAC	SUBSCRIBER_ACCOUNT (OID)		The unique identifier of the subscriber account relating to the charging contract for a specific service provider
ROCO_OID		IX_CACO_ROCO	CACO (OID)		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 More...
OP_STATUS					The operational status of the parent charging contracts More...
TECHNICAL_STATUS					The technical status of the charging contract. More...
PARTITION_ID			SUBSCRIBER_ACCOUNT (PARTITION_ID)		The database partition identifier of the subscriber account of the charging contract

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

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 includes a custom value set by an external provisioning system at creation time when configuring the customer master data in SAP CC.
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 for a specific service provider
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

See the primary key information:

PK_CACO

Column(s)	OID
Segment	SUBSCRIBER_INDX

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

IX_CACO_ROCO

Indexed Column(s)	ROCO_OID
Unique	No
Partitioned	No
Clustered	No

IX_CACO_EXT_ID

Indexed Column(s)	EXT_ID
Unique	No
Partitioned	No
Clustered	No