topic Re: report program in Application Development and Automation Discussions

report program

Former Member — Mon, 01 Dec 2008 12:19:59 GMT

How To Find The Tables For The Given Transaction?

Re: report program

Former Member — Mon, 01 Dec 2008 12:21:33 GMT

Open the Transaction and click F1 on any of the field for ur choice. After that click on technical settings then u will see the table name and field technical nam of that field.

like that u can see for any field.

Regards,

Ajay

Re: report program

arjun_subhash — Mon, 01 Dec 2008 12:22:49 GMT

hi,

find the program name from system->status.go to se 80 and enter that.

then find the screen,go to layout, click on the field and u can understand to which table field it belong to.

thanks

Arjun

Re: report program

Mohamed_Mukhtar — Mon, 01 Dec 2008 12:22:55 GMT


> How To Find The Tables For The Given Transaction?

hi Nitin,

Find the program name of the particular transaction.

From se80 , you can find all the table used from se80.

Thanks and Regards

Re: report program

Former Member — Mon, 01 Dec 2008 12:23:36 GMT

Hi Nitin,

Exceute your Tcode & from menu system->status ..there you will get program name.

Now go to se80 enter program name & press enter ..left side frame you will get list of tables,subroutines etc.press on table tree.you will get list of all the standard & ztables used in the program for that Tcode.

Hope this will help.

Regards,

Nitin.

Re: report program

Former Member — Mon, 01 Dec 2008 12:23:54 GMT

There is a very easy way to find out all the tables related to a given transaction. Suppose you want to know the list of tables used when you create Sales Order or Purchase Order. How can we achive it? How to we track the list of all the tables use by SAP?

There is a very easy trick which will help you achieve that? Itu2019s SQL trace. just start ST05 and and start the SQL trace and go to any transaction and do any activity and let the document get saved. Now again go to SQL trace screen and stop the SQL trace and then click on display SQL trace thatu2019s it. It will show you the list of all the tables which have been accessed or updated.

Rgds,

Premraj

Re: report program

Former Member — Mon, 01 Dec 2008 12:26:31 GMT

run the TCODE

go to system->status

double click on the prg name

now go to global find

search for "TABLES" keyword

now u can see all the related tables if they have been explicitly defined

other things to search are modify/update/delete

Re: report program

Former Member — Mon, 08 Dec 2008 12:14:30 GMT

I smell blood in the water...

Re: report program

JanStallkamp — Mon, 08 Dec 2008 12:29:13 GMT


> I smell blood in the water...

Yes, I can see the sharks heading towards this thread...