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

finding the field

Former Member
0 Likes
1,519

Hi,

I have field mob_number(mobile number) in the structure sza7_d0400,

so how can I know in which table it is.

Hi,

I have field mob_number(mobile number) in the structure sza7_d0400,

so how can I know in which table it is.

8 REPLIES 8
Read only

Former Member
0 Likes
1,278

Double click on the data element for this field and do click on where use button. It will gv u a list.

Rgds,

Pankaj

Read only

Former Member
0 Likes
1,278

go to the element of the desired field...

and do WHERE USED...

you'l get list of tables

Read only

Former Member
0 Likes
1,278

hi,

press F1 on that and see technical help.

There will b data element name, fieldname and table name.

and if u cant get table there than double click on data element and use where-used list...

or u can find perticular field through SE15...

reward if useful...

Read only

Former Member
0 Likes
1,278

hi

good

open the structure in se11, click on where used list button ,slect the database table and dis select other check buttons,click enter and see which are the table using that particular structre, then check with the table and use as per your requirement.

thanks

mrutyun^

Read only

Former Member
0 Likes
1,278

Hi

goto SE15(object navigator) in that u have REPOSITORY INFORMATION SYSTEM. in that u will have abap dictionary

with FIELDS name click on that u will get a screen asking about table name, field name , package etc

type ur field name in the field position and press F8.

list of tables will be appears.select the one u want

Thaks&Regards,

S.GangiReddy.

Read only

Former Member
0 Likes
1,278

Hi,

goto to se11...in the table name give 'dd03l'...

goto to contents ..then give ur field name in the row FIELD...u will be able to see the corresponding table name..

REWARD POINTS.

Regards,

Ari

Read only

Former Member
0 Likes
1,278

Hi,

The field mentioned by you mob_number is not available in the structure sza7_d0400 in my system.

May be that field is added by append structure and that is specific to your project only.

sp please check related ztables in your system.it may be available in ztable only as per my knowledge.

Thru where used list you get the list of tables using that dataelement.

Regds

Parvathi

Please reward points if helpful...

Read only

Former Member
0 Likes
1,278

hi freind,

first find the dataelemnt name for that field name..then goto that field name .

Double click on tht field name ....goto wher used list ..which will be available in standard tool bar...symbol is like square with three arrows. click on tht button you can find the list of table where your field is use...and check with master table or table...it gives most of the details..