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.
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.