select-option doubts

[Former Member]

Hi experts,

I have four select-options in a selection-screen like s_vbeln for vbak-vbeln,

s_werks for aufm-werks,

s_aufnr for afko-aufnr

S_matnr for resb-matnr

.....

I want to display the values entered in the select-options of the selection-screen on the report.

vbeln and aufnr both are mandatory .rest for things are optional.

If user enters the multiple values in the select-options how do we display all the multiple values on the report.

How to put select quary.

Regards.

Krishna.

[Former Member]

Hi experts,

I have four select-options in a selection-screen like s_vbeln for vbak-vbeln,

s_werks for aufm-werks,

s_aufnr for afko-aufnr

S_matnr for resb-matnr

.....

I want to display the values entered in the select-options of the selection-screen on the report.

vbeln and aufnr both are mandatory .rest for things are optional.

If user enters the multiple values in the select-options how do we display all the multiple values on the report.

How to put select quary.

Regards.

Krishna.

[Former Member]

hi....

whatever entries you make in the select options get stored in an internal table with four options i.e.sign.option,low and high.

so all your values will get stored in this internal table.

the values you want to display can be fecthed from this internal table.

[Former Member]

hii

it is repeated question of the day..

refer to following thread

regards

twinkal

[Former Member]

Hi,

Select-options value get stored in internal table. eg values selected for werks in your program will get stored in table named as s_werks. You can fetch this values from this internal table.

Reward pts. if usefull.

Regards,

Dhan

[Former Member]

Hi,

The row type of a selection table is a structure that consists of four components: SIGN, OPTION, LOW, and HIGH. Each row of a selection table that contains values represents a sub-condition for the complete selection criterion. Description of the individual components:

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.

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

u2013 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:

u2013 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 #.

u2013 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.

u2013 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.

u2013 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.

If the selection table contains more than one row, the system applies the following rules when creating the complete selection criterion:

Form the union of sets defined on the rows that have SIGN field equal to I (inclusion).

Subtract the union of sets defined on the rows that have SIGN field equal to E (exclusion).

If the selection table consists only of rows in which the SIGN field equals E, the system selects all data outside the set specified in the rows.

So u can write loop at statement to show the select-option values on the report.

Hope it helps you.

[Former Member]

This will display all the entries made by the user.

loop at s_vbeln.
  write:/ s_vbeln-low,
          s_vbeln-high.
endloop.