Material document posting error

[Former Member]

During Material document posting in MB1B, and in MIGO i am getting this short dump

Runtime Errors SAPSQL_INVALID_TABLENAME

Except. CX_SY_DYNAMIC_OSQL_SEMANTICS

Date and Time 29.06.2011 11:12:21

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 "B570" 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.

sing RAISING Clause in Interface

Program SAPLV61Z

Include LV61ZU01

Row 266

Module type (FORM)

Module Name SEL_KONDTAB

debugger Location of Exception

Program SAPLV61Z

Include LV61ZU01

Row 652

Module type (FORM)

Module Name SEL_KONDTAB

[former_member204661]

Hi Sachien,

You would need to get in touch with your ABAPer, or a techno functional consultant would be able to help.

This should also help

Regards

Shailesh

Edited by: Shailesh Rajan on Jun 29, 2011 8:27 AM

[Former Member]

Hi Ms. nisha and Shailesh Rajan

Problem solved, the thing is under SPRO>MM>Inventory Management and Physical Inventory>Output Determination>condition table 570(created with movement type condition)

the Table 570 was deactivated, that's y i got that short dump error

Now i have deleted that condtion table

Now my document is getting posted

[Former Member]

Hii sachien,

u didnt tell, after what changing u got this error. , have u done any type of patch work or anything else..... better u consult to ABAPers.

The short dump SAPSQL_INVALID_TABLENAME is usually caused because of an inconsistency between the DDIC and the database.

See SAP Note 449891 & consider using the SAP_DROP_TMPTABLES report.

else search sdn, really, it will be helpful.

thanks

Nisha

Edited by: Ms. nisha on Jun 29, 2011 8:23 AM