PRICING_FUNCTION_OUTPUT_PROPERTY

Pricing Function Output Property

Definition


The PRICING_FUNCTION_OUTPUT_PROPERTY table contains the definitions of the output properties of the pricing functions

Technical Data


Schema Version 2023.0.2
Segment COCKPIT_DATA
Partitioned No

Summary


The PRICING_FUNCTION_OUTPUT_PROPERTY 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
PRICINGFUNCTION_OID       PRICING_FUNCTION (OID)
 

    The unique identifier of the pricing function that owns the output property
    OID PK_PRICING_FUNCTION_OUTPUT_PROPERTY       

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

        The name of the pricing function output property
        RELEASED_OID        

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

            Indicates whether the pricing function output property is in error or not

            More...

            STATE        

              The state of the pricing function output property

              More...

              DESCRIPTION        

                The description of the pricing function output property
                TYPE        

                  The type of the pricing function output property

                  More...

                  STRING_VALUE        

                    The value of the pricing function output property when it is of type string
                    NUMBER_VALUE        

                      The value of the pricing function output property when it is of type number
                      DATE_VALUE        

                        The value of the pricing function output property when it is of type date

                        Column Details

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

                        PRICINGFUNCTION_OID

                        Definition The unique identifier of the pricing function that owns the output property
                        Type DECIMAL(28), NOT NULL

                        OID

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

                        NAME

                        Definition The name of the pricing function output property
                        Type NVARCHAR(256), NULL

                        RELEASED_OID

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

                        IN_ERROR_STATE

                        Definition Indicates whether the pricing function output property is in error or not
                        Format

                        The possible values are:

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

                        Type NUMERIC(1,0), NULL

                        STATE

                        Definition The state of the pricing function output property
                        Format

                        The possible values are:

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

                        Type DECIMAL(3), NULL

                        DESCRIPTION

                        Definition The description of the pricing function output property
                        Type NVARCHAR(2000), NULL

                        TYPE

                        Definition The type of the pricing function output property
                        Format

                        The possible values are:

                        • 0: number
                        • 1: string
                        • 2: date

                        Type DECIMAL(10), NULL

                        STRING_VALUE

                        Definition The value of the pricing function output property when it is of type string
                        Type NVARCHAR(256), NULL

                        NUMBER_VALUE

                        Definition The value of the pricing function output property when it is of type number
                        Type DECIMAL(28,6), NULL

                        DATE_VALUE

                        Definition The value of the pricing function output property when it is of type date
                        Type DATETIME, NULL

                        Primary Key Details

                        See the primary key information:

                        PK_PRICING_FUNCTION_OUTPUT_PROPERTY

                        Column(s) OID
                        Segment COCKPIT_INDX