topic Re: SQL statement in Application Development and Automation Discussions

SQL statement

Former Member — Tue, 04 Dec 2007 10:49:52 GMT

Hi Abapers,

I have a requirement where i have to store the SQL statement running behind any customized tcode.I need this one to save the SQL staments for the transaction log .

How should i capture the SQL statement.

Please help me

Regards

Debjani

Re: SQL statement

former_member195698 — Tue, 04 Dec 2007 11:00:45 GMT

You have to Log the Information within the Custom Transaction at all places where the select query is being fired.

If the Logging is not periodic and is used only for some cases. Then you can keep the Trace on for the Transaction Code through ST05 and then List the Trace whenever Required.

Regards,

Abhishek

Re: SQL statement

Former Member — Tue, 04 Dec 2007 11:09:15 GMT

Hi Abhishek,

Thanks for reply.

I understand what you are saying.But My requiremnet is CODE to fetch the SQL statement.

Regards

Debjani