CHAN_OBJECT

Definition


The CHAN_OBJECT table contains the list of objects contained in the change lists defined in the SAP CC system

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The CHAN_OBJECT 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
CHAN_OID PK_CHAN_OBJECT      CHANGE_LIST (OID)
 

    The unique identifier of the related change list
    OID PK_CHAN_OBJECT       

      The unique identifier of the object in the change list
      PARENT_OID        

        The unique identifier of the parent of the object in the change list. It is equals to -1 if the object does not have a parent.
        OBJECT_CODE        

          The code of the object
          OBJECT_TYPE        

            The type of the object

            More...

            SNAPSHOT_OID        

              The unique identifier of the snapshot of the object

              Column Details

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

              CHAN_OID

              Definition The unique identifier of the related change list
              Type DECIMAL(28), NOT NULL
              Primary Key PK_CHAN_OBJECT

              OID

              Definition The unique identifier of the object in the change list
              Type DECIMAL(5), NOT NULL
              Primary Key PK_CHAN_OBJECT

              PARENT_OID

              Definition The unique identifier of the parent of the object in the change list. It is equals to -1 if the object does not have a parent.
              Type DECIMAL(5), NULL

              OBJECT_CODE

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

              OBJECT_TYPE

              Definition The type of the object
              Format

              The possible values are:

              • 0: Pricing Macro
              • 1: Translation Table
              • 2: Tier Table
              • 3: Mapping Table Class
              • 4: Mapping Table
              • 5: Range Table Class
              • 6: Range Table
              • 7: Product
              • 8: Offer
              • 9: Chargeable Item Class
              • 10: Charged Item Class
              • 11: Charge Component
              • 12: Charge Plan
              • 13: Refill Item Class
              • 14: Refill Record Class
              • 15: Refill Logic
              • 16: Refill Plan
              • 17: Charged Item Mapping
              • 18: Refill Record Mapping
              • 19: Chargeable Item Mapping
              • 25: Counter Names Dictionary
              • 32: Charged Item Aggregation Policy
              • 33: Allowance Plan
              • 34: Allowance Logic
              • 35: Allowance Interface
              • 36: Allowance Event Class
              • 37: Spending Status Description
              • 38: Monitoring Plan

              Type DECIMAL(5), NOT NULL

              SNAPSHOT_OID

              Definition The unique identifier of the snapshot of the object
              Type DECIMAL(5), NOT NULL

              Primary Key Details

              See the primary key information:

              PK_CHAN_OBJECT

              Column(s) CHAN_OID, OID
              Segment CATALOG_INDX