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

how to search table fields ?

Former Member
0 Likes
1,112

Dear friends,

In standard applications (eg me23n) i want to know in which table field perticular field is stored. For that when I press F1 and go to technical settings then it shows that the same field is stored in structure. So r there some standard rules or procedures to find out in which database table the values in this fields r stored ?

madan.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,071

Hi,

You have to debug it and see how the structure fileds are getting populated,

as there may be some calculations or processing done before populating this structure fields.

Regards,

Raghavendra

Dear friends,

In standard applications (eg me23n) i want to know in which table field perticular field is stored. For that when I press F1 and go to technical settings then it shows that the same field is stored in structure. So r there some standard rules or procedures to find out in which database table the values in this fields r stored ?

madan.

7 REPLIES 7
Read only

Former Member
0 Likes
1,071

u can use <b>SE15</b> to find tables,fields,data elment etc

regards

aswin

Read only

0 Likes
1,071

Hi,

You can also do a trace using ST05.

( Active trace - do ME23n - Deactivate & display trace )

hope this helps,

erwan

Read only

Former Member
0 Likes
1,072

Hi,

You have to debug it and see how the structure fileds are getting populated,

as there may be some calculations or processing done before populating this structure fields.

Regards,

Raghavendra

Read only

Former Member
0 Likes
1,071

hi,

1. you can do a where used list on the structure and then may b in some Function module or program, this structure is used which may contain the DB Table details.

2.goto SE11 , give table name as DD03L , then display , give the fieldname as ur fieldname , then execute. It wil give all the tables having this field.

3.Perform SQL Trace (ST05)

4. Debug program

Read only

Former Member
0 Likes
1,071

<b>Hi

Like this way u can search...

Me23N->F1 on field name->technical settings->double click on the field name->

u will get the data element name->then double click on data element->see the where used list

Her u will see all the tables where this field has been used.

There u check the possible tables which will help u.

This the way.

Or u can use ST05 to trace all table fields.

Mark points if helpful.

Regs

Manas Ranjan Panda</b>

Read only

anversha_s
Active Contributor
0 Likes
1,071

hi,

You can find any type of field in SAP using this table in SE12.

Table-DD03L.

Regards

Anver

<b><i>if hlepd kindly mark points</i></b>

Read only

Former Member
0 Likes
1,071

Hi madan,

first gofor F4 help on that field , and then gofor F1 help on the field--> Technical settings , this will give u the correct table/view

pls reward if this helpful