topic Re: error during INDEX creation in Application Development and Automation Discussions

error during INDEX creation

Former Member — Mon, 16 Nov 2009 12:54:26 GMT

Hi ,

I am trying to create Index on table D010TAB but it is giving error "Indexes Z1 and 0 for table D010TAB have identical fields".

When I tried to search for Index 0, I did not find it.

does the table have default index as 0 assigned?

Regards,

Saurbah

Re: error during INDEX creation

Former Member — Mon, 16 Nov 2009 13:19:50 GMT

Hi,

Since there are two fields, the index 0 implies primary key so try to create index with the change in order of the fields..

Try this order of index fields...This will allow..

TABNAME

MASTER

Regards

Shiva

Re: error during INDEX creation

Former Member — Mon, 16 Nov 2009 13:38:44 GMT


> does the table have default index as 0 assigned?
>

Hi saurabh kulkarni,

Answer is Yes and it consist of Primary Key Fields.

The ID '0 ' is reserved for the primary index. The name ranges 'Y..' and 'Z..' are reserved for customer indexes.

Also there is one more index 1 is present in table D010TAB with fields TABNAME & MASTER

Why you want to create duplicate index ? it's already present.

For more information about index please have a look at [SAPHelp|http://help.sap.com/saphelp_erp60_sp/helpdata/EN/cf/21eb20446011d189700000e8322d00/frameset.htm]

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: error during INDEX creation

Former Member — Mon, 16 Nov 2009 13:52:24 GMT

Hi Saurbah,

You cannot see index 0 (by convention the unique primary key index in every SAP table) in the SAP dictionary transations SE11/SE12. You can see it listed in SE14 and of course also by looking directly at the database catalog.

D010TAB has only two fields, and these together form the primary key. There is also a secondary index on the TABNAME field. That means there is absolutely no point in creating an extra index.

Regards,

Mark