About Select-options

[Former Member]

Hi All,

As we know like every select-options will have one internal table with four fields, sign, option, low, high. And my doubt is what are all the possible values we have for the fields sign and option, and pls describe about each, and where we can see these, I heard like we have one structure for this, what is that..?

Akshitha.

[Former Member]

Hi,

You will find all those details in the F1 help of 'SELECT-OPTIONS'.

sign of type c and length 1. The content of sign determines for every row whether the result of the condition formulated in the column is included or excluded in the entire resulting set for all rows. Evaluable values are "I" for include and "E" for exclude.

option of type c and length 2. option contains the selection option for the condition of the row in form of logical operators. Analyzable operators are "EQ", "NE", "GE", "GT", "LE", "LT", "CP" and "NP" if column high is initial, and "BT", "NB" if column high is not initial. With the options "CP" and "NP", the data type of the columns low and high must be of the data type c, and special rules apply for entries on the selection screen.

low of the data type defined after FOR. This column is designated for the comparison value or the lower interval limitation.

high of the data type defined after FOR. This column is designated for the upper interval limitation.

Thanks & Regards,

Jalendhar

[Former Member]

well for options there are

GT greater then

BT between

LT less then

sign can be + or -

plz reward if useful

vivek

[Former Member]

The structure for select options is SELOPT.

[Former Member]

Hi

Sign can take values 'I' or 'E'

Option can take values EQ , NE , GT , LT , LE , GE , CP , NP , BT , NB

Low can take values between 1 to N

High can take values between 1 to N.

If any values are given for low and high then only the range of values between them will be considered.

Suppose LOW = 5 and HIGH = 10, then the values between 5 and 10 are considered

Thanks,

Chinmaye

[Former Member]

Hi akshitha akshitha,

SIGN

The data type of SIGN is C with length 1. The contents of SIGN determine for each row whether the result of the row condition is to be included in or excluded from the resulting set of all rows. Possible values are I and E.

– I stands for "inclusive" (inclusion criterion - operators are not inverted)

– E stands for "exclusive" (exclusion criterion - operators are inverted)

OPTION

The data type of OPTION is C with length 2. OPTION contains the selection operator. The following operators are available:

– If HIGH is empty, you can use EQ, NE, GT, LE, LT,CP, and NP. These operators are the same as those that are used for logical expressions. Yet operators CP and NP do not have the full functional scope they have in normal logical expressions. They are only allowed if wildcards ( '*' or '+' ) are used in the input fields. If wildcards are entered on the selection screen, the system automatically uses the operator CP. The escape character is defined as #.

– If HIGH is filled, you can use BT (BeTween) and NB (Not Between). These operators correspond to BETWEEN and NOT BETWEEN that you use when you check if a field belongs to a range. You cannot use wildcard characters.

LOW

The data type of LOW is the same as the column type of the database table, to which the selection criterion is linked.

– If HIGH is empty, the contents of LOW define a single field comparison. In combination with the operator in OPTION, it specifies a condition for the database selection.

– If HIGH is filled, the contents of LOW and HIGH specify the upper and lower limits for a range. In combination with the operator in OPTION, the range specifies a condition for the database selection.

HIGH

The data type of HIGH is the same as the column type of the database table, to which the selection criterion is linked. The contents of HIGH specify the upper limit for a range selection.

Note: You can see that things in debugging

Regards,

Mahi.