CHARGING_PROPERTY

Charging Property

Definition

The CHARGING_PROPERTY table contains the charging properties entered by the user or generated when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

Description

A charging property belongs to a chargeable item, a charged item, or a charging notification.

See also the following database tables: CHARGEABLE_ITEM, CHARGED_ITEM, CHARGING_NOTIFICATION.

Technical Data

Schema Version	2023.0.2
Tablespace	COCKPIT_DATA
Partitioned	No

Summary

The CHARGING_PROPERTY table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	Uses	Definition
OID	PK_CHARGING_PROPERTY		The unique identifier of the charging property. It is generated by the SAP CC Cockpit application.
DTYPE			Indicates if the charging property belongs to the chargeable item, a charged item or a notification More...
DATE_VALUE			The value of the charging property when it is a date
NAME			The name of the charging property
NUMBER_VALUE			The value of the charging property when it is a number
STRING_VALUE			The value of the charging property when it is a string
TYPE			The type of the charging property More...
DESCRIPTION			The description of the charging property
BOOLEAN_VALUE			The value of the charging property when it is a boolean
CHARGEABLEITEM_OID		CHARGEABLE_ITEM (OID)	The unique identifier of the chargeable item that owns the charging property, when it is owned by a chargeable item
CHARGEDITEM_OID		CHARGED_ITEM (OID)	The unique identifier of the charged item that owns the charging property, when it is owned by a charged item
NOTIFICATION_OID			The unique identifier of the charging notification that owns the charging property, when it is owned by a charging notification

Column Details

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

OID

Definition	The unique identifier of the charging property. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CHARGING_PROPERTY

DTYPE

Definition Indicates if the charging property belongs to the chargeable item, a charged item or a notification

Format

The possible values are:

CHARGEABLEITEMPROPERTY: Property of the chargeable item
CHARGEDITEMPROPERTY: Property of a charged item
NOTIFICATIONPROPERTY: Property of a notification

Type VARCHAR(31), NOT NULL

DATE_VALUE

Definition	The value of the charging property when it is a date
Type	TIMESTAMP, NULL

NAME

Definition	The name of the charging property
Type	VARCHAR(256), NOT NULL

NUMBER_VALUE

Definition	The value of the charging property when it is a number
Type	DECIMAL(28,6), NULL

STRING_VALUE

Definition	The value of the charging property when it is a string
Type	VARCHAR(2000), NULL

TYPE

Definition The type of the charging property

Format

The possible values are:

0: Number
1: String
2: Date
3: Boolean

Type DECIMAL(10), NULL

DESCRIPTION

Definition	The description of the charging property
Type	VARCHAR(2000), NULL

BOOLEAN_VALUE

Definition	The value of the charging property when it is a boolean
Type	BOOLEAN, NULL

CHARGEABLEITEM_OID

Definition	The unique identifier of the chargeable item that owns the charging property, when it is owned by a chargeable item
Type	DECIMAL(28), NULL

CHARGEDITEM_OID

Definition	The unique identifier of the charged item that owns the charging property, when it is owned by a charged item
Type	DECIMAL(28), NULL

NOTIFICATION_OID

Definition	The unique identifier of the charging notification that owns the charging property, when it is owned by a charging notification
Type	DECIMAL(28), NULL

Primary Key Details

See the primary key information:

PK_CHARGING_PROPERTY

Column(s)	OID
Tablespace	COCKPIT_INDX