Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table Name from Structure

Former Member
0 Likes
2,230

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,351

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.

8 REPLIES 8
Read only

kesavadas_thekkillath
Active Contributor
0 Likes
1,351

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

Read only

Former Member
0 Likes
1,351

goto se84

abap dictionary

fields

structure fields

give structure name

u get list of tables...

select required one...

Read only

Former Member
0 Likes
1,351

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.

Read only

Former Member
0 Likes
1,351

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,

Read only

Former Member
0 Likes
1,351

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]

Read only

Former Member
0 Likes
1,351

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.

Read only

Former Member
0 Likes
1,351

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

Read only

Former Member
0 Likes
1,352

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.