How to find a table name?

[former_member502730]

Dear All,

How to find a table name from any structure?

REgards,

Dharmehs

[Former Member]

hi Dharmesh,

Say inorder to Find the field inf. you can use SQL trace (ST05) .

Steps for the same:

• Go to ST05 --> Activate Trace.

• Run the trasaction , make some changes to the field for which you want to have the table name then SAVE.

• Go again to ST05 ---> Deactive Trace

• List trace

• Then search for the chaged value which u had done on that transaction.

• With this you will be able to see the table name in the Obj. name column.

Check these thread also.

Hope this will help you

Cheers

Sunny

Reward points, if found helpful

[Former Member]

hi Dharmesh,

Check <b>SQL Trace</b> i.,e T-Code -<b>ST05</b>

Regards,

Santosh

[Former Member]

Hi,

You can not directly find the table names from structures by Where used list.

The best option is to use SQL trace (ST05).

Regards,

Shashank

[abdul_hakim]

Hi

There are several ways to find the table name for a specifed structure.

One way is to do the sql trace st05 for the corresponding transaction.

The other way is just check the dataelement of the corresponding structure field and check where used list and then select the tables.You will get a list of tables related to this dataelement.

The best option is to do the SQL Trace (ST05)

Regards,

Abdul Hakim

[Former Member]

Hello Dharmesh,

There are couple of ways to find.

1. ST05 - SQL trace.

2. U can set a watchpoint in the debug mode on the structure field and trace back from where the value is getting dervied. This is little difficult but u can get the source table.