The SAP table storing the transaction codes is TSTC, and description is TSTCT.
Transaction SE43N displays the area menus, but standard menus do not appear here.
T-code SIMG is used to see the SPRO menu.
Resources
DEPRECATED
This website allows you to find an SPRO / IMG path from a transaction code or description.