CIT_AGGR_POLICY

Definition


The CIT_AGGR_POLICY table contains the list of charged items aggregation policies which are defined in the SAP CC system

Technical Data


Schema Version 2025.0.0
Tablespace CATALOG_DATA
Partitioned No

Summary


The CIT_AGGR_POLICY 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_CIT_AGGR_POLICY       

    The unique identifier of the charged items aggregation policy

    More...

    CLIENT_NUMBER     IX_CIT_AGGR_POLICY_CODE   

      The client number associated to the charged items aggregation policy
      CODE     IX_CIT_AGGR_POLICY_CODE   

        The unique code of the charged items aggregation policy
        OWNER        

          The owner of the charged items aggregation policy
          DESCRIPTION        

            A description of the charged items aggregation policy
            ITEM_CLASS_CODE        

              The code of the charged item class associated to the charged items aggregation policy
              VERSION_ID        

                The identifier of the version of the charged items aggregation policy

                Column Details

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

                OID

                Definition The unique identifier of the charged items aggregation policy
                Description

                The unique identifier of the charged items aggregation policy. It is generated by the SAP CC system.

                Type DECIMAL(28), NOT NULL
                Primary Key PK_CIT_AGGR_POLICY

                CLIENT_NUMBER

                Definition The client number associated to the charged items aggregation policy
                Type DECIMAL(3), NOT NULL
                Available Index IX_CIT_AGGR_POLICY_CODE

                CODE

                Definition The unique code of the charged items aggregation policy
                Type VARCHAR(256), NOT NULL
                Available Index IX_CIT_AGGR_POLICY_CODE

                OWNER

                Definition The owner of the charged items aggregation policy
                Type VARCHAR(64), NOT NULL

                DESCRIPTION

                Definition A description of the charged items aggregation policy
                Type VARCHAR(2000), NULL

                ITEM_CLASS_CODE

                Definition The code of the charged item class associated to the charged items aggregation policy
                Type VARCHAR(256), NULL

                VERSION_ID

                Definition The identifier of the version of the charged items aggregation policy
                Type DECIMAL(4), NOT NULL

                Primary Key Details

                See the primary key information:

                PK_CIT_AGGR_POLICY

                Column(s) OID
                Tablespace CATALOG_INDX

                Index Details

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

                IX_CIT_AGGR_POLICY_CODE

                Indexed Column(s) CLIENT_NUMBER,CODE
                Unique Yes
                Partitioned No
                Tablespace CATALOG_INDX