table name from field

[Former Member]

Dear Sapers,

How to find table name from field name to write functional spec.Pl elaborate it for normal & zdevelopment.Points will be rewarded for useful answer.

Thanks in advance.

[Former Member · Accepted solution]

Hi Uday,

Just for the sake of help this reply......

You can find the name of tables by using F1 button keeping cursor on the respective field that you want to bring in development. From there you have to move to Technical details through technical details button.

If that field or values are getting saved into some structure then you have to search the right database tables. According to your module many database tables are there (that you can search from sdn.sap.com directly). That totally depends on your report/development that you want to bring in......

In any development deciding the right table for start up ( I mean to say tables that will give you input fields in your FS) is critical, latter you have to search linking tables and have to give logic about how to pass values from what to what field and what to what table..... In this case Transaction code SE11 and SE16 are useful......

This all is slightly confusing and tedious too...... Closely work with you ABAPer to get into many things and have successful development....

Have nice development....

Cheers!

Abu Arbab

[Former Member]

Hi Uday,

Select the filed-press F1 help.in that Technical Information button.You can find the Table Field name and the Table name.Many times you find the Structure name instead of Table name.then,to find the Data base table name,double click on the Data element name.Select 'where used list' and check for -Table fields.It will display all the DB tables for that data element.search for the exact one.It's quite a tedious Job if correct table is not found directly.Can use ST05-on the trace ,run the transaction,deactivate the trace ,find out the table .Or use SE84 as said by others.

Hope this helps you,

Regards ,

Madhu

[rupesh_brahmankar3]

Dear,

First go to the transaction then ursor on i/p field and click on f1

and find out the field name & table..

This is one method to find the field name and table name.

The best way to find out table from field is,

Use SE15 Transaction->dictionary fields ->table fields->goto table field columns

Enter ur fields..

or you can use ST05

Goto SE84->ABAP dictionary ->Fields -> Table fields-> Field name-> Excute

Hope clear to you.

Regards,

R.Brahmankar

[Former Member]

Dear Friends,

Thans for u r valuable time & inputs.

Mr.Brahmankar U r doing great job Keep it up..........!

Edited by: uday kodgule on Nov 10, 2008 10:58 AM

Edited by: uday kodgule on Nov 10, 2008 10:59 AM

[rupesh_brahmankar3]

Dear,

If you got the answer then please closed the thread.

Regards,

R.Brahmankar

[Former Member]

Uday,

I assume that you already know that a particular field will exist in multiple tables. So, I think you are asking "I have a field name. How can I find the Tables that contain this field name?"

SE84 (Repository)

then select ABAP Dictionary > Fields > Table Fields

Fill in the Field name (wild cards are supported), leave the Table name blank. Execute. This will give you a listing of all tables that use the field name you specified.

Regards,

DB49