01-14-2005 10:00 AM
Hi,
I would like to query the table MARA with native sql and return all headings and data
Select * from MARA where MATNR = '00000000151515'
<i>I need this to be able to TEST my Sql statements.</i>
In SqlServer you have the Query Analyser where I can do just this, but is there some nice in SAP Tool for this as well ?
[Unfortanely I can't connect to SAP_U01 database from QA...]
//Martin
01-14-2005 10:26 AM
Hi Martin,
maybe you give ST05 a try: last button gives the possibility to enter a SQL-statement directly - and for explanation it has to be executed (somehow).
Regards,
Christian
01-14-2005 10:58 AM
01-14-2005 12:20 PM
Hi Martin,
u could try to connect to your SAP system with SAPR3/SAP
BR,
Alvaro
01-14-2005 1:19 PM
01-14-2005 3:44 PM
anyways, why do you want to do it? It is not a good idea to use native sql for the purposes of getting data. SAP can change a database model next release, and in this case you will need to change your code too.
01-14-2005 3:48 PM
The closest you can get with something similar is SE16. You use ST05 to evaluate the performance of your SQL statement, considering the index you are having.