NODE

Node

Definition

The NODE table contains the definition of the nodes of a pricing tree.

Technical Data

Schema Version	2023.0.3
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

The NODE 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
NODE_OID	PK_NODE		IX_NODE_FTO_FCO_NO			The unique identifier of the node. It is generated by the SAP CC Cockpit back-end application.
CHILD_ORDER						The position of the node amongst the other child nodes of its parent node
MATERIALIZED_PATH						The path to the node from the root of the tree, represented as the unique identifiers of the nodes separated by the '/' character
VERSION						The version of the node
FK_CONTENT_OID			IX_NODE_FTO_FCO_NO			The unique identifier of the node content associated to the node
FK_METADATA_OID			IX_NODE_FPO_FMO			The unique identifier of the node metadata associated to the node
FK_PARENT_OID			IX_NODE_FPOIX_NODE_FPO_FMO			The unique identifier of the parent node of the node
FK_TREE_OID			IX_NODE_FTOIX_NODE_FTO_FCO_NO			The unique identifier of the pricing tree associated to the node

Column Details

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

NODE_OID

Definition	The unique identifier of the node. It is generated by the SAP CC Cockpit back-end application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_NODE
Available Index	IX_NODE_FTO_FCO_NO

CHILD_ORDER

Definition	The position of the node amongst the other child nodes of its parent node
Type	DECIMAL(10), NULL

MATERIALIZED_PATH

Definition	The path to the node from the root of the tree, represented as the unique identifiers of the nodes separated by the '/' character
Type	NVARCHAR(MAX), NULL

VERSION

Definition	The version of the node
Type	DECIMAL(28), NOT NULL

FK_CONTENT_OID

Definition	The unique identifier of the node content associated to the node
Type	DECIMAL(28), NULL
Available Index	IX_NODE_FTO_FCO_NO

FK_METADATA_OID

Definition	The unique identifier of the node metadata associated to the node
Type	DECIMAL(28), NULL
Available Index	IX_NODE_FPO_FMO

FK_PARENT_OID

Definition	The unique identifier of the parent node of the node
Type	DECIMAL(28), NULL
Available Index	IX_NODE_FPO
Available Index	IX_NODE_FPO_FMO

FK_TREE_OID

Definition	The unique identifier of the pricing tree associated to the node
Type	DECIMAL(28), NULL
Available Index	IX_NODE_FTO
Available Index	IX_NODE_FTO_FCO_NO

Primary Key Details

See the primary key information:

PK_NODE

Column(s)	NODE_OID
Filegroup	COCKPIT_DATA

Index Details

The following database indexes are available in the NODE database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_NODE_FTO

Indexed Column(s)	FK_TREE_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX

IX_NODE_FPO

Indexed Column(s)	FK_PARENT_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX

IX_NODE_FPO_FMO

Indexed Column(s)	FK_PARENT_OID,FK_METADATA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX

IX_NODE_FTO_FCO_NO

Indexed Column(s)	FK_TREE_OID,FK_CONTENT_OID,NODE_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX