PRICING_FUNCTION_INPUT_PROPERTY

Pricing Function Input Property

Definition

The PRICING_FUNCTION_INPUT_PROPERTY table contains the definitions of the input properties of the pricing functions

Technical Data

Schema Version	2023.0.3
Tablespace	COCKPIT_DATA
Partitioned	No

Summary

The PRICING_FUNCTION_INPUT_PROPERTY table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	Uses	Definition
PRICINGFUNCTION_OID		PRICING_FUNCTION (OID)	The unique identifier of the pricing function that owns the input property
OID	PK_PRICING_FUNCTION_INPUT_PROPERTY		The unique identifier of the pricing function input property. It is generated by the SAP CC Cockpit application.
NAME			The name of the pricing function input property
RELEASED_OID			The unique identifier of the released pricing function input property when its is being modified
IN_ERROR_STATE			Indicates whether the pricing function input property is in error or not More...
STATE			The state of the pricing function input property More...
DESCRIPTION			The description of the pricing function input property
TYPE			The type of the pricing function input property More...
SUB_TYPE			The subtype of the pricing function input property More...
SUB_TYPE_INFO			The subtype information of the pricing function input property More...

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

OID

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

NAME

Definition	The name of the pricing function input property
Type	VARCHAR2(256 CHAR), NULL

RELEASED_OID

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

IN_ERROR_STATE

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

Format

The possible values are:

0: No errors
1: One or more errors

Type NUMBER(1,0), NULL

STATE

Definition The state of the pricing function input property

Format

The possible values are:

0: CREATED
1: MODIFIED
2: RELEASED

Type DECIMAL(3), NULL

DESCRIPTION

Definition	The description of the pricing function input property
Type	VARCHAR2(2000 CHAR), NULL

TYPE

Definition The type of the pricing function input property

Format

The possible values are:

0: number
1: string
2: date

Type DECIMAL(10), NULL

SUB_TYPE

Definition The subtype of the pricing function input property

Format

The possible values are:

0: mapping table
1: range table
2: mapping table key

Type DECIMAL(10), NULL

SUB_TYPE_INFO

Definition

The subtype information of the pricing function input property

Format

The possible values are:

The name of the mapping table class if the subtype is mapping table
The name of the range table class if the subtype is range table

Type

VARCHAR2(256 CHAR), NULL

Primary Key Details

See the primary key information:

PK_PRICING_FUNCTION_INPUT_PROPERTY

Column(s)	OID
Tablespace	COCKPIT_INDX