CAPI_CHARGED_ITEM_MAPPING

Definition


The CAPI_CHARGED_ITEM_MAPPING table contains the link between the charged item class and the charged item mapping inside a charge plan item.

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
OID PK_CAPI_CHARGED_ITEM_MAPPING        CAPI_CITM_ENTRY (CITM_OID)
 
CAPI_OID     IX_CAPI_CITM_CAPI_OID  CAPI (OID)
 
 
CITC_CODE          
CITA_CODE          
REPORTING_SCOPE          
TYPE          

Column Details


OID

Definition The identifier of the charged item mapping; it is generated by the system.
Type DECIMAL(28), NOT NULL
Primary Key PK_CAPI_CHARGED_ITEM_MAPPING

CAPI_OID

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

CITC_CODE

Definition The code of the charged item class
Type VARCHAR(256), NULL

CITA_CODE

Definition The code of the charged items aggregation policy associated to the charge plan item
Description The code of the charged items aggregation policy associated to the charge plan item. The null value indicates that no aggregation is defined.
Type VARCHAR(256), NULL

REPORTING_SCOPE

Definition Specifies the reporting mode to use during the aggregation of charged items within session-based charging operations. When using the "Charged Item" reporting mode, a reporting condition fulfilled for a charged item triggers the reporting of the related charged item only. When using the "Session" reporting mode, a reporting condition fulfilled for a charged item triggers the reporting of all the charged items of the session. This field is only relevant for charge plan items related to master charge components.
Format

The possible values are:

  • 0: Charged Item
  • 1: Session

Type DECIMAL(1), NOT NULL

TYPE

Definition The type of the charged item mapping
Format

The possible values are:

  • 0: output mapping
  • 1: response mapping

Type DECIMAL(1), NOT NULL

Primary Key Details


PK_CAPI_CHARGED_ITEM_MAPPING

Column(s) OID
Tablespace CATALOG_INDX

Index Details


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

IX_CAPI_CITM_CAPI_OID

Indexed Column(s) CAPI_OID
Unique No
Partitioned No
Tablespace CATALOG_INDX