topic Ranges in select statement in Application Development and Automation Discussions

Ranges in select statement

Former Member — Sat, 26 May 2007 11:31:38 GMT

hi all,

I want to kow how to create ranges and how to use in selet statement

I have list of values A,B,C,D

In select statement I have to check VBTYP not in the above range...

Re: Ranges in select statement

Former Member — Sat, 26 May 2007 11:39:32 GMT

Hi,

Try this.

INITIALIZATION.

RANGES r_vbtyp FOR vbak-vbtyp.

AT SELECTION-SCREEN.

r_vbtyp-sign = 'I'.

r_vbtyp-option = 'BT'.

r_vbtyp-low = 'A'.

APPEND r_vbtyp.

r_vbtyp-sign = 'I'.

r_vbtyp-option = 'BT'.

r_vbtyp-low = 'B'.

APPEND r_vbtyp.

r_vbtyp-sign = 'I'.

r_vbtyp-option = 'BT'.

r_vbtyp-low = 'C'.

APPEND r_vbtyp.

r_vbtyp-sign = 'I'.

r_vbtyp-option = 'BT'.

r_vbtyp-low = 'D'.

APPEND r_vbtyp.

Select - - - from --

WHERE vbtyp NOT IN r_vbtyp-low.

Re: Ranges in select statement

amit_khare — Sat, 26 May 2007 11:40:08 GMT

Check RS reply in this thread -

Regards,

Amit

Re: Ranges in select statement

Former Member — Sat, 26 May 2007 12:20:10 GMT

ranges r_vbtyp for vbak-vbtyp.

start-of-selection.

r_vbtyp-low = value.

r_vbtyp-option = 'EQ'.

r_vbtyp-sign = 'I'.

append r_vbtyp.

r_vbtyp-low = value.

r_vbtyp-option = 'EQ'.

r_vbtyp-sign = 'I'.

append r_vbtyp.

select * from table into table int_table

where vbtyp in r_vbtyp.

Reward Points if it is helpful

Thanks

Seshu