‎2008 May 19 5:34 PM
i want validation logic for select-options....
i know this below logic.
but i want complete values validation logic.
select single ebeln from ekko where ebeln in s_ebeln.
if sy-subrc ne 0.
.........
.........
endif.
regards,
sathish.d.
‎2008 May 19 5:40 PM
Hi,
Ex:-
select-options: vbeln1 for vbak-vbeln.
at selection-screen on vbeln.
select single vbeln
from vbak
into vbak
where vbeln in vbeln1.
Regards,
Chandu
‎2008 May 20 4:59 AM
hi,
thanks for ur responce..
i know this statement,
but i want to validate each and every value in that select-option range.
it is very urgent.
regards,
sathish.d.
‎2008 May 20 5:04 AM
HI,
then try to write select statement as follows,
select ebeln from ekko into table itab
where ebeln in s_ebeln.
form this select querry u will get all ebeln values with in ur given selection range from ekko table.
Regards,
kk.
‎2008 May 20 5:17 AM
hi there...
i think this is what u are looking for....
select [col1] [col2] [col3] from [tablename] into table [internal table] where
[col1] in [selectoption1] and
[col2] in [selectoption2] and
.
.
.
.
and so on....
before this, declare an internal table with header line with the number of columns u want to fetch frm the standard table.
do reward if helpful....
‎2008 May 20 5:48 AM
Hi,
Try the following:
suppose the selectoption field is s_matnr.
declare an internal table of type matnr for getting matnrs from range s_matnr.
select matnr from mara into table it_mara where matnr in s_matnr.
Now
loop at it_mara
select single matnr from mara into wa_matnrwhera matnr = it_mara-matnr.
if sy-subrc = 0.
.............................
else.
..............
endif.
here you can validate each and every matnr.
Hope this is clear.
Reward points if helpful.
Thanks and regards.
‎2008 May 20 6:44 AM
im not clear abt ur qn...
just see whether this meets ur qn..
if ur select options has lower and upper limit..apply the code u have
if u want to validate the values in the select options...do some thing like this..
select-options:so_matnr for mara-matnr no-intervals.
at selection-screen.
loop at so_matnr.
select single * from mara where matnr = so_matnr-low.
if sy-subrc <> 0.
message with so_matnr-low.
endif.
endloop.