topic Re: How to identify Table/Structure in Application Development and Automation Discussions

How to identify Table/Structure

Former Member — Thu, 26 Apr 2007 02:53:03 GMT

If i only know the description of a field..how can i identify the field name and the corresponding table or structure..

Former Member — Thu, 26 Apr 2007 03:07:15 GMT

u can goto DD03T table , give the description and get the fieldname

then goto DD03L , give the fieldname and get the possible table/structure

Message was edited by:

Chandrasekhar Jagarlamudi

Former Member — Thu, 26 Apr 2007 03:09:02 GMT

As far I know atleast u shud know the field name to find out the table r structur.

that is give the field name n choose ' where used ' button.

Former Member — Thu, 26 Apr 2007 04:51:48 GMT

Hi Chandrasekhar,

Thanks for your help but i couldnt get fieldname and table name for most of the field description...is there any other way to find it..

Former Member — Thu, 26 Apr 2007 04:54:35 GMT

hi,

chk out the table

dd03l and dd03t.

regards,

Navneeth.K

Former Member — Thu, 26 Apr 2007 04:57:01 GMT

Apart from finding the fields from DD03L table

With the description first find the data element in related to that description

and use where used list of that Data element it will show that data element used tables.

Again there will be more tables, you have to take the related Module and required ones only.

reward if useful

regards,

Anji

Former Member — Thu, 26 Apr 2007 04:59:33 GMT

Hi Thasneem,

can you write down the field descr. if possible we will let you know the fieldname and table.

regards,

Navneeth.K

jayanthi_jayaraman — Thu, 26 Apr 2007 05:17:46 GMT

Hi,

Use where-used-list to search the table ans structure contains that field.