report program

[Former Member]

How To Find The Tables For The Given Transaction?

[Former Member]

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

[arjun_subhash]

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

[Mohamed_Mukhtar]

>

> 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

[Former Member]

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.

[Former Member]

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

[Former Member]

I smell blood in the water...

[JanStallkamp]

>

> I smell blood in the water...

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

[Former Member]

hi

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