topic searching a table in Application Development and Automation Discussions

searching a table

Former Member — Thu, 04 Oct 2007 11:01:02 GMT

hi all,

i hv a field name. i want to search a table in which this field exist?

how i can do that?

e.g i have a field name kunre bill to party how i can search a table containing this field?

plz give steps.

i am new to abap.

Re: searching a table

Former Member — Thu, 04 Oct 2007 11:03:48 GMT

Hi,

You can use the SE84 transaction code to search the tables

Goto SE84 --> ABAP Dictionary --> Fields ---> Table fields,

Here Give the Field name and Press F8, then you will get all the Table names

Regards

Sudheer

Re: searching a table

Former Member — Thu, 04 Oct 2007 11:05:12 GMT

go to se84

and go for abap dictionary~~->fields~~-->table fields.

give ur field name and press enter , u will come across no of tables which this field is located.

in that u can choose which one suitable for ur requirement.

Reward if helpful.

Thanks

Re: searching a table

Former Member — Thu, 04 Oct 2007 11:09:43 GMT

but i dont no the table name

Re: searching a table

vallamuthu_madheswaran2 — Thu, 04 Oct 2007 11:10:02 GMT

hi,

se11~~> select DATA TYPE~~>give the field name and click the display button and place the cursor in DATA ELEMENT FIELD and select the where used list button. this button placed near execute button.

thanks & regards,

vallamuthu.M

Re: searching a table

Former Member — Thu, 04 Oct 2007 11:11:08 GMT

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.

<b>reward if usefull</b>

Re: searching a table

Former Member — Thu, 04 Oct 2007 13:14:59 GMT

HI,

1.GOTO SE11.

2.SELECT DATA TYPE THEN ENTER KUNRE.

3.IN APPLICATION TOOLBAR CLICK ON WHERE-USED LIST. I.E THE ICON WITH 3 ARROWS

4.POP UP WILL COME SELECT ONLY TABLES.

5.ENTER NOW

YOU WILL GET LIST OF ALL THE TABLES.