report

[Former Member]

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..

[suresh_datti]

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

[Former Member]

Thanks Suresh.

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

Madhu.

[Former Member]

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 *

[Former Member]

Thanks Abir,

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

Madhu.

[Former Member]

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 *

[Former Member]

Please check FM: RS_PROGRAM_TABLES.Parameters to Pass:

- Object Type: TRANS

- Object Name: <transaction code>

Execute to find the results.

[Former Member]

Thanks Chandrasekhar.

But it comes with a message that object type unknown.

I used TRANS

Madhu.

[Former Member]

Thanks Chandrashekhat.

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

Madhu.