Error While entering data in VA01

[Former Member]

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.

[Former Member · Accepted solution]

Hi

Check with you ABAPer and ask them to debug the code as its seems error at 724 line.

[Lakshmipathi]

An invalid table name "A996" was specified 
   in an Open SQL command

Find out the transport request pertaining to Table A996 and ensure that both that request and the configuration request pertaining to that table are moved simultaneously.

thanks

G. Lakshmipathi

[Lakshmipathi]

1) First check in OX10, you have created the plant correctly.

2) Next ensure that in OX18, you have assigned the plant to your company code

3) Finally in OVX6, ensure that you have assigned the plant to your sales organisation and distribution channel.

thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

Thanks for your reply. I checked everything but still getting the same error.

Regards,

Sriram

[Former Member]

Sriram_14880 ,

Check in your Enterprise structure whether you have Deined and mainatined Plant in Definition --> LG --> Dfefine plants.

Similarly check whether Plant assignments in Logistics general and SD.

Please check

Regards

Sathya

[Former Member]

Hi Sathya,

Thanks very much for the reply. I tried redife and maintain Plant in LG and SD but I again get the same error.

Regards,

Sriram