Create SAP index with "INCLUDE" clause

[Former Member]

Hi,

I were created an index in sql 2005, but I need create this index in ABAP dictionary, but this index has more than 15 fields, and the index has the clause include, ¿how can include the "INCLUDE" clause in ABAP dictionary?

This index is recommended by the DB02 transaction, and I've tried to recreate in SE11, but I can't do this, because SE11 only allow to create the index with primary keys...

I attach the SQL sentence...

USE

GO

/****** Object: Index Script Date: 01/15/2009 09:56:20 ******/

CREATE NONCLUSTERED INDEX ON .[/1SGS/DC14C889]

(

ASC,

ASC,

ASC,

ASC

)

INCLUDE ( ,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON

I don't know if SAP permit include this clause..

Best regards,

Thanks in advance,

[Former Member · Accepted solution]

i am also looking for this answer and saw this was entered already in this forum... if you want to just bump this and delete my question that is fine.

[Former Member · Accepted solution]

If anyone else is looking for this information I've created a blog about how I got it done here...

http://mattabase.com/archives/126

[Former Member · Accepted solution]

Mark thanks for the answer is helpfull

[Rudi_Wiesmayr]

Here it is!

http://service.sap.com/sap/support/notes/1775008

Kind regards

Rudi

[former_member212248]

I've tried to get to the link above but it is no longer active ... Not sure how to contact Matt Peters directly.  do you have any documentation on this still?

Thanks,
Melanie

[Rudi_Wiesmayr]

Matt Peters last logged in in March 2010 - mattabase.com has vanished ...

Seems that we have to look for another guy to answer our question ...

Kind regards from Austria

Rudi

[Former Member]

Anyone knows who can do it?