Finding table name from field

[Former Member]

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

[former_member673464]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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