topic table name for structure fields in Application Development and Automation Discussions

table name for structure fields

Former Member — Fri, 25 Aug 2006 12:20:21 GMT

Hi,

How to find out the table name for fields which are in structure.

while finding the technical settings for the field in a standard application it shows only the structure and the field name but not sap table name . I need table name for the particular field.

thanks and regards,

Srisai

Re: table name for structure fields

Former Member — Fri, 25 Aug 2006 12:23:45 GMT

Hi,

One way of searching is, go to the data element of the field, and click on 'Where used list', this will list the tables that are using this data element of the field,

Hope this helps,

Rgds,

Re: table name for structure fields

Former Member — Fri, 25 Aug 2006 12:25:03 GMT

There is no straight forward method to achieve it you can do is to use SE11 and check on the where-used list. It would give you the list of prg/tables/views etc which use the same...analyze the same you would be able to get the way SAP populate the structure...Second method is to use the runtime analysis and check the DB hits and you would be able to get the necessary information.

Regards

Anurag

Re: table name for structure fields

Former Member — Fri, 25 Aug 2006 12:41:34 GMT

Hi,

Guess you are looking for how the field is getting the value. You can try starting the transaction in debug mode (using /h) and then add a watchpoint for the field and with value <> initial(leave the value box empty). This will help you find the point where that field gets populated. You can then traceback and find the exact table.

Saurabh