Skip to Content
author's profile photo Former Member
Former Member

table name from field

Dear Sapers,

How to find table name from field name to write functional spec.Pl elaborate it for normal & zdevelopment.Points will be rewarded for useful answer.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2008 at 10:15 AM

    Hi Uday,

    Just for the sake of help this reply......

    You can find the name of tables by using F1 button keeping cursor on the respective field that you want to bring in development. From there you have to move to Technical details through technical details button.

    If that field or values are getting saved into some structure then you have to search the right database tables. According to your module many database tables are there (that you can search from sdn.sap.com directly). That totally depends on your report/development that you want to bring in......

    In any development deciding the right table for start up ( I mean to say tables that will give you input fields in your FS) is critical, latter you have to search linking tables and have to give logic about how to pass values from what to what field and what to what table..... In this case Transaction code SE11 and SE16 are useful......

    This all is slightly confusing and tedious too...... Closely work with you ABAPer to get into many things and have successful development....

    Have nice development....

    Cheers!

    Abu Arbab

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 10:26 AM

    Hi Uday,

    Select the filed-press F1 help.in that Technical Information button.You can find the Table Field name and the Table name.Many times you find the Structure name instead of Table name.then,to find the Data base table name,double click on the Data element name.Select 'where used list' and check for -Table fields.It will display all the DB tables for that data element.search for the exact one.It's quite a tedious Job if correct table is not found directly.Can use ST05-on the trace ,run the transaction,deactivate the trace ,find out the table .Or use SE84 as said by others.

    Hope this helps you,

    Regards ,

    Madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 01:42 AM

    Uday,

    I assume that you already know that a particular field will exist in multiple tables. So, I think you are asking "I have a field name. How can I find the Tables that contain this field name?"

    SE84 (Repository)

    then select ABAP Dictionary > Fields > Table Fields

    Fill in the Field name (wild cards are supported), leave the Table name blank. Execute. This will give you a listing of all tables that use the field name you specified.

    Regards,

    DB49

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 10, 2008 at 04:28 AM

    Dear,

    First go to the transaction then ursor on i/p field and click on f1

    and find out the field name & table..

    This is one method to find the field name and table name.

    The best way to find out table from field is,

    Use SE15 Transaction->dictionary fields ->table fields->goto table field columns

    Enter ur fields..

    or you can use ST05

    Goto SE84->ABAP dictionary ->Fields -> Table fields-> Field name-> Excute

    Hope clear to you.

    Regards,

    R.Brahmankar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.