Skip to Content

How to use code inspector tcode SCI to find the list of tables against any tcode?

Hello All,

I was trying to find a method to fetch the list of all tables used in any program. Wanted same for identifying the list of tables in place in ny executable program. Noted a case, where we can find it using SCI(code inspector) by configuring the variant for the checkbox

Dynamic and Client-Specific Accesses with INSERT, UPDATE, MODIFY, DELETE under security check and again setting up an object set and inspection. But I was facing some issues with the build. Could you please advise if this can be achieved in the same manner. I was able to configure but with no data. Could you please drop in your suggestions.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Nov 04, 2019 at 03:49 AM

    Hi,

    You have to use it through transaction ST05. You have to use the option 'Trace Analysis using Code Inspector'.

    Here is the detailed blog:

    https://blogs.sap.com/2014/02/11/code-inspector-integration-into-sql-trace-of-st05/

    https://blogs.sap.com/2007/09/05/the-sql-trace-st05-quick-and-easy/

    Regards

    GK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 04, 2019 at 04:13 AM

    Hello J ABAP,

    Apart from the method suggested by Gaurav Karkara there is another simple way to do this, follow the below steps:

    1) Go to T-Code SE93 and enter the transaction you are interested to get the Master program details.

    2) Now reach out to the table D010TAB and enter the master program name in the field MASTER and execute.

    3) In the field TABNAME you will get all the tables used for this Program which also indicates the tables used for the T-Code. You will also get the obsolete details of the tables.

    Regards!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 04, 2019 at 05:32 PM

    Hi J ABAP,

    Looks like you need to get some static 'which-table-used' list for a given TCode - and then mass processing a list of TCodes. Any dynamic (ST05 and such) analysis will not cover your requirements. Neither will any approach to analyze TCodes individually.

    The problem with the Code Inspector in your use case is that it does not inspect Transactions - but that is not really the fault of the Code Inspector. But rather lies in the fact that a Transaction can call all sorts of programs.

    So your requirement is at least two-sided. First, you have to analyze the TCode to find the implementing method (by Report, Program, Class...) of the transaction. This is encoded in the Table TSTC, but somewhat convoluted. Check SAP Program SAPLSEUK Include LSEUKF01, Form 'select_tstc_tables_new' for how that works.

    Second, you have to somehow automate the Code Inspector. There are several ways to attempt this; but that IMHO goes beyond the scope of this forum.

    Sorry I could not give you a simple answer, but I still hope that helps to get you started.
    Mike

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.