topic Re: Table Name from Structure in Application Development and Automation Discussions

Table Name from Structure

Former Member — Tue, 04 Dec 2007 05:49:45 GMT

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

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

Transparent table for that fields.

Points will be definately awarded for useful answer.

cheers,

Kamal

Re: Table Name from Structure

kesavadas_thekkillath — Tue, 04 Dec 2007 05:53:06 GMT

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

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 05:53:43 GMT

goto se84

abap dictionary

fields

structure fields

give structure name

u get list of tables...

select required one...

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 05:55:31 GMT

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.

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 05:58:02 GMT

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,

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 06:01:59 GMT

Hi Kamal,

one of the way will be,

Go to se11,

type that structure name in the DATABASE area,

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 lgort

Just double click the component type of lgort,

[this will take you to the domain part of the field type]

again double click the domain part,

[this will take you to the definition part]

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

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

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 06:03:23 GMT

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.

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 06:03:47 GMT

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...

Re: Table Name from Structure

Former Member — Tue, 04 Dec 2007 06:08:28 GMT

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.

reward for useful answers

regards,

sunil kairam.