Fields and tables search

[Former Member]

Hi experts...

Can anybody tell me the best way to search the fields and tables...

Thank you in advance....

Regards,

Mahesh.

[Former Member]

Hi,

You can press F1 on the field...and then press technical info button..There you can get the table name and the field name.....If the table name is not available then use the data element and put a where used list in SE11 for that data element..You can find where the fields are being used in the tables

Thanks

Naren

[Former Member]

Thanq Narendran,,,

I got u... But where can type the field description..

just give me the clarity...

Thank you...

Regards,

mahesh.

[Former Member]

Go to Tcode:se84->Select ABAP Dictionary>here U select either Table or fields etc..

Please give me reward pointss...

[naimesh_patel]

Another way to search for the fields and tables is the SQL trace... ST05

Open your transaction in one Session

Open another session for ST05 .. Start the trace with the filter for the user

Come to first session.. do your processing.. or reach to the screen for which you need the data...

Come to second session and stop the trace..

List trace...

Here you will all the tables which were accessed in that perticular transaction..

Regards,

Naimesh Patel

[Former Member]

Thank you for ur reply...

But i didnt get u properly...I have only the fields descriptions..

So, how can i search the fields and tables By using the Field descriptions...

So, plz give me the clarity...

thank you ...

Regards,

Mahesh.

[Former Member]

Hi

Mahesh,

Use SE84

> R/3 Repository Information Sys

> ABAP Dictionary

> Fields

>Table fields

<b>OR</b>

Goto SE11.enter table name .press display.then press ctrl F and enter the description of the field.press enter . u will the get the field regarding to the given description.

If u want to search table name for given field,then.

Goto se84->ABAP Dictionary->fields>table fields.double click on it.

Enter the table name or field name or description. u will get all the tables in which that field is used

<b>

OR</b>

You can you check DD03T..

<b>

Or</b>

You can use SE11..Give the table name..Press display..Press CTRL + F4..give the description..

<b>OR</b>

go to se15 click ABAP dictionary>fields>tablefields(dbl click) give the field name in the right hand side window. press execute it will show you the tables which contains the field.

other way take the dataelement of the field and use where used list..

<b>Rewards if helpful.........</b>

[Former Member]

HI

suppose if you opened any T-code you want to know some filed name and table name for screen element

then put cursur on that screen field and press F1 then it will show you some description of the field

then clcik on Technical Details button which will exist on the top for that descriptions

then it will show total information about that screen feild from which table and what is field name etc..

[Former Member]

Hi Mahesh,

se11 will help if you already know the name of the table.

Also you cn checkout the DD03L table for the details of any database table.

Regds,

Gaurav

[Former Member]

Hi,

->go to se84 (object navigator)

->abap dictionary

->expand the tree structure

->choose fields (expand the tree structure)

->select the table fields and enter the search criteria and execute

->you will get the required information

->for furthur information you can use the where used list

<b>reward points if useful.</b>

regards,

Vinod Samuel.