topic Re: report in Application Development and Automation Discussions

report

Former Member — Tue, 02 Jan 2007 14:11:29 GMT

Hello ,

I am running a report program MB51, I want to know all the tables that were accessed to extract data when we run MB51. I looked into SQL trace through ST05. Is there any other way to fine this out.

Thanks,

Madhu..

Re: report

suresh_datti — Tue, 02 Jan 2007 14:14:26 GMT

PL check this <a href="/people/community.user/blog/2006/12/29/useful-tips-to-find-out-the-table-for-screen-field">blog</a>.

~Suresh

Re: report

Former Member — Tue, 02 Jan 2007 14:17:43 GMT

Dear Madhu,

In MB51mainly 2 Tables get triggered:

(1) MSEG

(2) MKPF

Connecting fields between the 2 Tables are:

(a) MBLNR

(b) MJAHR

Regards,

Abir

***********************************

Don't forget to award Points *

Re: report

Former Member — Tue, 02 Jan 2007 14:20:21 GMT

Please check FM: RS_PROGRAM_TABLES.Parameters to Pass:

- Object Type: TRANS

- Object Name: <transaction code>

Execute to find the results.

Re: report

Former Member — Tue, 02 Jan 2007 14:20:23 GMT

Thanks Suresh.

My problem is to find the tables that were used ti extract data when we run a report program.

Madhu.

Re: report

Former Member — Tue, 02 Jan 2007 14:21:23 GMT

Thanks Abir,

However how can i find for another transactions. Eg MVBE and so on...

Madhu.

Re: report

Former Member — Tue, 02 Jan 2007 14:24:40 GMT

Thanks Chandrasekhar.

But it comes with a message that object type unknown.

I used TRANS

Madhu.

Re: report

Former Member — Tue, 02 Jan 2007 14:27:18 GMT

Dear Madhu,

I've worked with a customized version of MB51 long time back. This way I came to know which tables are getting the hit.

Other wayout is ST05 --> SQL Trace.

Regards,

Abir

***********************************

Don't forget to award Points *

Re: report

Former Member — Tue, 02 Jan 2007 14:30:09 GMT

Thanks Chandrashekhat.

I used Object Type TRAN instead of TRANS and it worked.

Madhu.