Skip to Content
avatar image
Former Member

suppose i know only field name.how to find table name?

hi to all...

1...here is a requirement.

suppose i know the field name.but i don't know the table name in which that field is exiting.i want to find out the table.how i have to approach for this requirement.

thanks and regards,

k.swaminath.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Oct 10, 2007 at 12:56 PM

    hi,

    go to SE15.

    ABAP Directory-> Fields-> table fields.

    write ur field there and search for table

    reward if useful.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 12:56 PM

    Hi,

    go to transaction SE11 and use display datatype.

    Inside this view you can use "Referenz" STR-SHIFT-F3.

    Regards

    Nicole

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 12:57 PM

    Hi

    go to se80 >repository information system >ABAP Dictionary >fields >table fields

    give ur field name. take a particular table .

    go to se11.

    give the table name, take the cursor to the particular field and click on the where used list to get the other tables where the field is used.

    <b>Rewar dif usefull</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 12:59 PM

    Hi,

    goto table DD03L and give your filed name in field name column. and execute.

    it will show all tables where the field is being used sorted in relevance

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 01:01 PM

    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.

    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 WHERE-USED-LIST 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.

    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

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 01:03 PM

    hi,

    use the following navigation for your problem

    goto se85>abap dictionary>fields-->tablefields.

    doubleclick on the tablefields then you having the search options

    Please reward me points if you find this answer is useful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 01:08 PM

    hi,

    there is a very simple solution for that follow these steps

    go to se 11.. then go to domain and then write the domain of that data element then u get the domain name .. then for that where=>used=>list can be used to get the name of tables where the table is used..u ll surely get required table ......

    reward if helpful

    regards

    NIESH KUMAR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2007 at 01:23 PM

    HI,

    There are many ways to find.

    1. Go to domain of that field, go to value range tab there u will find value table.

    2. If not present go to DD03L , in selection screen of it give field name , u will get all table names in which that field exists.

    3. Or you can do it by SE80 also as explained earlier..

    reward if useful.

    Thanks,

    Madhura Nadgauda

    Add comment
    10|10000 characters needed characters exceeded