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 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The CAPI_CHARGE_COMPONENT_REF table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
CAPI_OID     IX_CAPA_CCR  CAPI (OID)
 
 
CHRG_OID          
DEPENDENT          
DEPENDENT_ROLE          
ADJUSTMENT_MODE          
USE_PREVIOUS_DISCOUNTED_AMOUNT          

Column Details


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
Filegroup CATALOG_INDX