topic Re: Select-options validation in Application Development and Automation Discussions

Select-options validation

Former Member — Sat, 08 Dec 2007 11:33:18 GMT

select-options: s_kunnr for kna1-kunnr.

In my requirement I need to validate the above selection-screen parameters (i.e. s_kna1-low and s_kna1-high contained in database or not). Can anybody give the logic for this.

Regards,

Naseer.

Re: Select-options validation

Former Member — Sat, 08 Dec 2007 11:37:18 GMT

In the At selection-screen event write select single queries as below


Data: gv_kunnr_low type kna1-kunnr.
Select Single kunnr from KNA1 into gv_kunnr_low where kunnr = s_kunnr-low.
if sy-subrc <> 0.
 error message.
endif.

Same as for high.

Regards,

Satish

Re: Select-options validation

Former Member — Sat, 08 Dec 2007 11:42:48 GMT

Hi nasser,

You will be writing select query depending up on ur select-options field. There you can validate as per given input values if the select qurey is fecting values into internal table it is ok if not the value donest exits.

Ex:

Select-options: S_kunnr for kna1-kunnr.

Select * from KNA1 into table itab where kunnr in s_kunnr.

IF NOT ITAB IS INITIAL .

loop at itab

write: itab-kunnr.

endloop.

else.

message E001 with 'NO RECORDS AVAILABLE FOR GIVEN INPUT'.

ENDIF.

Hope this will help u.....

reward if useful

Regards,

sunil kairam.

Re: Select-options validation

Former Member — Sat, 08 Dec 2007 11:44:23 GMT

Hi Naseer,

Check sy-subrc after the select statement if its success then proceed else thrw a error message.

For e.g

AT SELECTION-SCREEN ON S_KUNNR.

Select single kunnr from kna 1

into loc_variable

where kunnr in s_kunnr.

if sy-subrc <> 0.

Write : 'No data'.

else.

..........

........... (Your Coding).

Endif.

Do it like this you will get error message if it error else you will proceed with your coding.

Hope its useful.

Thanks,

Sakthi C

*~~Rewards if useful~~*

Re: Select-options validation

former_member195698 — Sat, 08 Dec 2007 11:44:27 GMT

Try

select single * from kna1 where kunnr in s_kunnr.

if sy-subrc eq 0 , then atleast one entry is there in your select option that is valid.

You shouldn't just check the high and low parameter.

Regards,

Abhishek

Re: Select-options validation

Former Member — Sat, 08 Dec 2007 11:48:33 GMT

tables :

spfli.

select-options:

s_carr for spfli-carrid.

Hi,

i guess this code will solve ur problem.

data:

it_tab like table of spfli with header line.

select *

from spfli

into table it_tab

where carrid gt s_carr-low

and carrid le s_carr-high.

if sy-subrc eq 0.

loop at it_tab.

write: it_tab-carrid.

endloop.

endif.

plzz reward points if it helps.

Re: Select-options validation

Former Member — Sun, 09 Dec 2007 05:46:03 GMT

Hi Naseer,

Try this code it may help full.

tables spfli.

data w_carrid type spfli-carrid.

select-options s_carrid for spfli-carrid.

selection-screen on s_carrid.

Loop at s_carrid.

if s_carrid-low is not initial.

select single carrid

into w_carrid

from spfli

where carrid eq s_carrid-low

if sy-subrc ne 0.

clear w_carrid.

message e015 ( Error message here)

endif.

if s_carrid-high is not initial.

select single carrid

into w_carrid

from spfli

where carrid eq s_carrid-high

if sy-subrc ne 0.

clear w_carrid.

message e015 ( Error message here)

endif.

endloop.

Plzz Reward if it is Useful,

Mahi.