Error while entering data in VA01.

Former Member — Tue, 28 Apr 2009 07:02:22 GMT

Hi,

I get the following error while entering data for "Plant" in Sales order creation (VA01). Can anyone please tell me how to solve this problem.

Runtime Errors SAPSQL_INVALID_TABLENAME

Except. CX_SY_DYNAMIC_OSQL_SEMANTICS

Date and Time 27.04.2009 12:57:13

Short dump has not been completely stored (too big)

Short text

A table name, specified in an SQL command, 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 invalid table name "A996" was specified in an Open SQL command:

Due to one of the following reasons, the error occurs only at runtime:

- the table name was specified dynamically, or

- the SELECT clause, WHERE clause, GROUP-BY clause, HAVING clause, or

ORDER-BY clause was specified dynamically.

Missing RAISING Clause in Interface

Program SAPLV61Z

Include LV61ZU01

Row 260

Module type (FORM)

Module Name SEL_KONDTAB

Trigger Location of Exception

Program SAPLV61Z

Include LV61ZU01

Row 724

Module type (FORM)

Module Name SEL_KONDTAB

Source Code Extract

Line SourceCde

694 and kschl = se_kschl

695 and datbi >= se_date

696 and datab <= se_date

697 and (coding_tab).

698 endif.

699 endif.

700 else.

701 if t681-ksdat is initial.

702 if not <entrytab> is assigned.

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

704 where kappl = se_kappl

705 and kschl = se_kschl

706 and (coding_tab).

707 else.

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

709 for all entries in <entrytab>

710 where kappl = se_kappl

711 and kschl = se_kschl

712 and (coding_tab).

713 endif.

714 h_subrc = sy-subrc.

715 if select_split ne 0.

716 modify coding_tab from coding_alter index select_split.

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

718 where kappl = se_kappl

719 and kschl = se_kschl

720 and (coding_tab).

721 endif.

722 else.

723 if not <entrytab> is assigned.

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

725 where kappl = se_kappl

726 and kschl = se_kschl

727 and datbi >= se_date

728 and datab <= se_date

729 and (coding_tab).

730 else.

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

732 for all entries in <entrytab>

733 where kappl = se_kappl

734 and kschl = se_kschl

735 and datbi >= se_date

736 and datab <= se_date

737 and (coding_tab).

738 endif.

739 h_subrc = sy-subrc.

740 if select_split ne 0.

741 modify coding_tab from coding_alter index select_split.

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

743 where kappl = se_kappl

Thank you in advance....

Regards,

Sriram.

Re: Error while entering data in VA01.

Former Member — Tue, 28 Apr 2009 07:21:12 GMT

Hi Sriram,

search in OSS for SAPLV61Z. There are some notes with Kondition.

Look also in T681. Is there an entry for A996?

Regards, Dieter

Re: Error while entering data in VA01.

Former Member — Tue, 28 Apr 2009 07:29:23 GMT

Hi Dieter,

Thank you verymuch for your reply. I looked into T681 for A996 but I'm not able to find it in the column KOTAB. Can u please tell me what for the table T681 is used.

Thank you once again...

Regards,

Sriram

Re: Error while entering data in VA01.

andrea_olivieri — Tue, 28 Apr 2009 23:14:59 GMT

Hi,

It seems that the pricing table A996 is inconsistent; I don't know in which environment is your problem, but if all pricing customizing transport requests were performed correctly (Field Catalog, Table definition, access sequence and so on..) try to regenerate the pricing table with the standard program RV12A001 by using the following parameters:

Usage = 'A'

Table = '996'.

Check all checkboxes and execute

Kind regards.

Andrea

Re: Error while entering data in VA01.

ykaldirim — Wed, 02 Feb 2011 15:22:57 GMT

woow Andrea,

RV12A001 program is really works. Thanks

topic Error while entering data in VA01. in Application Development and Automation Discussions

Error while entering data in VA01.

Re: Error while entering data in VA01.

Re: Error while entering data in VA01.

Re: Error while entering data in VA01.

Re: Error while entering data in VA01.