topic Re: Table identification in Application Development and Automation Discussions

Table identification

Former Member — Tue, 13 Jan 2009 11:12:22 GMT

Dear people,

Happy New Year to all of u..

I have problem, while uploading any data through a standard transaction code we get the field names through F1 help but most of the times the it shows a structure in F1 help, how do I correctly identify the table in which it is being stored???? Any methods??/

Any help will be of a great help..

thanks Ajay

Re: Table identification

Former Member — Tue, 13 Jan 2009 11:27:30 GMT

Hi,

Before Updating the data through transactions, just activate SQL trace (ST05), once the updation is done, deactivate the trace and display it.

here it will show all the tables which are updating through this transaction.

Hope it helps!!

Regards,

Pavan

Re: Table identification

Former Member — Tue, 13 Jan 2009 11:39:59 GMT

hi,

refer to this link..

Re: Table identification

former_member404244 — Tue, 13 Jan 2009 11:40:59 GMT

Hi,

U can check the database fields in which tables they are used ..

path ->GOTO SE15/SE84->ABAP dictionary->Fields->Table Fields.->Specify the field name and press on execute button , u will get the list of tables..

Regards,

Nagaraj

Re: Table identification

Former Member — Tue, 13 Jan 2009 11:49:24 GMT

Hi Ranjan,

Go to The Data Element of the field in the structure. Please check the Where Used List for this Data Element. It will give you list of tables where this Data Element is used. Depending upon the description of the tables you can identify the Table you need.

Hope this helps.