Is there any way to trace which database tables is the data kept especially for those data are not straight forward? Sometimes you can do a /h to trace which database table keeps the data but sometimes you are unable to trace even by using /h.
Transaction ST05 (In 4.6C) allows you to perform an SQL trace, which will tell you the order and frequency in which database tables were accessed. SQL trace is also available in earlier versions.
This was first published in November 2002