topic Re: Help with this error message in Application Development and Automation Discussions

Help with this error message

Former Member — Mon, 17 Aug 2009 06:45:07 GMT

Hi gurus,

I dont know ABAP. Request you to interpret and let me where the problem is..Would greatly appreciate yourhlep on this. thanks

and aregards

Joseph

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_DYNAMIC_OSQL_SEMANTICS',

was neither

caught nor passed along using a RAISING clause, in the procedure "SEL_KONDTAB"

"(FORM)"

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

The SELECT clause was specified in an internal table at runtime.

It contains the field name "ROUTE", but this does not occur in any of

the database tables listed in the FROM clause.

Re: Help with this error message

former_member188827 — Mon, 17 Aug 2009 06:51:19 GMT

in which transaction is this exception raised?is it a standard transaction?dynamic select statment is fetching field ROUTE which does not exist..

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 06:54:09 GMT

your dynamic select query is not able to execute because of wrong field name. check in debug mode what fields are getting passed and fetched in your select query.

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 06:55:07 GMT

Hi,

this error is occured because there is an extra field in the table which is declared in the program which you are executing, and that field is not available in any of the database tables mentioned in the select query....

To get rid of this issue....

you have to go to that program where it is giving error, and in the select query you have to add the line below just before the internal table name or the work area name

into corresponding fields of

"example.....
 SELECT <field_names>   FROM <database_table>  INTO TABLE itab.
"then you should change it to 
 SELECT <field_names>   FROM <database_table>  INTO CORRESPONDING FIELDS OF TABLE itab.

"or if the select query is like this
 SELECT <field_names>   FROM <database_table>  INTO fs_itab.
"then you should change it to 
 SELECT <field_names>   FROM <database_table>  INTO CORRESPONDING FIELDS OF fs_itab.

Regards,

Siddarth

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 06:55:32 GMT

Hi,

You might have written

select *

from TABLE

into table t_tab.

Check in the tables, ( i.e, tables after from keyword ), if the field 'ROUTE' is available..

Also check the field name is written correctly.

That might be the reason for that error...

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 06:56:17 GMT

Hi Joseph,

Based on the error description, the field Route does n't exist in the database tables you specified in your select query.

Please verify those database tables you used in that select query where you try to fetch Route field to clarify your doubt.

Prasad GVK.

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 06:56:26 GMT

Hi,

Please check the select in subroutine 'SEL_KONDTAB' this subroutine has a select which is trying to select field ROUTE which is not there is the tables specified to select from , In the dump analysis in transaction ST22 you would also find the program where this occured you can check there.

regards,

Himanshu

Re: Help with this error message

nikhilkup — Mon, 17 Aug 2009 06:58:09 GMT

Please check the field ROUTE in the table from where its picking up the data from. Put a breakpoint before the prgram is giving this error and run the program again and check the select query where its giving this error.

Re: Help with this error message

Former Member — Mon, 17 Aug 2009 07:26:47 GMT

Hi,

You put the code between the mark ups at the beginning and at the end. Well, I guess it was very genuinely asked.

Re: Help with this error message

nikhilkup — Mon, 17 Aug 2009 07:32:49 GMT

oh yes, Thanks Nitwick