CHARGED_ITEM_MAPPING

Definition


The CHARGED_ITEM_MAPPING table contains the link between the charged item class and the Offer charged item mapping

Description


The CHARGED_ITEM_MAPPING table contains the link between the charged item class and the Offer charged item mapping managed by SAP Convergent Charging.

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The CHARGED_ITEM_MAPPING 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
OID PK_CHARGED_ITEM_MAPPING       

The charged item mapping unique ID

More...

CCON_OID     IX_CITM_CCON_OID  CHARGE_CONDITION (OID)
 

    The ID of the charge condition
    CITC_CODE        

      The code of the charged item class
      CITA_CODE        

        The code of the charged items aggregation policy associated to the charge plan item

        More...

        Column Details

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

        OID

        Definition The charged item mapping unique ID
        Description

        The charged item mapping unique ID. It is generated by the SAP CC system.

        Type DECIMAL(28), NOT NULL
        Primary Key PK_CHARGED_ITEM_MAPPING

        CCON_OID

        Definition The ID of the charge condition
        Type DECIMAL(28), NOT NULL
        Available Index IX_CITM_CCON_OID

        CITC_CODE

        Definition The code of the charged item class
        Type NVARCHAR(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 NVARCHAR(256), NULL

        Primary Key Details

        See the primary key information:

        PK_CHARGED_ITEM_MAPPING

        Column(s) OID
        Tablespace CATALOG_INDX

        Index Details

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

        IX_CITM_CCON_OID

        Indexed Column(s) CCON_OID
        Unique No
        Partitioned No