The PRICING_FUNCTION table contains the basic definition of the pricing functions
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 | |
| Segment | COCKPIT_DATA | |
| Partitioned | No | |
The PRICING_FUNCTION 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_PRICING_FUNCTION |
|
The unique identifier of the pricing function. It is generated by the SAP CC Cockpit application. | |||
| NAME | IX_PRICING_FUNCTION_NAME |
|
The name of the pricing function | |||
| RELEASED_OID |
|
The unique identifier of the released pricing function when its is being modified | ||||
| IN_ERROR_STATE |
|
Indicates whether the pricing function is in error or not | ||||
| STATE | IX_PRICING_FUNCTION_STATE |
|
The state of the pricing function | |||
| LOCKING_USER |
|
The name of the SAP CC user who opened the pricing function in creation or modification | ||||
| IS_LOCKED_BY_ME |
|
This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. | ||||
| DESCRIPTION |
|
The description of the pricing function | ||||
| CC_OID |
|
The unique identifier of the pricing function in the SAP CC Core Server system | ||||
| OBJECT_CHANGE_NUMBER |
|
The change number of the pricing function | ||||
| CATALOG | IX_PRICING_FUNCTION_CATALOG | CATALOG (NAME)
|
|
The name of the pricing catalog that owns the pricing function | ||
| UNSAVED_CHANGES |
|
This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. | ||||
| LAST_CHANGE |
|
The last creation or modification date of the pricing function | ||||
| CHILD_IN_ERROR |
|
The number of sub objects in error in the pricing function | ||||
| IS_PRICING_MACRO |
|
Indicates whether the object is a pricing function or a pricing macro | ||||
| TREE_OID | PRICING_FUNCTION_TREE (OID)
|
|
The unique identifier of the pricing tree of the pricing function. It is generated by the SAP CC Cockpit application. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the pricing function. It is generated by the SAP CC Cockpit application. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_PRICING_FUNCTION |
| Definition | The name of the pricing function |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_PRICING_FUNCTION_NAME |
| Definition | The unique identifier of the released pricing function when its is being modified |
| Type | DECIMAL(28), NULL |
| Definition | Indicates whether the pricing function is in error or not |
| Format |
The possible values are:
|
| Type | NUMERIC(1,0), NULL |
| Definition | The state of the pricing function |
| Format |
The possible values are:
|
| Type | DECIMAL(3), NULL |
| Available Index | IX_PRICING_FUNCTION_STATE |
| Definition | The name of the SAP CC user who opened the pricing function in creation or modification |
| Type | NVARCHAR(256), NULL |
| Definition | This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. |
| Type | NUMERIC(1,0), NULL |
| Definition | The description of the pricing function |
| Type | NVARCHAR(2000), NULL |
| Definition | The unique identifier of the pricing function in the SAP CC Core Server system |
| Type | DECIMAL(28), NULL |
| Definition | The change number of the pricing function |
| Description |
The change number of the pricing function. Used to detect object desynchronization
with the SAP CC Core Server system.
|
| Type | DECIMAL(28), NULL |
| Definition | The name of the pricing catalog that owns the pricing function |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_PRICING_FUNCTION_CATALOG |
| Definition | This value is never stored in database. It is computed by the SAP CC Cockpit back-end application. |
| Type | NUMERIC(1,0), NULL |
| Definition | The last creation or modification date of the pricing function |
| Type | DATETIME, NULL |
| Definition | The number of sub objects in error in the pricing function |
| Type | DECIMAL(10), NOT NULL |
| Definition | Indicates whether the object is a pricing function or a pricing macro |
| Format |
The possible values are:
|
| Type | NUMERIC(1,0), NULL |
| Definition | The unique identifier of the pricing tree of the pricing function. It is generated by the SAP CC Cockpit application. |
| Type | DECIMAL(28), NULL |
See the primary key information:
| Column(s) | OID |
| Segment | COCKPIT_INDX |
The following database indexes are available in the PRICING_FUNCTION 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 |
| Clustered | No |
| Segment | COCKPIT_INDX |
| Indexed Column(s) | STATE |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Segment | COCKPIT_INDX |
| Indexed Column(s) | CATALOG |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Segment | COCKPIT_INDX |
