Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find all tables used in a set of programs

Former Member

‎04-09-2009 4:22 PM

0 Kudos

I need to find a list of all tables used in all Z programs. Originally I was thinking of getting a list of programs from table TRDIR, using READ REPORT for each one and then using Regex to get a list of tables used in SQL statements. However getting the regex working appears to be more complicated than first expected so I'm looking for other possibilities.

2 REPLIES 2

former_member194669
Active Contributor

‎04-09-2009 5:26 PM

0 Kudos

Use SAP standard program RPR_ABAP_SOURCE_SCAN and in the selection parameters

Program Name = Z*

Find String = SELECT

and execute

a®

Former Member

‎04-09-2009 5:44 PM

0 Kudos

Hi,

select programs from trdir and then select the tables used in it from WBCROSSGT where OTYPE = 'TY'

and INCLUDE = prog_name.... in the name field you will get the table name.

Regards,

Siddarth