topic Runtime Error(SAPSQL_INVALID_FIELDNAME) in Application Development and Automation Discussions

Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Wed, 26 Sep 2007 03:47:27 GMT

Hi,

I am getting Dump error while i am trying to create Sales order for Perticular Company Code not for other company code theire there is no Dump.

Runtime Errors SAPSQL_INVALID_FIELDNAME

Except. CX_SY_DYNAMIC_OSQL_SEMANTICS

Date and Time 26.09.2007 09:08:20

Short dump has not been completely stored (too big)

Short text

A dynamically specified column name is unknown.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLV61Z" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was

not caught in

procedure "SEL_KONDTAB" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

An Open SQL clause was specified dynamically. The contained field name

"VKORG" does not exist in any of the database tables from the FROM clause.

Please advise how to solve this problem.

Raghu

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Wed, 26 Sep 2007 04:09:52 GMT

Hi Raghu,

I am not clear with the query...

-->Sales order is created for Sale Org/Channel/Division/Sale office/Sale Grp....So the problem in not with the Company code.....Some times the message can mislead you

Check out for the following...

1. Is there any Append structure adde to the VBAP... if yes then adjust the DB....

Only way is to Debugg and the check the field value for raising this error message..

<REMOVED BY MODERATOR>

Regards,

Prabhu Rajesh

Edited by: Alvaro Tejada Galindo on Apr 11, 2008 1:21 PM

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Wed, 26 Sep 2007 04:45:03 GMT

Hi,

U r correct thsts not Company code that is sales organisation.

Recently i did SIS customization means in Mc21 i created own Infosructure after that i am getting this dump,after i deleted my own infostructure then also i getting this dump.

Raghu

Message was edited by:

Raghu

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Jelena_Perfiljeva — Fri, 11 Apr 2008 17:16:58 GMT

Try running transaction MCS/ and program RV80HGEN to re-generate the code associated with the info structure. Those things can be pain in the back sometimes.

Once I ran into a similar problem and couldn't delete the structure at all - it was giving short dumps. So I ended up re-creating it with no update.