topic Re: SELECTION Screen Problem in Application Development and Automation Discussions

SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:09:29 GMT

Dear All,

I am having the satement in my report as

SELECT-OPTIONS: s_vbeln FOR vbak-vbeln.

Is there any way to store the higher value of the select screen parameter.

Like I am entering 1 and 20 in the select option and i want to store 20 in one variable.

Thanks in Advance

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:13:35 GMT

I believe the easier solution is to get max by a select

SELECT VBELN UP TO 1 ROWS FROM VBAK INTO V_MAX
                         WHERE VBELN IN S_VBELN
                             ORDER BY VBELN DESCENDING.
ENDSELECT.

Max

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:13:44 GMT

hi Manik,

Check the field s_vbeln-high.

If you enter several values.

loop at s_vbeln.

and sort it to get the max/min values.

Erwan

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:14:09 GMT

U canstore the higher value of select option using select-options-high.

Ex.: SELECT-OPTIONS: s_vbeln FOR vbak-vbeln.

data: l_vbeln like vbak-vbeln .(varaible to store high value.)

now write the code:

l_vbeln = s_vbeln-high.

If helpfule...please gve points

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:15:03 GMT

Hi,

You can declare variable, say, v_high type vbeln

and then, store

v_high = s_vbeln-high.

Regards,

Arun Mohan

*Reward points if helpful

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:15:57 GMT

Hi Manik,

S_VBELN-HIGH will store the value 20 and S_VBELN-LOW will store the value 1

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:17:16 GMT

select option is like an internal table with the following structure.

SELECT-OPTIONS: s_vbeln FOR vbak-vbeln.

s_vbeln-low = 1

s_vbeln-high = 20

s_vbeln-option

s_vbeln- sign .

if you just enter 1 and 20 you can get using s_vebln-high if it is not so then you have to loop it and find it out.

Re: SELECTION Screen Problem

Former Member — Mon, 11 Dec 2006 10:29:06 GMT

Try to use parameter-id: AUN

or Create a variable to store in table TVARVC.

Kind Regards

Eswar