topic Re: ABAP DUMP - in Application Development and Automation Discussions

ABAP DUMP -

Former Member — Tue, 29 May 2007 07:34:52 GMT

Any pointers to the following ABAP Dump

Runtime Errors : SAPSQL_INVALID_FIELDNAME

Exception - CX_SY_DYNAMIC_OSQL_SEMANTICS

Procedure - SEL_KONDTAB

Description : An open SQl clause was specified dynamically . The contained field name 'SPART' does not exist in any of the database tables from the FROM clause.

Inlcude program : LV61ZU01

line number 678 -

> select * from (t681-kotab) appending table <cond_tab>

up to 1 rows

where kappl = se_kappl

and kschl = se_kschl

and datbi >= se_date

and datab <= se_date

and (coding_tab).

Re: ABAP DUMP -

amit_khare — Tue, 29 May 2007 07:39:18 GMT

The Table mention in FROM clause of the select statement does not have the field SPART.

Check the table you are reading.

Regards,

Amit

Reward all helpful replies.

Re: ABAP DUMP -

Former Member — Tue, 29 May 2007 07:47:05 GMT

Hi Siju ,

Since a dynamic SQL is being created , so put a breakpoint and see on acessing which table does the program dump.

Regards

Arun

Re: ABAP DUMP -

Former Member — Tue, 29 May 2007 07:58:18 GMT

Change the select clause :

Select * from table name (T681) instead of field name (T681-KOTAB)

Re: ABAP DUMP -

Former Member — Tue, 29 May 2007 08:00:15 GMT

Hi Siju Nair,

The dump is because u r trying to fetch data from SPART which is not a database table. Check out how the entries are being populated in t681-kotab.Its is populating SPART at some instance which is wrong.

Re: ABAP DUMP -

Former Member — Tue, 29 May 2007 08:35:03 GMT

hi,

use t681 instead of t681-kotab because u are selecting more than one field based on few conditions. or

select kotab from t681-kotab appending table <cond_tab>

up to 1 rows

where kappl = se_kappl

and kschl = se_kschl

and datbi >= se_date

and datab <= se_date

and (coding_tab).

if helpful reward some points.

with regards,

suresh babu aluri.