Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Fields

Former Member
0 Likes
899

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
873

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.

or

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.

7 REPLIES 7
Read only

Former Member
0 Likes
873

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

Read only

Former Member
0 Likes
873

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

Read only

Former Member
0 Likes
873

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

Read only

Former Member
0 Likes
873

hi,

DD02L ---tables (properties)

DD02T ---table texts

DD03L ---field properties

DD03T ---field texts

reward if its useful

Read only

Former Member
0 Likes
873

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.

Read only

Former Member
0 Likes
873

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

Read only

Former Member
0 Likes
874

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.

or

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.