topic Selection Screen in Application Development and Automation Discussions

Selection Screen

Former Member — Tue, 22 Apr 2008 14:54:22 GMT

I am trying to achieve the following and have do not know how to go about

it:

On the my ABAP program selection screen for vbap-vstel I want to select all

items with a vstel with the third and forth positions = to 02 through 05.

Any help would be greatly appreciated.

Thank you,

Re: Selection Screen

Former Member — Fri, 25 Apr 2008 18:15:30 GMT

Not sure exactly what you mean - have you tried the "AT SELECTION

SCREEN" event? This allows you to run a block of code (such as a SELECT

SINGLE) before the selection screen is displayed.

Re: Selection Screen

Former Member — Fri, 25 Apr 2008 18:42:40 GMT

I too am confused as to what your requesting, but.. if you looking for a SELECT statement to do what your asking...



SELECT * FROM vbap
  WHERE vstel LIKE '%02'
     or vstel LIKE '%03'
     or vstel LIKE '%04'
     or vstel LIKE '%05'.

* Do something

ENDSELECT.

This will work.. but it will be pretty slow.

Re: Selection Screen

Former Member — Fri, 25 Apr 2008 18:47:28 GMT

Hi,

What is your requirement exactly? As per my understand

You want to get the data from DBtable in where conditon vstel field 3rd and 4th positions are EQ to '02', '03', '04', '05' in any one should be match.

If it is correct see below eg:

select * ...............

where 2(1)+vstel in ('02', '03', '04', '05' ) and

3(1)+vstel in ('02', '03', '04', '05' ) .

Thanks

Ganesh