topic Re: fields in Application Development and Automation Discussions

fields

Former Member — Wed, 18 Apr 2007 05:47:02 GMT

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?

Re: fields

Former Member — Wed, 18 Apr 2007 05:49:46 GMT

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

Re: fields

Former Member — Wed, 18 Apr 2007 05:52:48 GMT

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

Re: fields

Former Member — Wed, 18 Apr 2007 05:52:55 GMT

Hi Balu,

Go to SE11, and there in the Data Element coloumn, type the field name and then click the WHERE-USED LIST 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

Re: fields

Former Member — Wed, 18 Apr 2007 05:53:16 GMT

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

Re: fields

Former Member — Wed, 18 Apr 2007 05:53:28 GMT

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

Re: fields

Former Member — Wed, 18 Apr 2007 05:54:56 GMT

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

try Transaction SE84 (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

plz dont forget to reward points if helpful

Re: fields

Former Member — Wed, 18 Apr 2007 06:01:37 GMT

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

Re: fields

Former Member — Thu, 19 Apr 2007 12:24:03 GMT

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.

Re: fields

Former Member — Thu, 19 Apr 2007 12:35:52 GMT

u can goto t-code SE11 and enter the field name in the DATA TYPE and then click on WHERE USED LIST icon...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 T-CODE - SE80 for Object Navigation purpose

this will surely help u,

Thanks,

Ginni