10-29-2015 4:56 PM
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
10-29-2015 5:09 PM
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!
10-30-2015 7:54 AM
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
10-30-2015 7:56 AM
10-30-2015 8:57 AM
Hi,
As suggested by Michael use report RSCRDOMA
and uncheck the check-box " Only tables that are not empty"
Thanks.