A very useful tool to track usage of transaction: ST03N and STAD. This transaction can report on different levels how often a specific transaction is used and by which users. This can be handy in determining authorization profiles after Golive. It can also be used by Big Brother to check whether end user testing has really taken place.
SAP Mental Notes
SAP MM, SD, PP – Tips & Tricks
SAP Mental Notes 
is there any table to view Transaction usage history?
One of the problems with the SAP Standard solution is that the logs are gone after some time and it has information which is not requires. If you need detailed information pulled from Log the only way to do is write some custom reports
http://www.AuditBots.com
SAP Audit|SAP IT Audit|SAP Risk|SAP Controls