CAPI_CHARGE_COMPONENT_REF

Definition

The CAPI_CHARGE_COMPONENT_REF table contains customization parameters applied to the charge component referenced by the charge plan item

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

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

Name	IX	Uses	Definition
CAPI_OID	IX_CAPA_CCR	CAPI (OID)	The identifier of the charge plan item
CHRG_OID			The unique identifier of the referred charge component
DEPENDENT			This field indicates whether the referred charge component is dependent or master More...
DEPENDENT_ROLE			The role for a dependent charge component More...
ADJUSTMENT_MODE			This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge More...
USE_PREVIOUS_DISCOUNTED_AMOUNT			This field indicates if a discount must be applied to the amount of the master charge from which the previous discounts have already been subtracted More...

Column Details

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

CAPI_OID

Definition	The identifier of the charge plan item
Type	DECIMAL(28), NOT NULL
Available Index	IX_CAPA_CCR

CHRG_OID

Definition	The unique identifier of the referred charge component
Type	DECIMAL(28), NOT NULL

DEPENDENT

Definition This field indicates whether the referred charge component is dependent or master

Format

The possible values are:

0: The referred charge component is master.
1: The referred charge component is dependent.

Type DECIMAL(1), NOT NULL

DEPENDENT_ROLE

Definition The role for a dependent charge component

Format

The possible values are:

0: partnerCommission (corresponding to the Commission role in the SAP CC Core Tool user interface)
1: commission (corresponding to the Third party billed comission role in Core Tool)
2: sponsorship
3: discount
4: other

Type DECIMAL(1), NULL

ADJUSTMENT_MODE

Definition	This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge
Description	This field indicates if a new transaction is created for the dependent charge and if the transaction corresponding to the master charge is modified (or adjusted) according to the dependent charge. Used only if the charge is dependent.
Format	The possible values are: `0`: no adjustment. A transaction is created for the dependent charge and the master transaction is not modified. `1`: merging. No transaction is created for the dependent charge but the master transaction is modified to take the dependent amount into account. `2`: splitting. The master transaction is split into two transactions: one corresponding to the dependent charge and a master one modified according to the dependent charge. Note Transaction adjustment depends on the role of the dependent charge (see the DEPENDENT_ROLE field). The 3 modes are not always available.
Type	DECIMAL(1), NULL

USE_PREVIOUS_DISCOUNTED_AMOUNT

Definition This field indicates if a discount must be applied to the amount of the master charge from which the previous discounts have already been subtracted

Format

The possible values are:

0: Apply the discount on the initial amount of the master charge.
1: Apply the discount on the previously discounted amount.

Type DECIMAL(1), NULL

Index Details

The following database indexes are available in the CAPI_CHARGE_COMPONENT_REF database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_CAPA_CCR

Indexed Column(s)	CAPI_OID
Unique	Yes
Partitioned	No
Clustered	No