Application Development 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: 

how to find a table if a field is given

Former Member
0 Kudos
107

how to find a table when a feild name is only given Ex: exapmle if i give matnr i should get all the tables that contain the field matnr

1 ACCEPTED SOLUTION

Former Member
0 Kudos
81

goto se80

|

click on repository information system

|

expand ABAP Dictionary

|

expand fields

|

double click on table fields

on the right side of the screen enter the fieldname/description of the field and press execute to find the tables where the field is present. once you get into one table you can know the others by clicking on the where used list.

regards,

srinivas

6 REPLIES 6

former_member188827
Active Contributor
0 Kudos
81

go to se11.giv ur field name against data type and click on where-used list...

plz reward points if dis helps

Message was edited by:

abapuser

former_member404244
Active Contributor
0 Kudos
81

hI ,

Goto tcode SE15/SE84...Now goto Abap dictionary folder then fields folder,now give ur field name and press F8 ,u will get all the table names.

Reward points if u find useful..

Regards,

Nagaraj

Former Member
0 Kudos
81

use the tcode SE15 under

REPOSITORY INFORMATION SYSTEM-----> GO TO FIELDS

-


>TABLE FIELDS-----> THEN ENTER THE FILED NAME AND

THEN EXECUTE

PLEASE LET ME KNOW IF THIS HAS ANY ERROR

Former Member
0 Kudos
81

go to t-code se11, enter the field name: MATNR

click where use list icon on the field, then choose table.. all tables will show up using that field name.

Former Member
0 Kudos
82

goto se80

|

click on repository information system

|

expand ABAP Dictionary

|

expand fields

|

double click on table fields

on the right side of the screen enter the fieldname/description of the field and press execute to find the tables where the field is present. once you get into one table you can know the others by clicking on the where used list.

regards,

srinivas

alejandro_bindi
Active Contributor
0 Kudos
81

You can search in table DD03L using the FIELDNAME field as key (in SE16/SE11 transaction).

Regards