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: 

Table with list of secondary indexes

Former Member
0 Kudos

Hi All,

Is there any table in SAP that will list all the user created secondary indexes in the system?

The purpose is, in the last two years there were many secondary indexes created. We want to make a log of it and keep track of it.

Thanks in advance,

Regards,

Bhavya

3 REPLIES 3

ThomasZloch
Active Contributor
0 Kudos

You could try querying table DD12L with AS4USER <> 'SAP', this might still create some false alarms that you can filter out subsequently.

Thomas

Edit: Or use the repository infosystem (SE90) for table indices, and filter by name or package

0 Kudos

Hi All,

DD12L table gave me the list of indexes and thanks a lot for that information. But I am still faced with another problem. That is I cant find the creation date for any of the indexes that were created. There is only last changed date or the adjusted date.

Where can I find the creation date of the Indexes?

Regards,

Bhavya

nabheetscn
Active Contributor
0 Kudos

Check table DD12L and view DD12V

Nabheet