Table:
PRICE_PLAN
|
Table Name
|
PRICE_PLAN |
| Table Description |
The PRICE_PLAN table contains information about price plans. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The PRICE_PLAN database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
| Key(s) |
Primary Key: PK_PRICE_PLAN |
Foreign K.:
- Foreign table: CHARGE_COMPONENT
- Foreign field(s): OID
|
| Index(es) |
IX_PP_CHRG
|
| Column Description |
The price plan unique id. |
Column: NAME
| Value Type |
VARCHAR(256), NOT NULL |
| Column Description |
The name of the price plan. |
Column: DESCRIPTION
| Value Type |
VARCHAR(256) |
| Column Description |
The description of the price plan. |
Column: CURRENCY_CODE
| Value Type |
VARCHAR(5) |
| Column Description |
The currency code of the price plan. |
Column: CHRG_OID
| Value Type |
BIGINT, NOT NULL |
| Key(s) |
- |
Foreign K.:
- Foreign table: CHARGE_COMPONENT
- Foreign field(s): OID
|
| Index(es) |
IX_PP_CHRG
|
| Column Description |
The ID of the charge component which contains the price plan. |
Column: VALIDATION_DATE
| Value Type |
DATE |
| Column Description |
The date when the price plan becomes valid. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.