topic Re: problem in select statement in Application Development and Automation Discussions

problem in select statement

Former Member — Mon, 27 Oct 2008 06:49:43 GMT

Hello ,

I ve a select statement. its like SELECT SINGLE FILEDS FROM DBTABLE INTO SCREEN_FIELDS WHERE CONDITIONS.

SCREEN_FIELDS ARE THE DRAG FIELDS FROM THE TABLE IN SCREEN.

It showing me an error message when i m checking for the syntax that " the fields are not in the list. but i ve the checked all the fields are in proper order.

Re: problem in select statement

Former Member — Mon, 27 Oct 2008 06:53:32 GMT

If you have used table fields on screen than yo u have to select data in that table only.

Suppose you have screen field from work area of table itab

then write like this:

select single fields from DB tab

into wa_itab

where....

Re: problem in select statement

Former Member — Mon, 27 Oct 2008 07:01:30 GMT

Hi Goldenn,

There may be problem in Type mismatch between the screen fields and database table fields.

Regards

Kumar M.

Re: problem in select statement

Former Member — Mon, 27 Oct 2008 07:34:14 GMT

Hi,

Whatever fileds you have decalred in the screen, you need to declare the same in the TOP INCLUDE of your program.

For example, you have a field in the screen with name w_name

then you must declare the same variable in the program also.