topic Re: Expensive SQL Statements through FM in Application Development and Automation Discussions

Expensive SQL Statements through FM

Former Member — Wed, 17 Oct 2012 13:16:57 GMT

HI,

Good day,

As i working on a third party system,

I am looking for a standard Function module which will work similar to ST04

and get all the Expensive SQL statements.,...

Any help would be really Appreciated....

Regards

SAMUEL

Re: Expensive SQL Statements through FM

Former Member — Wed, 17 Oct 2012 14:04:49 GMT

Hello,

ST04 is a complex program. It will be difficult to get a FM for that process. There is a program attached to this transaction "RSDB0004", see if you could use that.

You are looking for FM so that the third party can call it ? If so here is what you can do -

Create a wrapper FM with some basic parameters and inside this FM call this program.

Best regards,

swanand

Re: Expensive SQL Statements through FM

Former Member — Wed, 17 Oct 2012 14:15:48 GMT

Hi Sam,

Refer SAP Note no.521750

Regards,

Akhil

Re: Expensive SQL Statements through FM

Former Member — Thu, 18 Oct 2012 09:16:06 GMT

HI swanand Lakka,

Thanks for the reply,

that's really helpful....But can you please suggest me any Standard FM where i can get top SQL Statements.

may be working partly as ST04....

Regards

SAM

Re: Expensive SQL Statements through FM

Former Member — Thu, 18 Oct 2012 14:33:11 GMT

Hello,

You could find FM in function group S_ORA_COCKPIT_2. But it will be very difficult for you to use them. SAP has a complex way of doing it, probably you will need to debug ST04 and see how these FM are used. Best of Luck.

best regards,

swanand