Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ST05

Former Member
0 Likes
641

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
614

Hi,

In ur Query, u did not mention INTO clause.

So its giving dump.

Regards,

Ranjit Thakur.

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

4 REPLIES 4
Read only

Former Member
0 Likes
615

Hi,

In ur Query, u did not mention INTO clause.

So its giving dump.

Regards,

Ranjit Thakur.

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

Read only

0 Likes
614

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

Read only

Former Member
0 Likes
614

Hi,

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

Please give the INTO clause and then check.

Thanks,

Sandeep.

Read only

jayanthi_jayaraman
Active Contributor
0 Likes
614

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