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
Showing results for 
Search instead for 
Did you mean: 

How to get list of all SAP tables with a specific domain

0 Kudos

Dear all,

I need to get the list of all SAP tables which have the SPRAS or SPRSL domain.

SE16 - DD02L - I get the list of all tables from a SAP system

Example : T5G5T

This table contains SPRSL domain.

Is there a way to get a list of all tables in a SAP system which contain SPRAS or SPRSL domain ?

I cannot login directly in the DB and I cannot start any SQL commands.

I only have access to SE11 or SE16.

Thanks

SAP Dev

4 REPLIES 4

Former Member
0 Kudos

In SE11, put SPRAS in Domain field and ensure the Domain radio button selected.  Then select the Where-Used List button (or Ctrl + Shift + F3).  Once you get the pop-up window, select the Indirect Application button.  From the list, double-click on Database Tables under Table Fields group.  This should provide you with the list you are looking for.  Hope this helps!

raymond_giuseppi
Active Contributor
0 Kudos

Or ask your admin for SE84 transaction, then navigate in Repository Information System to  Abap dictionnary, Fields, Table Fields, there expand selection and input  your domain name(s)

Regards,

Raymond

michael_kozlowski
Active Contributor
0 Kudos

Use report RSCRDOMA.

Former Member
0 Kudos

Hi,

As suggested by Michael use report RSCRDOMA

and uncheck the check-box " Only tables that are not empty"

Thanks.