PRICING_FUNCTION_COUNTER

Pricing Function Counter

Definition


The PRICING_FUNCTION_COUNTER table contains the definitions of the counters of the pricing functions

Technical Data


Schema Version 2023.0.2
Partitioned No

Summary


The PRICING_FUNCTION_COUNTER 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 counter
    OID PK_PRICING_FUNCTION_COUNTER       

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

        The name of the pricing function counter
        RELEASED_OID        

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

            Indicates whether the pricing function counter is in error or not

            More...

            STATE        

              The state of the pricing function counter

              More...

              DESCRIPTION        

                The description of the pricing function counter

                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 counter
                Type DECIMAL(28), NOT NULL

                OID

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

                NAME

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

                RELEASED_OID

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

                IN_ERROR_STATE

                Definition Indicates whether the pricing function counter 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 counter
                Format

                The possible values are:

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

                Type DECIMAL(3), NULL

                DESCRIPTION

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

                Primary Key Details

                See the primary key information:

                PK_PRICING_FUNCTION_COUNTER

                Column(s) OID
                Tablespace COCKPIT_INDX