Query SAP Database with Native Sql.

[Former Member]

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

[Former Member]

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.

[christian_wohlfahrt]

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

[Former Member]

Hi,

This doesn't work...

//MA

[Former Member]

Hi Martin,

u could try to connect to your SAP system with SAPR3/SAP

BR,

Alvaro

[Former Member]

Sorry, I don't understand what you mean...

//MA

[Former Member]

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.

[nablan_umar]

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.