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 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The CHAN_OBJECT table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
CHAN_OID PK_CHAN_OBJECT      CHANGE_LIST (OID)
 
 
OID PK_CHAN_OBJECT         
PARENT_OID          
OBJECT_CODE          
OBJECT_TYPE          
SNAPSHOT_OID          

Column Details


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


PK_CHAN_OBJECT

Column(s) CHAN_OID, OID
Filegroup CATALOG_DATA