topic Re: select option in Application Development and Automation Discussions

select option

Former Member — Mon, 30 Jul 2007 15:38:50 GMT

i have select option s_tanum

i need to make check if the tanum is in LTAP if not to give message

how??

i made it but not

select tanum

from ltap

into ztanum

where tanum in s_tanum.

if sy-subrc <> 0.

write : / s_tanum-low.

endif.

endselect.

Re: select option

Former Member — Mon, 30 Jul 2007 15:44:22 GMT

this code selects tanum from ltap into ztanum, for all the values of tanum specified in the selection screen.

if it happens u need to print the lower value of select-options from tanum.

if you want to know if tanum is present in ltap...

select * from ltap where tanum in s_tanum.

if sy-subrc ne 0.

message e000 with 'tanum not in ltap'.

endif.

regards,

srinivas

<b>*reward for useful answers*</b>

Re: select option

Former Member — Mon, 30 Jul 2007 15:45:17 GMT

write it under at selection-screen event.,

tables : ltap.

select single * from ltap where tanum in s_tanum.

if sy-subrc ne 0.

message e000 with 'Enter Valid Tanum'.

endif.

Thansk

mahesh

Re: select option

Former Member — Mon, 30 Jul 2007 15:48:16 GMT

if i enter from 1 to 10 and 9 is not correct how i will get the err

Re: select option

Former Member — Mon, 30 Jul 2007 15:49:37 GMT

if i enter from 1 to 10 and 9 is not correct how i will get the err

Re: select option

Former Member — Mon, 30 Jul 2007 15:51:39 GMT

hi,

wat do you mean by 9 is not correct???

its inside the range 1 to 10....isn't it??

Re: select option

Former Member — Mon, 30 Jul 2007 15:52:38 GMT

it inside the range but 9 is <b>not exist</b> in ltap

Re: select option

Former Member — Mon, 30 Jul 2007 15:55:16 GMT

Ok normally validation at selection screen is done.. if the program finds one valid value then it will consider that one value and proceed further. How ever the values which are wrong will be skipped in the further processing ..

And also remember its not always 1-10 or 1-100.. it can be some thing like 1-10 and 20-70 and exclude 50-52 and exclude 65.. it is very difficult to build a logic to process so many combinations..

instead just use my previous logic for a single shot validation and this is how it is done by all.

Thanks

mahesh

Re: select option

Former Member — Mon, 30 Jul 2007 15:59:37 GMT

do u want to display all the values that are specified in your range of values and that are not in the ltap table

regards,

srinivas

Re: select option

Former Member — Mon, 30 Jul 2007 16:10:58 GMT

OK friends i accept your answer

but if i put in s_tanum 3 tanum how i can get the err

Re: select option

Former Member — Mon, 30 Jul 2007 16:13:07 GMT

i mean taht all in s_tanum-low

Re: select option

Former Member — Mon, 30 Jul 2007 16:21:54 GMT

Here you go a sample code..Ensure that your select-options does not have intervals

TABLES : vbak.

SELECT-OPTIONS : s_vbeln FOR vbak-vbeln NO INTERVALS.

AT SELECTION-SCREEN.

LOOP AT s_vbeln.

SELECT SINGLE * FROM vbak WHERE vbeln = s_vbeln-low.

IF sy-subrc NE 0.

MESSAGE e001(zs).

EXIT.

ENDIF.

ENDLOOP.

Thanks

Mahesh

Re: select option

Former Member — Mon, 30 Jul 2007 16:22:57 GMT

Hi,

in your case, do the following.

if s_tanum-option = 'EQ'.

select tanum from ltap into ztanum where tanum in s_tanum.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

elseif s_Tanum-option = 'BT'.

loop at s_tanum.

select tanum from ltap into ztanum where tanum in s_tanum-low.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

endloop.

endif.

Regards,

Niyaz

Re: select option

Former Member — Mon, 30 Jul 2007 16:24:25 GMT

Hi,

in your case, do the following.

if s_tanum-option = 'EQ'.

select tanum from ltap into ztanum where tanum in s_tanum.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

elseif s_Tanum-option = 'BT'.

loop at s_tanum.

select tanum from ltap into ztanum where tanum in s_tanum-low.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

endloop.

endif.

Regards,

Niyaz

Re: select option

Former Member — Mon, 30 Jul 2007 16:24:59 GMT

Hi,

in your case, do the following.

if s_tanum-option = 'EQ'.

select tanum from ltap into ztanum where tanum in s_tanum.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

elseif s_Tanum-option = 'BT'.

loop at s_tanum.

select tanum from ltap into ztanum where tanum in s_tanum-low.

if sy-subrc ne 0.

message e000 with 'Invalid'.

endif.

endloop.

endif.

Regards,

Niyaz