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: 

need to find where data is stored

Former Member
0 Kudos

Hello ,

I have transaction in which there is a table control. I am able to see some data in table control. When I press F1 on it for technical details I was seeing structure for that data. I need to know where this data is actually stored. How to find in which database table this data is present.

Thanking you.

Regards,

Rathod

9 REPLIES 9

Former Member
0 Kudos

There is no direct way of finding out. You can take the data element and see the where used list of that data element and figure which table has it.

Else, you can look at the item table of the document that you are looking at and see which field has the data.

Regards,

Ravi

Note - Please mark all the helpful answers

Former Member
0 Kudos

Navigate to the underlying program of the field and perform a Where-used on the structure. You will need to find what populates that structure.

Setting a breakpoint on all SELECT statements can be a quick way to find this as well.

Also - What is the t-code and field of interest?

Former Member
0 Kudos

I find the easiest way to do this is with a performance trace (ST05).

Rob

Former Member
0 Kudos

Hi,

With F1-Technical details, navigate to the screen where the table control is used.

In the PBO and PAI modules of the screen check from where the data is getting populated(search for SELECT) and to check where it is getting updated search for INSERT / MODIFY / UPDATE statements.

Hope it helps

Sameena

Former Member
0 Kudos

I agree with Rob - the easiet way is to use ST05 (if you can modify that data in table control). Just enable trace, modify your field, SAVE, disable & list trace, search for "update" :o).

Former Member
0 Kudos

Hi srinivas,

Don't think that that data is conming from database tables.Sometimes there is a chance that the data is coming from internal table in which the data is from diff. tables.

If you want debugg the code.

Former Member
0 Kudos

Hi

click on the field n click where-used list. You have to select database tables from the options and press enter.then the set of tables in which this field is used will be displayed.check out in each table....

Hope this helps

Swathi

Former Member
0 Kudos

Hi Srinivas,

If there is any F4 help available for that field , first get F4 help , then gofor F1 help on that screen , then Technical settings,

can u specify the transaction name

Former Member
0 Kudos

hi,

You can find data base table accessed by your program through transaction ST05