EXPORTABLE_ITEM_MAPPING

Exportable Item Mapping (in Business and Custom Data)

Definition


The EXPORTABLE_ITEM_MAPPING table contains basic information about the exportable item mapping

Description


The EXPORTABLE_ITEM_MAPPING table contains basic information about the exportable item mapping (code, classId, externalSystemCode) managed by SAP Convergent Charging.

Technical Data


Schema Version 2025.0.0
Partitioned No

Summary


The EXPORTABLE_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_EXPORTABLE_ITEM_MAPPING       

The exportable item mapping unique ID

More...

CLIENT_NUMBER        

    The client number associated to the exportable item mapping
    CODE        

      The code of the exportable item mapping
      CLASS_ID        

        The code/id of the mapped class
        TYPE        

          The type of the mapping

          More...

          EXTERNAL_SYSTEM_CODE        

            The code of the external system

            Column Details

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

            OID

            Definition The exportable item mapping unique ID
            Description

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

            Type DECIMAL(28), NOT NULL
            Primary Key PK_EXPORTABLE_ITEM_MAPPING

            CLIENT_NUMBER

            Definition The client number associated to the exportable item mapping
            Type DECIMAL(3), NULL

            CODE

            Definition The code of the exportable item mapping
            Type NVARCHAR(256), NULL

            CLASS_ID

            Definition The code/id of the mapped class
            Type NVARCHAR(256), NULL

            TYPE

            Definition The type of the mapping
            Format

            The possible values are:

            • 1: charged item class. This mapping refers to a charged item class.
            • 2: refill record class. This mapping refers to a refill record class.
            • 3: chargeable item class. This mapping refers to a chargeable item class.

            Type DECIMAL(2), NOT NULL

            EXTERNAL_SYSTEM_CODE

            Definition The code of the external system
            Type NVARCHAR(256), NOT NULL

            Primary Key Details

            See the primary key information:

            PK_EXPORTABLE_ITEM_MAPPING

            Column(s) OID
            Tablespace CATALOG_INDX