topic how to find structure reference table in Application Development and Automation Discussions

how to find structure reference table

Former Member — Sat, 29 Jul 2006 05:13:05 GMT

Hi all

i want to ask "a structure is there how to find the reference master database table and field from that structure e.g suppose a structure ADDR2-DATA is defined but i can't find the reference MASTER DB TABLE from that with it's field

same with FKKOPK-BETRW how to find the REFERENCE OF MASTER DB TABLE for these STRUCTURE FIELD.

-how to fetch the data from structure in the program any code e.g

-is there any method to find the relation with in the structure to structure to fetch the data

Re: how to find structure reference table

Former Member — Sat, 29 Jul 2006 05:20:54 GMT

Goto SE12 -> give the structure/dataelement & press F7

If you give the structure name, then goto the corresponding dataelement & double-click over the dataelement.

Then click Where-used list & there check the Tables checkbox & click enter.

You can get the list of Tables in which the data element is used.

Kindly reward points for helpful answers!

regards,

Thangesh

Re: how to find structure reference table

dani_mn — Sat, 29 Jul 2006 05:24:23 GMT

HI,

Open your structure using SE11 and use 'WHERE USE LIST' button in application tool bar to find the database table in which this structure is used.

structure don't store data they have just one line of data that can be accessed using 'STRUCT-FIELD_NAME'.

Regards,

Wasim Ahmed

Re: how to find structure reference table

Former Member — Sat, 29 Jul 2006 05:35:30 GMT

Hi Gaurav

Goto SE12 and give the data element name of the field of structure.

In the date element display screen, check the where-used-list to find list of the tables in which the data-element is used to store the data.

Choose the right table from the list.

Best regards,

Phani

Re: how to find structure reference table

Former Member — Sat, 29 Jul 2006 09:52:30 GMT

hi,

goto SE80,

click on repository infomation system,

then selet the table,

click on execute,

go for it,

you will get it,

best of luck,

regards,

kcc