RESPONSE_ITEM_DEFINITION

Response Item Definition

Definition


The RESPONSE_ITEM_DEFINITION table contains the response item definition of the rate plan

Description


The RESPONSE_ITEM_DEFINITION table contains the response item definition of the rate plan.

The response item definition is composed by a list of charged item definition properties.

Technical Data


Schema Version 2025.0.2
Filegroup COCKPIT_DATA
Partitioned No

Summary


The RESPONSE_ITEM_DEFINITION 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_RESPONSE_ITEM_DEFINITION       

The unique identifier of the response item definition. It is generated by the SAP CC Cockpit application.
IN_ERROR_STATE        

    Indicates whether the response item definition is in error or not

    More...

    CHILD_IN_ERROR        

      Indicates whether the response item definition has fields in error or not

      More...

      NAME     IX_RESPONSE_ITEM_DEFINITION_NAME   

        The name of the charged item class that owns the response item definition
        RELEASED_OID        

          The unique identifier of the released response item definition when it is being modified
          STATE     IX_RESPONSE_ITEM_DEFINITION_STATE   

            The state of the response item definition

            More...

            Column Details

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

            OID

            Definition The unique identifier of the response item definition. It is generated by the SAP CC Cockpit application.
            Type DECIMAL(28), NOT NULL
            Primary Key PK_RESPONSE_ITEM_DEFINITION

            IN_ERROR_STATE

            Definition Indicates whether the response item definition is in error or not
            Format

            The possible values are:

            • 0: No errors
            • 1: One or more errors

            Type BIT, NULL

            CHILD_IN_ERROR

            Definition Indicates whether the response item definition has fields in error or not
            Format

            The possible values are:

            • 0: No fields in error
            • 1: One or more fields in error

            Type DECIMAL(10), NOT NULL

            NAME

            Definition The name of the charged item class that owns the response item definition
            Type NVARCHAR(256), NULL
            Available Index IX_RESPONSE_ITEM_DEFINITION_NAME

            RELEASED_OID

            Definition The unique identifier of the released response item definition when it is being modified
            Type DECIMAL(28), NULL

            STATE

            Definition The state of the response item definition
            Format

            The possible values are:

            • 0: CREATED
            • 1: MODIFIED
            • 2: RELEASED

            Type DECIMAL(3), NULL
            Available Index IX_RESPONSE_ITEM_DEFINITION_STATE

            Primary Key Details

            See the primary key information:

            PK_RESPONSE_ITEM_DEFINITION

            Column(s) OID
            Filegroup COCKPIT_DATA

            Index Details

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

            IX_RESPONSE_ITEM_DEFINITION_NAME

            Indexed Column(s) NAME
            Unique No
            Partitioned No
            Clustered No
            Filegroup COCKPIT_INDX

            IX_RESPONSE_ITEM_DEFINITION_STATE

            Indexed Column(s) STATE
            Unique No
            Partitioned No
            Clustered No
            Filegroup COCKPIT_INDX