Application Development 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: 

Table Name from Structure

Former Member
0 Kudos

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

former_member202957
Contributor
0 Kudos

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

kesavadas_thekkillath
Active Contributor
0 Kudos

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

Former Member
0 Kudos

goto se84

abap dictionary

fields

structure fields

give structure name

u get list of tables...

select required one...

Former Member
0 Kudos

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.

Former Member
0 Kudos

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,

Former Member
0 Kudos

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]

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

former_member202957
Contributor
0 Kudos

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.