You could, obviously, suggest that the client hire an experienced ABAP programmer who can figure out this stuff without spending a couple of years on it. Your team must have a lot of bandwidth if your client feels there are enough people and time to spend on a report of questionable value to anyone.
That said, if you go into your Transaction Maint/Create transaction (also known to experienced developers as SE93), put your cursor in the transaction code field and press F1, then choose the technical information icon, you will see that the table for storing transaction codes is TSTC. Now that you have that, an experienced developer would tell you that 'T' tables are usually configuration and customizing tables, and there usually is a 'tablenameT', like TSTCT, table which contain the titles, text, etc., values associated with that table's codes.
Then, there is the where-used icon, which may well be the most valuable piece of screen real estate in the SAP system, for technical folks. Learn to use those, and how to use data elements to find tables and structures and views, etc., and use the where-used tool to find programs...
You might also look at the code behind Transaction SE11. Enter a table name, then choose Menu Extras > Hierarchy Display... There are lots of tools to get this information in SAP, and since they all run in ABAP, essentially, you may find reusable code within the tools that go a long way toward your requirement.
Problem is, for SD, for example, how many objects, tables, structures, table types, etc., do you want to list? And, again, how useful would this be outside of the technical team? If this kind of thing is important to the client, why not (in the future, at least) create Z versions of all the development packages, and assign objects to those?
And, finally, STF! (search the forums) You'll find references to table TADIR, etc., since your client didn't invent this kind of request.
Bluesky
