abap

How to retrieve a list of tables which are in my SAP system with ABAP program?


I need to retrieve a list of tables which are in my SAP system, can someone explain how to make this? I am new with ABAP. I have to write a program for this with input field for table name and value search.

Thank you.


Solution

  • You can query the following SAP tables to get the data:

    By selecting the data from DD02L you can put additional conditions to retrieve the tables you need. Most probably you may want to restrict the query to get:

    So you can start with the query:

      SELECT * FROM dd02l INTO TABLE @DATA(lt_tables)
         WHERE ( tabname LIKE 'Z%' OR tabname LIKE 'Y%' )
           AND as4local = 'A'
           AND tabclass IN ('TRANSP', 'INTTAB').
    

    and develop it further as you need according to your requirements.