Table: PROPERTY_DESCRIPTION

Table Name PROPERTY_DESCRIPTION
Table Description The PROPERTY_DESCRIPTION table describes the properties of a chargeable item.
Tablespace CATALOG_DATA
Database Core Database
Columns
NAME
INDEX_IN_ITEM
VALUE_TYPE
DESCRIPTION
ITEM_OID

Columns of the Table

The PROPERTY_DESCRIPTION database table is defined by the following columns.

Column: NAME

Value Type VARCHAR(256), NOT NULL
Column Description The name of the property. It must be unique for a chargeable item.


Column: INDEX_IN_ITEM

Value Type DECIMAL(3), NOT NULL
Column Description The position of the property in the item.


Column: VALUE_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description

The type of the property.

Possible values are:

  • 0: number
  • 1: string
  • 2: date



Column: DESCRIPTION

Value Type VARCHAR(2000)
Column Description The description of the property.


Column: ITEM_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: CI_DESCRIPTION
  • Foreign field(s): OID

Index(es) IX_PROPERTY_DESCRIPTION
Column Description The OID of the chargeable item having this property.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.