topic Re: Fields in Application Development and Automation Discussions

Fields

Former Member — Wed, 20 Feb 2008 05:34:12 GMT

Hi,

How to find out the table for which the field belongs to. Sometimes the Field is assigned to structure. In that instance how to find out the corresponding Table for that field.

What is the use of DD03L Table ?

Thanks.

Re: Fields

Former Member — Wed, 20 Feb 2008 05:37:51 GMT

Take the field name and search where used list only in tables

Re: Fields

Former Member — Wed, 20 Feb 2008 05:37:59 GMT

Use WHERE USED LIST for the data element/domain of that field and then see the table decriptions

Re: Fields

Former Member — Wed, 20 Feb 2008 05:38:32 GMT

Hi,

U can use DD03L here u can give field name easly find the table name. otherwise u can use DD0* in se11.

Regards,

S.nehru

Re: Fields

Former Member — Wed, 20 Feb 2008 05:39:13 GMT

hi,

DD02L ---tables (properties)

DD02T ---table texts

DD03L ---field properties

DD03T ---field texts

reward if its useful

Re: Fields

Former Member — Wed, 20 Feb 2008 05:40:32 GMT

hi kedar,

If you want to find in which table the fields are stored, double click the dataelement of the corresponding field, goto utilities -> whereused list and in the popupscreen select the table field, you can get all the tables where the fields are stored.

Reward if helpful.

Subbu.

Re: Fields

Former Member — Wed, 20 Feb 2008 05:41:31 GMT

Hi,

go to se11 and give the table name as DD03L and in that u have a filed FILEDNAME there give the filedname for which u want to find the table then u can get only the tables which contains that filed. i hope this is clear to u..

Thanks

Sunil kumar Mutyala

Re: Fields

Former Member — Wed, 20 Feb 2008 05:50:35 GMT

Hi,

one of the way will be,

Go to se11,

type that structure name in the DATABASE area,

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 lgort field

Just double click the component type of lgort,

[this will take you to the domain part of the field type]

again double click the domain part,

this will take you to the definition part

now go to value range and look for value table this may have the transparent table name.

the otherway is,

Goto--> se80 --> click on the tab 'Resporatory information system' --> goto 'ABAP Dictionary' under the Object tab --> again goto 'Fields' --> open table fields.

Now type the field name in the field tab and press F8, this will give all the possible Table name associated with that Field entered.

Hope this Helps.