ABAP DUMP -

[Former Member]

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).

[amit_khare]

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.

[Former Member]

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

[Former Member]

Change the select clause :

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

[Former Member]

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.

[Former Member]

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.