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
Tablespace CATALOG_DATA
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 PK FK IX Uses Used by 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
              Tablespace CATALOG_INDX