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

Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Wed, 26 Sep 2007 03:48:31 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)

George_Lioumis — Wed, 26 Sep 2007 10:31:22 GMT

Hi.

Tell your SD guys to check their pricing customizing assigned to the Sales Organization that you are trying to post the sales order and especially their condition tables. A condition table has been created with the key field VKORG but this has probably been removed later and something has not been activated. It is definitely a problem with a condition table.

Reward please if it helps.

Regards,

George

Message was edited by:

George Lioumis

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Wed, 26 Sep 2007 13:18:37 GMT

See if note 668658 helps.

Rob

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

former_member154070 — Thu, 27 Sep 2007 05:12:25 GMT

Hi,

This is something to do with pricing configuration.

Check with your functional consultant.

Regards,

Umesh

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Thu, 27 Sep 2007 07:57:24 GMT

hi Raghu,

Check whether the table is having the company code added in the value range...

or else please try to Adjust & Activate table for company code....

hope this may be useful...

regards,

prashant

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Thu, 27 Sep 2007 11:28:05 GMT

Hi,

Thankyou very much for your reply.

Here actually i am not getting this error w.r.t. Company code this for Sales organisation.But in other sales organisation its working fine.

One morething what ever Pricing procedure assigned to other sales organisation is same as all.

There is no changes in Access seq.

Raghu

Re: Runtime Error(SAPSQL_INVALID_FIELDNAME)

Former Member — Sun, 26 Feb 2012 11:22:09 GMT

Hi George,

Thank you ever so much for your post. I developed a complicated pricing procedure with lot of unconventional fields. Because of this, I faced the above error. And with your help, I was able to resolve it.

Thanks again.

Warm regards,

Sarat.