topic Re: Select Query Error in Application Development and Automation Discussions

Select Query Error

Former Member — Thu, 26 Nov 2009 10:26:10 GMT

Hi Experts,

In the following code I am getting some error like,

"the list (w_tabnachn,w_tabvorna) after "INTO" is not of the form (f1,...,fn) or contains an undefined field.

the form (f1,...,fn), or contains an undefined field. "

SELECT nachn vorna FROM PA0002 into (w_tabnachn, w_tabvorna)

WHERE PERNR = w_pldoc_key-pernr.

ENDSELECT.

I could able to execute this code within the local class, but not doing so in global class, any clue pls

Regards,

Haritha

Former Member — Thu, 26 Nov 2009 10:34:56 GMT

Hi,

Check the declarations of the fields w_tabnachn & w_tabvorna. Declare these variables globally then it will work.

Thanks,

Rakesh

Former Member — Thu, 26 Nov 2009 10:37:45 GMT

Hi,

Where have you defined w_tabnachn and w_tabvorna ?

Former Member — Thu, 26 Nov 2009 10:39:48 GMT

where have you declared these two variables?

must be in the local class...

see if its present in global class or not..