‎2007 Jun 26 6:07 AM
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
‎2007 Jun 26 6:42 AM
Hi,
In ur Query, u did not mention INTO clause.
So its giving dump.
Regards,
Ranjit Thakur.
<b>Please Mark The Helpful Answer.</b>
‎2007 Jun 26 6:42 AM
Hi,
In ur Query, u did not mention INTO clause.
So its giving dump.
Regards,
Ranjit Thakur.
<b>Please Mark The Helpful Answer.</b>
‎2007 Jun 26 7:57 AM
After giving the into clause, now it pop ups the information message as "Explain SQL not available for DATA "
‎2007 Jun 26 7:45 AM
Hi,
The INTO clause is missing because of which it is giving dump.
Please give the INTO clause and then check.
Thanks,
Sandeep.
‎2007 Jun 26 8:02 AM
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