Short Dump while entering data in VF01

[Former Member]

Runtime Errors SAPSQL_INVALID_FIELDNAME

Except. CX_SY_DYNAMIC_OSQL_SEMANTICS

Program SAPLV61Z

Include LV61ZU01

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

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

Error found in these codes.

if se_read_all_prestep is initial.
          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).
          h_subrc = sy-subrc.

I had debug the codes and found that when t681-kotab = A752 and line in coding_tab is ALAND = 'DE' and WERKS = 'XX' and VSTEL = 'XX' and LLAND = 'NL'. I will hit error because in A752 table, field WERKS does not exists!

I guess this is a config problem but I do not know how to fix it.

Appreciate helps. Thanks a lot.

[Former Member · Accepted solution]

Hi,

goto V/07 and in the table 752 maintain the field werks and try.

PLease let me know if you still face the problem

Thanks and regards,

Rajeshwar

[Former Member · Accepted solution]

Hi,

I executed v/07 but I cannot find the 752 table.

T-code: v/07

Usage: A

Application: V

Access sequence: MWST

Access No: 08, Table = 78

Access No: 10, Table = 2

Access No: 20, Table = 11

Please assist. Thanks.

[Former Member]

used v/05 to add field into 752 table

[Former Member]

It will better to post this question under ABAP u will get answer faster

Sageer

[Former Member]

Hi,

But I think this is a SD functional configuration that cause this problem.

Cheers.

[former_member232834]

lsemun this is definately a configuration problem.

Also, go to t-code se11 and type in WERKS, then click activate. then try your transaction process again and see if you get an error or not.

Edited by: Muhammad Ali Lozada on Jun 10, 2009 1:05 PM

[Former Member]

Hi,

I still get the same error after activate WERKS.

Additional info,

I got the error when:

T681-KOTAB = A752

se_kappl = V

se_kschl = MWST

coding_tab[] = ALAND = 'DE AND WERKS = 'DE10' AND VSTEL = 'DE10' AND LLAND = 'NL'

Please help. Thanks.