fields

[Former Member]

i have one field...how to know that the field is belongs to particular table?i mean how how to know that particular field belongs to particular table?

[Former Member]

Hi,

Take the data element of that field

Enter that in SE11

and search where used list in tables

it will give all the tables names

or use DD03L table

enter field and get the Table name

reward if sueful

regards.

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

go to se11 n enter the field name in where used list.....or go to object navigator give filed name u `ill get it..

[Former Member]

Hi Balu,

Go to SE11, and there in the Data Element coloumn, type the field name and then click the <b>WHERE-USED LIST</b> tab on the toolbar.

The list of the tables where the field has been used will be displayed.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

HI,

ITS VERY SIMPLE.

go to t-code SE15 OR SE84 OR SE85.

All r repository t - codes.

u can find easily by entering the field in the search.

U can send me the field name .

i will find and tell u.

Senthil kumar

[Former Member]

Go to T.Code SE84.

ABAP Dic -> Fields -> Table Fields.

In this above path u can get the table name for the given field.

Regards,

--> Suresh

[Former Member]

hi

try :<b> run program RSSDOCTB</b>. This gives you a list with info about the table such as fields, check tables ....

Or

try<b> Transaction SE84</b> (Repository Info System)- Select in the tree ABAP Dictionary -> Fields -> Table Fields - Insert in the Select-Option "Field name" the name of the files (E.g. CARRID and CONNID) and execute it - now you will get a list of all tables which have one or both of this fields - it's easy to identify the tables which contain both fields in the list.

regards

ravish

<b>plz dont forget to reward points if helpful</b>

[Former Member]

Hi,

Below are the different types to know the table name for a field name

1) Goto SE11, and do the Where used list for that field

2) in DDL03 table, you will find the table name for that field

3) goto Se84, in the Table fields give the field name and press F8

and also, here is the nice blog which will explain to find a table name for a field name

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

Regards

Sudheer

[Former Member]

Balu,

There are couple of options to trace a field.

1 --> you can do a WHERE-USED-LIST from SE11 to find the tables where this
        field is used; This will mostly return a huge list , and will be difficult to identify
        which is the table that is relevant.

2 --> if you know the transaction, for the requirement, like if you are trying to find
       the table for a field in a transaction, you can press F1 on the screen field
       and then click on Technical info button (a button with icon having some tools)

3 --> you can use transaction ST05 for SQL Trace, and find out from which table
        the field is getting populated. This is the most effective method to trace a 
        field, if you know the transaction where the field is used. (you need to activate
        SQL trace in ST05, execute the transaction which has field, do some 
        manipulation with the field under consideration, save the transaction, Go back
        to ST05, de-activate SQL trace, select the button display trace...you will see
        the SQL statements triggered in the transaction. 

Hope this helps,

Sajan Joseph.

[Former Member]

HI

u can goto t-code <b>SE11</b> and enter the field name in the <b>DATA TYPE</b> and then click on <b>WHERE USED LIST icon</b>...hence u will get a list tables with that field name...and choose the required table for ur fifeld...

or u can also use the <b>T-CODE - SE80</b> for Object Navigation purpose

this will surely help u,

Thanks,

Ginni