topic Re: Finding table name from field in Application Development and Automation Discussions

Finding table name from field

Former Member — Thu, 22 Mar 2007 03:57:38 GMT

Hello,

Is it possible to find the table name if a field name is known? For eg, I want to find out which table the field ACC_GRP belongs to.

Also, if I know fields and tables, how to find out which transaction is used to create master data using these fields?

Thank you very much

Re: Finding table name from field

former_member673464 — Thu, 22 Mar 2007 04:10:07 GMT

hi mandha,

Goto tcode->SE84,then press on fields,then table fields.Give the field name and execute.U will see the field used in different tables.

regards,

veeresh

Re: Finding table name from field

Former Member — Thu, 22 Mar 2007 04:45:06 GMT

hi,

yes it is possible go to dd03l and give the field name u will get corresponding table name.

your second question is that go to screen field and see the technical information.

Re: Finding table name from field

Former Member — Thu, 22 Mar 2007 04:50:54 GMT

Hi Yala,

Yes, it is possible to find the table name from the data element i.e. the field name. First go to SE11, there type the field name in the Data Element tab and then go to the toolbar on the top and press the <b>WHERE-USED-LIST</b> and then it displays the list of tables where the given field has been used and from that you can choose the required table depending on your requirement.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: Finding table name from field

Former Member — Thu, 22 Mar 2007 04:55:16 GMT

Goto se84->abap dictionary->fields->table fields->give field name and execute

U will get the list of tables where the field is there..

i don't think you can find the Tcode if only table and field is given.. but if program or package is given then you can go to

se84->abap dict-> other objects-> transactions-> give prog name or package and find all the related Tcodes..Manually u can find the tcode..

hope it helps..

Award points if helpful

Re: Finding table name from field

Former Member — Thu, 22 Mar 2007 04:55:21 GMT

Hi,

here is the nice blog to find table name for a field

/people/community.user/blog/2006/12/29/useful-tips-to-find-out-the-table-for-screen-field

Regards

Sudheer

Re: Finding table name from field

Former Member — Fri, 23 Mar 2007 09:31:22 GMT

In SAP,Not only to find table and field names,To find(search) existing objects ,Go to respective transaction and position : Press F4 again Click Information System

There in the short description write your short text.You can use * to represent any character of length 0 or more.

For your Problem:

Step1 : Go to SE11

Step 2:At Database table Textbox: Press F4

Step 3:again Click Information System

Step 4: write your short text

From the displayed list select your suitable (needed) Object(Table)

Ok.Reward points if jelpful.

Regds,

Rama chary.Pammi