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

Table Name from Structure

hi Friends,

i have one Structure and its corresponding fields .How can i find the Transparent

table for that corresponding STructure field. For eg : i hav one structure name

<b> COWB_ COMP</b> and its fields <b>ERFMG ,MATNR,LGORT</b> etc. I want to know the

<b><u>Transparent table</u></b> for that fields.

Points will be definately awarded for useful answer.

cheers,

Kamal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    Posted on Dec 04, 2007 at 06:08 AM

    Hai kamal,

    Go to GOTO>SE84>Abap dictionary>select structure> type structure name

    this is one way to find and go to se11->table name ->display click on the corresponding fields description where you can find the check table.

    <b>reward for useful answers</b>

    regards,

    sunil kairam.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 05:53 AM

    goto se84

    abap dictionary

    fields

    structure fields

    give structure name

    u get list of tables...

    select required one...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 06:01 AM

    Hi Kamal,

    one of the way will be,

    Go to <b>se11</b>,

    type that structure name in the <b>DATABASE area</b>,

    press display,

    [you will now see all the components of the structure]

    now if you want to know the transparent table name for that field say <b>lgort</b>

    Just double click the <b>component type of lgort</b>,

    [this will take you to the <b>domain part of the field type</b>]

    again <b>double click the domain part</b>,

    [this will take you to the definition part]

    now go to <b>value range and look for value table this may have the transparent table name</b>.

    [NOTE THIS IS ONE OF THE WAYS FOR FINDING THE TRANSPARENT TABLE]

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 06:03 AM

    Hi Kamal,

    For seeing the transparent table for structure fields.

    GOTO >SE84 >Abap dictionary >select structure > type structure name --> u will get the required tables.

    Please do reward if useful.

    Thankx.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 06:03 AM

    Hi Kamal,

    the procedure to find out is initially give tht structure name in se11 and then

    for which feilds u want to know the table name there u click on where used list icon as per ur structure u have given imagine tht u want vfdat fields tablename then in structure click on vfdat and click on where used list and select program or screen something then it will give u hint tht which tale this field exists.

    hope u try this it is easy to find ....

    Regards,

    sana...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 05:53 AM

    go to se11.

    give ur structure

    search u r field....double click on the component type...a small window will get opened....click the "where used list button" and check tables...

    reward if usefull

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 05:55 AM

    Hi,

    Goto tcode se84, Abap dictionary ->Fields -> Table fields.

    Give the name of the field and execute, it will give u the table name in which it is used.

    Regards,

    Vani.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 05:58 AM

    Hi,

    1.select the field within the structure and select where used list .It will show different tables of respect field.Then choose which is suitable for your requirement.

    2.Go to SE15 and select ABAP dictionary ,in that select fields option and mention the field name ,then execute it.

    Regards,

    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.