‎2008 Feb 20 5:34 AM
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.
‎2008 Feb 20 5:50 AM
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.
‎2008 Feb 20 5:37 AM
‎2008 Feb 20 5:37 AM
Use WHERE USED LIST for the data element/domain of that field and then see the table decriptions
‎2008 Feb 20 5:38 AM
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
‎2008 Feb 20 5:39 AM
hi,
DD02L ---tables (properties)
DD02T ---table texts
DD03L ---field properties
DD03T ---field texts
reward if its useful
‎2008 Feb 20 5:40 AM
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.
‎2008 Feb 20 5:41 AM
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
‎2008 Feb 20 5:50 AM
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.