topic Re: ST05 in Application Development and Automation Discussions

ST05

Former Member — Tue, 26 Jun 2007 05:07:56 GMT

Dear all,

In ST05, in Explain one SQL request when i write the select statement as "select matnr

bwkey

bwtar

lfgja

lfmon

bwtty from mbew. "

& click on Explain button.

it gives short dump with the error "table doesnot exist in database".

Please let me know why this occurs & how to solve this problem.

Thanks,

Heta

Former Member — Tue, 26 Jun 2007 05:42:47 GMT

Hi,

In ur Query, u did not mention INTO clause.

So its giving dump.

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>

Former Member — Tue, 26 Jun 2007 06:45:24 GMT

Hi,

The INTO clause is missing because of which it is giving dump.

Please give the INTO clause and then check.

Thanks,

Sandeep.

Former Member — Tue, 26 Jun 2007 06:57:17 GMT

After giving the into clause, now it pop ups the information message as "Explain SQL not available for DATA "

jayanthi_jayaraman — Tue, 26 Jun 2007 07:02:43 GMT

Hi,

You should give in single line as below.No full stops.Comma should be between fields.

select matnr, bwkey, bwtar, lfgja, lfmon bwtty from mbew