Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 29, 2015 at 05: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!

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 07: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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 07:56 AM

    Use report RSCRDOMA.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 08:57 AM

    Hi,

    As suggested by Michael use report RSCRDOMA

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

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded