A Small tip to get all transparent tables used in ABAP code
If you need a list of all transparent tables used in a given ABAP class ( or function module, objects which belong to a given transport request, etc ) for analysis usage, you could follow the tips below, it is very simple but efficient.
Suppose you need to scan ABAP class CL_CRM_OPPORTUNITY_IMPL to find out all transparent tables used by this class.
1. use tcode SCI, create a new check variant:
Enable “Table Names from SELECT statements” and save variant.
2. create a new inspection:
Specify the class to be scanned, and load the check variant created in step one, then execute the inspection.
3. Once inspection is done, you see a green light and could get the inspection result by clicking button below:
All accessed tables are listed there:
Double click on each entry and the ABAP code will automatically be opened. Quite easy, isn’t it? 🙂
As we know that the code inspection is done statically by scanning source code so any other tables which are accessed dynamically by dynamic SQL in the runtime will not appear in the scan result of code inspector. If you need to get the COMPLETE list of the tables involved within a given part of ABAP codes, it is recommended to use transaction code ST05, ST12 or SAT to trace the scenario in the runtime.
1. ABAP Code inspector is far more than a static code scanner but in my opinion a powerful weapon which is for every ABAPer worth adding it to your toolbox. For more extensive usage on it to make your life easier, please read this document Useful tips regarding ABAP code inspector that you may not know .
2. Besides the approach to get accessed table list introduced in this blog, there is another approach using transaction code SQF, which is also done based on static code scan. For details please read ABAP static analysis tool SQF.