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

Table name from Structure name

Former Member — Wed, 16 Apr 2008 01:41:28 GMT

Hi all

How do we get the correct table name from structure name?

As all know, we can get table name when we press F1->Technical Info.

But the Table Name in Field Data tab can be table or structure.

So, Im wondering how do we get the corresponding table name if Table Name in Field Data is a structure.

Thanks & Regards

Re: Table name from Structure name

Former Member — Wed, 16 Apr 2008 03:42:07 GMT

Hi,

There are two ways to find the table which you are looking at,

1) Do the F1 on the screen field and go to technical info, and click on the field name, if it is a structure then click on the data element of the field. and then do a where used list of the data element.(Select only tables in the pop up) and in the list of table you have to select the proper one.

2) You need to find out the screen program by going to system->status menu path.

then go to SE80.

enter the program name and see all the dictionary structures defined under that program.

and in the list you can easily find the one you are looking for.

Reward points if you find it useful.

Regards,

Prasanna

Re: Table name from Structure name

Former Member — Wed, 16 Apr 2008 05:08:08 GMT

try to find out the where used list of the structure.

ie,

SE11

give the structure name as Data Type

Display

Where used List

tick Database tables

Continue

Re: Table name from Structure name

Former Member — Wed, 16 Apr 2008 06:20:16 GMT

Thanks for the replies.

I've tried Where Used List before but there are too many hits and needs time to look each of them.

So I try to look for an easier and faster way, if its possible and available in SAP.

Thanks

Re: Table name from Structure name

Former Member — Wed, 16 Apr 2008 09:36:39 GMT

Hi,

you can find the table name through SE15.

1.Goto SE15.

2.Give the FIELD NAME.

3.Execute.

Then you can find the Different tables and structures.

try it once.

Reward the points if it is Useful.

Lakshmi....