problem in select statement

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi

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....

[Former Member]

Hi Goldenn,

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

Regards

Kumar M.

[Former Member]

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.