2010 Jan 07 6:57 AM
Hi All,
Please help me to find out if there is any standard SAP functionality / alternate method to find the list of tables where a particular field has been used.
We already have this for data elements where in se11, we enter the value for data element and click on 'Where Used'. This gives the list of tables and strctures where this data element has been used. My question specifically deals with fields used in tables.
Thank you.
Hi All,
Please help me to find out if there is any standard SAP functionality / alternate method to find the list of tables where a particular field has been used.
We already have this for data elements where in se11, we enter the value for data element and click on 'Where Used'. This gives the list of tables and strctures where this data element has been used. My question specifically deals with fields used in tables.
Thank you.
2010 Jan 07 7:05 AM
Hi
There is a table DD03L in which you can find fields and their corresponding tables in which they are used.
Thanks
Khushboo
2010 Jan 07 7:05 AM
Hello Muthiah ,
In the popup for the where use list , there is a check box fo Table Fields , please check it and execute .
My system is ECC 6.0
Regards,
Arun
2010 Jan 07 7:07 AM
Hello,
In most cases the where-used list on the data element is sufficient enough to find where the particular field is used. If you are looking for a particular field , let us know the field name and the table
Vikranth
2013 Jul 24 7:25 AM
Hello Muthiah,
In initial screen of ECC, execute Transaction code SE11->SAP Application Components(SAP-R/3)->
choose any component(like MM in my case)->choose any data source(mine is 2LIS_02_S012)->double click on it->chose any FIELD name(mine is ALIEF)->double click on it->there are COMPONENT, which isone of the Data element of that particular FIELD.
2014 Feb 11 7:28 AM
Hello Niranchan,
Use the view in SE11 "DD03VT" and in the selection specify as below to get the list.
Incase if you want to find the field MATNR is used in how many tables specify as below.
Regards,
Thanga
2014 Feb 11 7:29 AM
2014 Feb 11 7:36 AM
Hi,
Please don't reopen old threads.
Anyway, another way of finding it out using
Tcode : SE84/SE90 ->Abap Dictionary->Fields-> double click on any of the options(Table fields,structure fields, view fields, lock object fields, match code fields )->on the right hand side put the field name and then execute.
Regards,
DPM