PRICING_FUNCTION_TREE

Pricing Function Tree

Definition


The PRICING_FUNCTION_TREE table contains the definition of the pricing trees of the pricing functions

Technical Data


Schema Version 2023.0.2
Tablespace COCKPIT_DATA
Partitioned No

Summary


The PRICING_FUNCTION_TREE 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_TREE       

The unique identifier of the pricing function tree. It is generated by the SAP CC Cockpit application.
NAME        

    The name of the pricing function tree
    RELEASED_OID        

      The unique identifier of the released pricing function tree when its is being modified
      IN_ERROR_STATE        

        Indicates whether the pricing tree of the pricing function is in error or not

        More...

        STATE        

          The state of the pricing function tree

          More...

          CHILD_IN_ERROR        

            The number of components in error in the pricing function tree

            Column Details

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

            OID

            Definition The unique identifier of the pricing function tree. It is generated by the SAP CC Cockpit application.
            Type DECIMAL(28), NOT NULL
            Primary Key PK_PRICING_FUNCTION_TREE

            NAME

            Definition The name of the pricing function tree
            Type VARCHAR(256), NULL

            RELEASED_OID

            Definition The unique identifier of the released pricing function tree when its is being modified
            Type DECIMAL(28), NULL

            IN_ERROR_STATE

            Definition Indicates whether the pricing tree of the pricing function is in error or not
            Format

            The possible values are:

            • 0: No errors
            • 1: One or more errors

            Type BOOLEAN, NULL

            STATE

            Definition The state of the pricing function tree
            Format

            The possible values are:

            • 0: CREATED
            • 1: MODIFIED
            • 2: RELEASED

            Type DECIMAL(3), NULL

            CHILD_IN_ERROR

            Definition The number of components in error in the pricing function tree
            Type DECIMAL(10), NOT NULL

            Primary Key Details

            See the primary key information:

            PK_PRICING_FUNCTION_TREE

            Column(s) OID
            Tablespace COCKPIT_INDX