topic Query SAP Database with Native Sql. in Application Development and Automation Discussions

Query SAP Database with Native Sql.

Former Member — Fri, 14 Jan 2005 10:00:05 GMT

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

Re: Query SAP Database with Native Sql.

christian_wohlfahrt — Fri, 14 Jan 2005 10:26:34 GMT

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

Re: Query SAP Database with Native Sql.

Former Member — Fri, 14 Jan 2005 10:58:13 GMT

Hi,

This doesn't work...

//MA

Re: Query SAP Database with Native Sql.

Former Member — Fri, 14 Jan 2005 12:20:04 GMT

Hi Martin,

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

BR,

Alvaro

Re: Query SAP Database with Native Sql.

Former Member — Fri, 14 Jan 2005 13:19:32 GMT

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

//MA

Re: Query SAP Database with Native Sql.

Former Member — Fri, 14 Jan 2005 15:44:13 GMT

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.

Re: Query SAP Database with Native Sql.

nablan_umar — Fri, 14 Jan 2005 15:48:14 GMT

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.