Skip to Content
0
Former Member
Jul 04, 2006 at 12:40 PM

SELECT Statement

20 Views

Hello everyone,

I am trying to select some data from a database table

depending upon the option the user chooses from the

selection screen. There are three possiblities:

e.g.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE tsp01_tab

UP TO 20 ROWS

FROM tsp01

WHERE

  • Credit Notes / Invoices

(

rq0name = wa_rq0name

AND rq1name = wa_rq1name

AND rq2name = wa_rq2name

AND rqcretime GE wa_start

AND rqcretime LE wa_end

AND <b>select_option</b> = '1'

)

OR

*

  • Customer Statements

(

rq0name = wa_rq0name

AND rqcretime GE wa_start

AND rqcretime LE wa_end

AND <b>select_option</b> = '3'

)

OR

*

  • Reminders

(

rq0name = wa_rq0name

AND rq2name LIKE 'DUN%'

AND rqcretime GE wa_start

AND rqcretime LE wa_end

AND <b>select_option</b> = '3'

).

From the above you can see that the <b>select_option</b>

is the screen parameter. However, I can't activate the

code because the checker says 'Field select_option unknown'.

Does anybody know how I can get around this??