NODE_CONTENT

Node Content

Definition


The NODE_CONTENT table contains the configuration of the nodes of a pricing tree.

Description


For a given type of node, not all columns are used, and may contain null values instead.

Technical Data


Schema Version 2023.0.2
Tablespace COCKPIT_DATA
Partitioned No

Summary


The NODE_CONTENT 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
SUB_TYPE        

    The type of the node content
    NODE_CONTENT_OID PK_NODE_CONTENT       

      The unique identifier of the node content. It is generated by the SAP CC Cockpit back-end application.
      OPERATOR        

        The operator to apply
        MESSAGE        

          The message
          DECIMAL_COUNT        

            The number of decimal places
            ROUNDING_MODE        

              The rounding mode
              TABLE_CLASS        

                The name of the table class to the node content
                LONGEST_PREFIX_MATCH_INDEX        

                  The index of the column to use for longest prefix matching
                  INPUT_COLUMN_COUNT        

                    The number of input columns
                    SEPARATOR        

                      The separator for string values
                      TRANSFORMATION        

                        The transformation to apply
                        DECIMAL_SEPARATOR        

                          The decimal separator for number values
                          THOUSAND_SEPARATOR        

                            The thousand separator for number values
                            DATE_FORMAT        

                              The date format to use
                              DATE_FIELD        

                                The date field to use
                                LAST_RANGE_BOUNDED        

                                  Whether the last range is bounded
                                  SOURCE_UNIT        

                                    The source unit of time
                                    TIME_UNIT        

                                      The computed unit of time
                                      ROUNDING_UNIT        

                                        The unit for rounding
                                        DAY_OF_WEEK_CONFIGURATION        

                                          The day of week configuration
                                          DAY_OF_MONTH_CONFIGURATION        

                                            The day of month configuration
                                            MONTH_CONFIGURATION        

                                              The month configuration
                                              YEAR_CONFIGURATION        

                                                The year configuration
                                                DAY_OF_WEEK        

                                                  The day of week value
                                                  DAY_OF_MONTH        

                                                    The day of month value
                                                    MONTH        

                                                      The month value
                                                      YEAR        

                                                        The year value
                                                        EVENT_CLASS        

                                                          The name of the event class associated to the node content
                                                          PLAN        

                                                            The name of the object associated to the node content

                                                            Column Details

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

                                                            SUB_TYPE

                                                            Definition The type of the node content
                                                            Type VARCHAR(50), NOT NULL

                                                            NODE_CONTENT_OID

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

                                                            OPERATOR

                                                            Definition The operator to apply
                                                            Type DECIMAL(10), NULL

                                                            MESSAGE

                                                            Definition The message
                                                            Type VARCHAR(2000), NULL

                                                            DECIMAL_COUNT

                                                            Definition The number of decimal places
                                                            Type DECIMAL(10), NULL

                                                            ROUNDING_MODE

                                                            Definition The rounding mode
                                                            Type DECIMAL(10), NULL

                                                            TABLE_CLASS

                                                            Definition The name of the table class to the node content
                                                            Type VARCHAR(256), NULL

                                                            LONGEST_PREFIX_MATCH_INDEX

                                                            Definition The index of the column to use for longest prefix matching
                                                            Type DECIMAL(10), NULL

                                                            INPUT_COLUMN_COUNT

                                                            Definition The number of input columns
                                                            Type DECIMAL(10), NULL

                                                            SEPARATOR

                                                            Definition The separator for string values
                                                            Type VARCHAR(2000), NULL

                                                            TRANSFORMATION

                                                            Definition The transformation to apply
                                                            Type DECIMAL(10), NULL

                                                            DECIMAL_SEPARATOR

                                                            Definition The decimal separator for number values
                                                            Type VARCHAR(2000), NULL

                                                            THOUSAND_SEPARATOR

                                                            Definition The thousand separator for number values
                                                            Type VARCHAR(2000), NULL

                                                            DATE_FORMAT

                                                            Definition The date format to use
                                                            Type VARCHAR(2000), NULL

                                                            DATE_FIELD

                                                            Definition The date field to use
                                                            Type DECIMAL(10), NULL

                                                            LAST_RANGE_BOUNDED

                                                            Definition Whether the last range is bounded
                                                            Type BOOLEAN, NULL

                                                            SOURCE_UNIT

                                                            Definition The source unit of time
                                                            Type DECIMAL(10), NULL

                                                            TIME_UNIT

                                                            Definition The computed unit of time
                                                            Type DECIMAL(10), NULL

                                                            ROUNDING_UNIT

                                                            Definition The unit for rounding
                                                            Type DECIMAL(10), NULL

                                                            DAY_OF_WEEK_CONFIGURATION

                                                            Definition The day of week configuration
                                                            Type DECIMAL(10), NULL

                                                            DAY_OF_MONTH_CONFIGURATION

                                                            Definition The day of month configuration
                                                            Type DECIMAL(10), NULL

                                                            MONTH_CONFIGURATION

                                                            Definition The month configuration
                                                            Type DECIMAL(10), NULL

                                                            YEAR_CONFIGURATION

                                                            Definition The year configuration
                                                            Type DECIMAL(10), NULL

                                                            DAY_OF_WEEK

                                                            Definition The day of week value
                                                            Type DECIMAL(10), NULL

                                                            DAY_OF_MONTH

                                                            Definition The day of month value
                                                            Type DECIMAL(10), NULL

                                                            MONTH

                                                            Definition The month value
                                                            Type DECIMAL(10), NULL

                                                            YEAR

                                                            Definition The year value
                                                            Type DECIMAL(10), NULL

                                                            EVENT_CLASS

                                                            Definition The name of the event class associated to the node content
                                                            Type VARCHAR(256), NULL

                                                            PLAN

                                                            Definition The name of the object associated to the node content
                                                            Type VARCHAR(256), NULL

                                                            Primary Key Details

                                                            See the primary key information:

                                                            PK_NODE_CONTENT

                                                            Column(s) NODE_CONTENT_OID
                                                            Tablespace COCKPIT_INDX