The RATE_PLAN table contains the basic definition of the rate plans
stored in the pricing catalogs of service provider companies that monetize their services.
These basic definitions are completed with the dependent objects information stored
in the following database tables:
| Schema Version | 2023.0.2 | |
| Partitioned | No | |
The RATE_PLAN 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 |
|---|---|---|---|---|---|---|
| OID | PK_RATE_PLAN |
|
The unique identifier of the rate plan. It is generated by the SAP CC Cockpit application. | |||
| NAME | IX_RATE_PLAN_NAME |
|
The name of the rate plan | |||
| CATALOG | IX_RATE_PLAN_CATALOG | CATALOG (NAME)
|
|
The name of the pricing catalog that owns the rate plan | ||
| CC_OID |
|
The unique identifier of the rate plan in the SAP CC Core Server system | ||||
| DESCRIPTION |
|
The description of the rate plan | ||||
| IN_ERROR_STATE |
|
Indicates whether the rate plan is in error or not | ||||
| CHILD_IN_ERROR |
|
The number of sub objects in error in the rate plan | ||||
| IS_LOCKED_BY_ME |
|
This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. | ||||
| LOCKING_USER |
|
The name of the SAP CC user who opened the rate plan in creation or modification | ||||
| OBJECT_CHANGE_NUMBER |
|
The change number of the rate plan | ||||
| RELEASED_OID |
|
The unique identifier of the released rate plan when its is being modified | ||||
| STATE | IX_RATE_PLAN_STATE |
|
The state of the rate plan | |||
| STATUS |
|
The status of the rate plan | ||||
| LAST_CHANGE |
|
The last creation or modification date of the rate plan | ||||
| CURRENCY | CURRENCY (CODE)
|
|
The currency of all amounts calculated by the rate plan. When not specified, the currency is defined by the parameter with the type currency. | |||
| IS_CHARGE_PLAN |
|
Indicates whether the plan is a charge plan or a rate plan | ||||
| UNSAVED_CHANGES |
|
This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. | ||||
| HAS_CURRENCY_PARAMETER |
|
Indicates whether the rate plan has a parameter with the type currency or not | ||||
| PARAMETER_NAME_FOR_CURRENCY |
|
Name of the parameter with the type currency |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the rate plan. It is generated by the SAP CC Cockpit application. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RATE_PLAN |
| Definition | The name of the rate plan |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_RATE_PLAN_NAME |
| Definition | The name of the pricing catalog that owns the rate plan |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_RATE_PLAN_CATALOG |
| Definition | The unique identifier of the rate plan in the SAP CC Core Server system |
| Type | DECIMAL(28), NULL |
| Definition | The description of the rate plan |
| Type | NVARCHAR(2000), NULL |
| Definition | Indicates whether the rate plan is in error or not |
| Format |
The possible values are:
|
| Type | BOOLEAN, NULL |
| Definition | The number of sub objects in error in the rate plan |
| Type | DECIMAL(10), NOT NULL |
| Definition | This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. |
| Type | BOOLEAN, NULL |
| Definition | The name of the SAP CC user who opened the rate plan in creation or modification |
| Type | NVARCHAR(256), NULL |
| Definition | The change number of the rate plan |
| Description |
The change number of the rate plan. Used to detect object desynchronization with the
SAP CC Core Server system.
|
| Type | DECIMAL(28), NULL |
| Definition | The unique identifier of the released rate plan when its is being modified |
| Type | DECIMAL(28), NULL |
| Definition | The state of the rate plan |
| Format |
The possible values are:
|
| Type | DECIMAL(3), NULL |
| Available Index | IX_RATE_PLAN_STATE |
| Definition | The status of the rate plan |
| Format |
The possible values are:
|
| Type | DECIMAL(3), NULL |
| Definition | The last creation or modification date of the rate plan |
| Type | SECONDDATE, NULL |
| Definition | The currency of all amounts calculated by the rate plan. When not specified, the currency is defined by the parameter with the type currency. |
| Type | NVARCHAR(5), NULL |
| Definition | Indicates whether the plan is a charge plan or a rate plan |
| Format |
The possible values are:
|
| Type | BOOLEAN, NULL |
| Definition | This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. |
| Type | BOOLEAN, NULL |
| Definition | Indicates whether the rate plan has a parameter with the type currency or not |
| Format |
The possible values are:
|
| Type | BOOLEAN, NULL |
| Definition | Name of the parameter with the type currency |
| Type | NVARCHAR(256), NULL |
See the primary key information:
| Column(s) | OID |
| Tablespace | COCKPIT_INDX |
The following database indexes are available in the RATE_PLAN database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | NAME |
| Unique | No |
| Partitioned | No |
| Indexed Column(s) | STATE |
| Unique | No |
| Partitioned | No |
| Indexed Column(s) | CATALOG |
| Unique | No |
| Partitioned | No |
